Question

1. A car dealer believes that average daily sales for four different dealerships in four separate states are equal. A random sample of days results in the following data on daily sales:

Ohio New York West Virginia Pennsylvania

3    10 3 20

2 0 4    11

6 7 5 8

4 8 2

4 0     14

7

2

Use ANOVA to test this claim at the 0.05 level.

Then use Excel to support you answers to this question. Submit your completed Excel spreadsheet (upload PDF Excel Worksheet, so it can be downloaded)

Answer 1

In Excel, using Data -> Data Analysis -> ANOVA : Single Factor, we get the following output :

Since P-value > 0.05, so we fail to reject the null hypothesis and we can conclude that average daily sales for four different dealerships in four separate states are not significantly different.