basic statistics

1
Sheet 1 Page 1 Basic Statistics from Raw Data Sales Data Data Entry Measures of Central tendency 1 33 2 26 Mean 26.9 Median 22 Mode 18 3 24 4 21 Measures of Dispersion 5 19 If the data is of a 6 20 Sample Population 7 18 Variance 139.884211 132.89 Range 38 8 18 St. Dev. 11.8272656 11.5277925 IQR 8.5 9 52 10 56 Skewness and Kurtosis 11 27 If the data is of a 12 22 Sample Population 13 18 Skewness 1.65371559 1.52700876 14 49 (Relative) Kurtosis 1.60368514 0.94417958 15 22 16 20 Percentile and Percentile Rank Calculations 17 23 18 32 x y 19 20 50 22 22.0 47 20 18 80 32.2 32.2 80 90 49.3 49.3 90 Quartiles 1st Quartile 19.75 Median 22 IQR 8.5 3rd Quartile 28.25 Other Statistics Sum 538 Size 20 Maximum 56 Minimum 18 Chebyshev's Theorem observation Data points within 1.5 Std. Devns from mean 17 out of 20 which is 85.00% Minimum predicted by Chebyshev's Theorem 55.56% Minimum predicted by Empirical Rule 86.64% x-th Percentile Percentile rank of y

Upload: adeniyi-alese

Post on 14-Sep-2015

9 views

Category:

Documents


0 download

DESCRIPTION

DOC

TRANSCRIPT

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.