A toy company is concerned that its distribution strategy is not working. Sean Masterson, the marketing manager stated that one of the primary goals in the distribution of a particular toy is to keep the prices similar throughout all their distribution channels. To find out if their strategy is failing, the marketing department took a survey of 5 different outlets in three different channels. The price results are in the following table:
Using ANOVA, determine if there is a significant difference in prices between the three channels. Mr. Masterson wants to be 90% confident, so list all the steps of the hypothesis test and do the calculations then write a memorandum to Mr. Masterson stating your conclusion and backing it up with statistical analysis
Please attach excel file.
|
Store
|
Web sales
|
Discount stores
|
Department stores
|
|
1
|
12
|
15
|
19
|
|
2
|
13
|
17
|
17
|
|
3
|
14
|
14
|
16
|
|
4
|
12
|
18
|
20
|
|
5
|
15
|
17
|
19
|