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: 3, 2, 6, 4, 4, 7, 2

New York: 10, 0, 7, 8, 0, Blank, Blank

West Virginia: 3, 4, 5, Blank, Blank, Blank, Blank

Pennsylvania: 20, 11, 8, 2, 14, Blank, Blank

Use ANOVA to test this claim at the 0.05 level.

Use Excel to support you answer. Submit a completed Excel Spreadsheet (Upload spreadsheet so I can download it).

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.