Using Excel, prepare a linear regression equation for the following data and use it for prediction.
Question: 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 |
(a) (5) Paste your Excel printout here, or attach it to this assignment.
(b) (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 answer consists of 2 pages
Deliverables: Word Document
Deliverables: Word Document