Solution: (10) The table below shows the number of HDTVs sold at three chain stores owned by the same company in the four quarters of the last fiscal year.
Question: (10) The table below shows the number of HDTVs sold at three chain stores owned by the same company in the four quarters of the last fiscal year. Process the data by Excel using its two-way ANOVA without replication program.
| Store 1 | Store 2 | Store 3 | |
| Quarter 1 | 69 | 121 | 103 |
| Quarter 2 | 74 | 102 | 64 |
| Quarter 3 | 65 | 212 | 126 |
| Quarter 4 | 228 | 369 | 305 |
-
(5) Paste your Excel printout here, or attach it to this assignment.
Source of Variation SS df MS F P-value F crit Rows 91633.67 3 30544.55556 30.34562 0.000505 4.757055 Columns 17008.67 2 8504.333333 8.448946 0.017991 5.143249 Error 6039.333 6 1006.555556 Total 114681.7 11 - (5) Test the null hypothesis, H0: \[{{\mu }_{1}}={{\mu }_{2}}={{\mu }_{3}}\] . Explain what the outcome of the test tells you about either of the main effects.
Price: $2.99
Solution: The downloadable solution consists of 2 pages
Deliverable: Word Document 