Question

f-i please

The accompanying data are from a simple random sample of 10 Hollywood movies that were based on best-selling novels. The variables considered are y = first year box office receipts (in millions of dollars), X = total production costs (in millions of dollars), x2 = total promotional costs (in millions of dollars), and Xa= total book sales in millions of dollars). X2 4.7 8.5 12.9 5.2 10.7 5.1 5.8 2.1 8.4 8.8 15.1 12.2 10.6 3.1 2.9 85.1 106.3 50.2 130.6 54.8 30.3 79.4 91.0 135.4 89.3 3.5 3.5 9.2 1.2 3.7 9.0 7.6 9.7 5.9 20.8 7.9 7.7 15.1 10.2 4.5 Use SPSS to answer the following questions. Include all of the relevant SPSS output, and circle on the output the values you used to answer the questions. a. Are the assumptions for multiple linear regression met? Check all assumptions. b. Test the utility of the multiple regression model at the 1% significance level. c. Use the backwards elimination procedure to determine the best fitting multiple regression equation to predict first year box office receipts. Show All tests involved (use aa 0.01), and give the equation of the final (best fitting) model. d. What is the Adjusted R' value for the best fitting model? What does that value tell you? How does it compare to the regular R? value? e. Are there any problems with multicollinearity? Explain how you know.

Answer 1

Here is your answer..
& first year for the data box-office alven for 10 movies having their recipt as following! 85.1, 106.3, 50.2, 130.6,548, 30.3, 79. 4 91.01 135.4189.3 The mean Gross first year box office = 21 = 85-1 +106-3+502 +130.6 +84.8+ 30-3+79.4 +91-0 HIIS 4+23 16 85.29 million dollars) Now standard deviation = Su-7 1² = 0.0196 +443.5216 + 1227.8016 + 2057.5296+ 926.5936 +3018.4016 + 34.1056 + 33.1276+2516.0256 + 16.4836 Slx-Xta 10,273.664 SD = 101273.669 32.05 10 Now to find - SE (Marginal amor so - 31.05 32.051 210135 3.1622 vn

Now for 99% of confidence imovel azt = 2.176. > & enora 10.135 x 2-576. = 26.1080. a multiple linear regressim moda Now consider as - Y = 9ot boxit bit + b2 13 where ao is y when boblobzce X1 212=X=0 * so for boxofice Recipts = x12t2 = X3=0 then go o (= boxitbix2 + b₂x3 for X 1 = 8.51% = 5.1 , X 3 = 4.7, Y= 85. 1 i 85.1 = 8 sbot solby + 4.7b2 - ④ Similarly for x1 = 5. 2 42 =2. 1 X3= 15.1, Y = 50.2 - . 50.2 = Sebot eilbit is.163 -

Also for xi - 3.1142 = 2.9, x3 = 10.6 1Y = 54.8 54.8= 3.160+2.9 by + lo.sby 11 solving these 4 linear equations we get bo = 0.986008 b = 14.ogal be = 1.02415. .. Y = 0.98600881+14.0991 X + 1.0241583 Now x = 10.5 X2=4.9 X3 = 13.3 y = 8 98600 8x10 st 14.0991x4.9 +102415813.3 y = 8.09 390 + 69.68559+ 13 621195 82.800685 Kut the confidurce interval a C.I= y + 26.1086 82800685 +26.1086 c.I=

Here X = 9.6 X 2= 3.7 X3= 10.2 Y = 98600 8x9.6+ E 9.4656+ 14.099183 7+ 1.02415X10.2 52.16667 + 10.44633 72.8786 C. I= 72.0786 126-10861 As we see X 85. 29. ni = 8.74 X = 4.9 X₂ = 9.92 i for 21 x3 = constant x = 8.74 + = 9.74 then average change in Y- 9.748 6086088+ 14.099 1x 4.9+ 1.024158 9 92 E 9.60377 29.0855 + 10.159564 y = 88.848 BY = DY = 88.848 - 85.24 3.608 million dolbers)

in we have y = 0.98600881 +14.0991X2 + 1.029&z X1 = 9.6, X2 = 3.7 x3 = 10:2 theni Y = 0.98604 9.6 + 14.099183 77 1024 X 10.2 Y= 9.465678 +52.16667 +10.448 Y = 72.077148 < 80 milion dollars.