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

log in to your account

Don't have a membership account?
REGISTER

reset password

Back to
log in

sign up

Back to
log in