Question: Please help me with this problem from my management science class. 138 CHAPTER 4 - REGRESSION MODELS To computer. we use the following table: M

Please help me with this problem from my management science class.
138 CHAPTER 4 - REGRESSION MODELS To computer. we use the following table: M (11 - 9)2 = 4 5 2 7 10 (11 972 = 4 (6 - 97 = 9 (10 - 9 = 1 (6 - 9) = 9 (12-9 9 (Y- = 32 SST 16 2 (10 - 11 - 1 (6 - 6)2 = 0 (12 - 12) = 0 SIY - 7) = 6 SSE 6 12 SY 45 EX 15 The slepe (= 1) tells us that for each l-unit increase in X for $100 in advertising , sales increase by 1 unit (or $1,000). Also, * = 08125, indicating that about 814 of the variability in sales can be explained by the regression model with advertising as the intependent variable. Solved Problem 4.2 Use Exel with the data in Solved Problem 1-1 to find the regression model. What does the F test say about this model Solution Program 43 povides the Excel cutput for this problem. We see the equation is The veellicant or determination in der to be 0.8125. The significance level for the Flestis o inn, which is less than 00s. This indicates the model is stilistically syndicant. This, there is sul ficient evidence in the data to conclude that thic model is useful and there is a clationship between X for Soled V 12 5Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
