Question

Celebrity Xpedition Siver Shadow siver wind SeaDream Wind Star Wind Sur wind Spird 6.4 2.1 a. Determine an estimated regression equation that can be used to predict the overall score gwen the score for Shore Ecursons (to 3 deoimals) Overall th. Consider the adation of the independent varstble Foodiining Develop the esmated regression eaton tc b st deamals), Overall Shore Exeursions + Food/Dinieg with a Shore Excursions score of 80 and a Food/Dg Sooe of 90 (to 2 decimais) 3/23/2019 0 Type here to search DOLL st

Answer 1

a. Overall=69.633+0.231 Shore Excursion

Overall Shore Excursion Food/Driving SUMMARY OUTPUT 94.2 93.2 92.8 91.2 90.7 90.4 90.2 90.1 89.3 89 89.2 88.9 88.8 87 87.4 86.4 86.1 86 86 85.4 91.1 84.2 99.9 94.7 88.1 81.9 86.2 92.4 85.9 83.4 82.2 93 78.2 91.9 75 78.1 77.5 76.7 72.2 77.4 97.8 96 Regression Statistics 88.4 Multiple R 97.2|R Square 91.3 Adjusted R Square 98.9 Standard Error 91.9 Observations 0.682702483 0.46608268 0.436420607 1.918343024 20 89 90.7 ANOVA 90.7 88.5 Regression 89.8 Residual 91.2 Total 73.7 89 91.4Intercept 91.1 X Variable 91.4 89.3 92.1 MS nificance F 57.82478075 57.82478 15.71309 0.00091 66.24071925 3.68004 18 19 124.0655 Coefficients Standard Error t stat P-value Lower 95% U er 95% 4.933557976 14.11407 3.55E-11 59.2675472 79.9975886 0.058164196 3.963973 0.00091 0.10836288 0.35275977 0.230561327

b.

Overall=44.780+0.250 Shore Excursion+0.255 Food/Driving

2 Overall Shore Excursion Food/Driving SUMMARY OUTPUT 94.2 93.2 92.8 91.2 90.7 90.4 90.2 90.1 89.3 89 89.2 88.9 88.8 87 87.4 86.4 86.1 86 86 85.4 91.1 84.2 99.9 94.7 88.1 97.8 96.7 88.4 Multiple R 97.2|R Square 91.3 Adjusted R Square 98.9 Standard Error 91.9 Observations Rearession Statistics 0.852932401 0.727493681 0.695434114 1.410228031 20 86.2 92.4 85.9 83.4 82.2 93 78.2 91.9 9 89 90.7 ANOVA 90 88.5 Regression 89.8Residual 91.2 Total 73.7 89.7 91.4Intercept 91.1 X Variable 1 91.4 X Variable 2 89.3 92.1 10 MS gnificance F 90.2568673 45.12843 22.69194 1.5875E-05 33.8086327 1.988743 19 124.0655 16 78.1 77.5 76.7 72.2 77.4 coefficients | Standard Error t Stat P-value Lower 95% Up er 95% 44.78007754 0.249818117: 0.043023221 5.806588 2.1Е-05 0.15904705 0.34058918 0.255110847 18 19 20 7.143379725 6.268752 8.48Е-06 29.7088637 59.8512914 0.063172901 4.038296 0.000853 0.12182768 0.38839402 23

c. If Shore Excursion score=80, Food/Driving score=90 then Estimated overall score=44.780+0.250 *80+0.255*90=87.73