Where y is the mean weekly gross revenue expected for

Info icon This preview shows pages 3–4. Sign up to view the full content.

View Full Document Right Arrow Icon
where Y is the mean weekly gross revenue expected for a weekly TV advertising budget of x1 and a weekly newspaper advertising budget of x2 (all in $K). The R^2 is 0.9190 (in cell B5). This means that 91.9% of the variation in the actual values of y is due to varying x1 and x2 according to the regression equation. The adjusted R^2 is 0.8866 (in cell B6). This means that after discounting for using two independent variables in the multiple regression, 88.66% of the variation in the actual values of y is due to varying x1 and x2 according to the regression equation. This is a truer representation of the variation in y accounted for by the model. (However, 12.34% [= 100% - 88.66%] is not accounted for by the multiple regression. Some of this unaccounted-for variation is due to random error. Most of this unaccounted-for variation is probably due to a still missing or “omitted” variable.) The adjusted R^2 of the multiple regression is significantly higher than the R^2 of either simple linear regression. Therefore the multiple regression is the best of all the regressions performed. Moreover, the multiple regression is a good predictive tool, because the adjusted R^2 is high. Suppose in some week, $3500 is spent on TV advertising and $1800 is spent on newspaper advertising. How much is expected to gross revenue is expected to be earned for that week? (This is asked for part d of the problem.) Let x1 = 3.5 and x2 = 1.8. Then Y = 83.2301 + .(2.2902*3.5) + (1.3010*1.8) = 83.2301 + 8.0157 + 2.3418 = 93.5876 So the gross revenue is expected to be $ 93,587.60. ASW 5e Prob 13.5 (p. 541) 3 © 2008 Harvey Singer
Image of page 3

Info icon This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
(New question) Suppose in some week, $5000 is spent on TV advertising and $1500 is spent on newspaper advertising. How much is expected to gross revenue is expected to be earned for that week?
Image of page 4
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

What students are saying

  • Left Quote Icon

    As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

    Student Picture

    Kiran Temple University Fox School of Business ‘17, Course Hero Intern

  • Left Quote Icon

    I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern