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
|
p-value
|
|
Between groups
|
|
|
136.4803
|
2
|
68.24014
|
8.258752
|
0.001866
|
|
Within groups
|
|
|
198.3064
|
24
|
8.262766
|
|
|
|
Total
|
|
|
334.7867
|
26
|
|
|
|