3. A business consultant believes consumers equally prefer four brands of coffee (A, B, C, D). He collects a random sample of 400 consumers with the following results on preferences: Observed...

Extracted text: 3. A business consultant believes consumers equally prefer four brands of coffee (A, B, C, D). He collects a random sample of 400 consumers with the following results on preferences: Observed Frequency of Preferences Brand A 102 В 121 120 57 Use a Excel spreadsheet to test this hypothesis at the 0.05 level. Submit the Excel spreadsheet you create along with an explanation of results (either in your pdf or on the Excel spreadsheet