Using Excel data analysis compute distribution and interpret the result.
The fuel efficiencies for a sample of 27 compact, midsize and large cars are entered into a statistical software package. Examination of variance is used to investigate if there is a difference in the mean mileage of the three cars. Describe what do you conclude? Use the .01 significance level.
Summary








Groups

count

Sum

Average

Variance




Compact

12

268.3

22.35833

9.388106




Midsize

9

172.4

19.15556

7.315278




Large

6

100.5

16.75

7.303







Anova





Source of Variation



SS

df

MS

F

pvalue

Between groups



136.4803

2

68.24014

8.258752

0.001866

Within groups



198.3064

24

8.262766



Total



334.7867

26



