Question

Work on Excel

Open: GasMiles.xlsx.

If you can download MegaStat Add-ins. Otherwise, just run the Summary Statistics in Excel. Run a Descriptive Statistics. Include Mean, Sample Variance, and Standard deviation. Derive all these sample statistics using Excel. [ If MegaStat is available: Find Max-Min-Range, Median-Quartiles-Mode-Outliers, Sum-Sum of Squares, Standard error of the mean, Emperical Rule, Confidence interval, Skewness-Kurtosis-CV, Boxplot, DotPlot, Stem and Leaf ]

Mileage

30.8

31.7

30.1

31.6

32.1

33.3

31.3

31

32

32.4

30.8

30.4

32.5

30.3

31.3

32.1

32.5

31.8

30.5

30.5

32.1

31.4

30.8

32.8

31.9

31.4

32.4

31

29.8

31.1

32.3

32.7

31.2

30.7

31.7

31.4

32.2

31.5

31.7

30.7

32.7

31.4

31.8

31.9

33

31.5

31.6

30.6

32.3

31.4

Answer 1

Copy and paste the data set into excel sheet from cell A1:A51 (including labels in first row)

Click on Data tab

Go to Analyse and click on Data Anlysis

Select Descriptive statistic option and click Ok

set input range as $A$1:$A$51

Check "Labels in first row" button

Select option "Summary Statistics"

Click Ok

Result is shown below

Mileage
Mean	31.56
Standard Error	0.112812
Median	31.55
Mode	31.4
Standard Deviation	0.797701
Sample Variance	0.636327
Kurtosis	-0.51125
Skewness	-0.03422
Range	3.5
Minimum	29.8
Maximum	33.3
Sum	1578
Count	50