Question: Use the regression model to make predictions for year 1 0 . note that the regression model coefficients are stored below the data table, highlighted

Use the regression model to make predictions for year 10. note that the regression model coefficients are stored below the data table, highlighted in green. if csu sells the magazine for $20 each, how much revenue (total sales $) does the regression model predict for year 10? format the value as a us dollar.
*I used the below formula in excel in cell C59 and then drug it down. I then added the total and multiplied it by 20 to get $484,023.52 which I was thinking is the answer, but I'm not sure if this is correct.
=1888.045086+(D59*-191.556963)+(E59*-7.450144)+(G59*0.056551)+(H59*0.061592)+(I59*732.2201265)
 Use the regression model to make predictions for year 10. note

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!