basic statistics
DESCRIPTION
DOCTRANSCRIPT
Sheet 1Basic Statistics from Raw DataSales DataData EntryMeasures of Central tendency133226Mean26.9Median22Mode18324421Measures of Dispersion519If the data is of a620SamplePopulation718Variance139.8842105263132.89Range38818St. Dev.11.827265555811.5277925033IQR8.59521056Skewness and Kurtosis1127If the data is of a1222SamplePopulation1318Skewness1.65371559141.52700875761449(Relative) Kurtosis1.60368514450.944179584515221620Percentile and Percentile Rank Calculations1723x-th PercentilePercentile rank of y1832xy1920502222.04720188032.232.28009049.349.39000Quartiles01st Quartile19.750Median22IQR8.503rd Quartile28.2500Other Statistics0Sum5380Size200Maximum560Minimum1800Chebyshev's Theorem observation0Data points within1.5Std. Devns from mean170out of200which is85.00%0Minimum predicted by Chebyshev's Theorem55.56%0Minimum predicted by Empirical Rule86.64%00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
&APage &PEnter the data in this column. Do not leave any blanks or stray numbers. Remember to delete all the old data.