1.A travel magazine provided ratings for the top 10 small cruise ships. The data shown below are the scores each ship received based upon the results from their survey. Each score represents the percentage of respondents who rated a ship as excellent or very good on several criteria, including Shore Excursions and Food/Dining. An overall score was also reported and used to rank the ships.

a.Develop an estimated regression equation that can be used to predict the overall score, given the score for Shore Excursions.

b.Consider the addition of the independent variable Food/Dining. Develop the estimated regression that can be used to predict the overall score, given the scores for Shore Excursions and Food/Dining.

c.Predict the overall score for a cruise ship with a Shore Excursions score of 80 and a Food/Dining score of 90.

d.Based on R2 on the model in part (a) and (b), which model fits better?

e.Perform an F test for the model in part (b) using ? = 0.05. Is there significant relationship between overall score and all other scores?

f.Perform t tests for the model in part (b) using ? = 0.05. Are the independent variables significant? Should a variable be dropped from the model? Explain.

AutoSave O Off) HUB Final_Exam_STAT8097_Business_Statistics_OL_.pdf-converted - Compatibility Mode - Word Search Sign in X File Home Insert Draw Design Layout References Mailings Review View Help Share Comments Trebuchet MS ~ 12 ~ A" A" Aa* A Find LO X Cut AaBbCCD AaBbCc[ AaBbCCD AaBbCCD AaBbCcD AaBbCc Paste [ Copy Gc Replace BIU XX ALA. 1 Normal 1 Body Text 1 List Para. 1 No Spac... 1 Table Pa... T Heading 1 - Select Editor Format Painter Clipboard Font Paragraph Styles Editing Editor Ship Overall Shore Excursions Food/Dining A 94.5 90.9 97.8 B 93.0 84.2 96.7 C 92.9 100.0 88.5 nmg 91.3 94.8 97.1 90.5 87.9 91.2 90.3 82. 1 98.8 G 90.2 86.3 92.0 H 89.9 92.6 88.9 Page 1 of 3 STAT8097 - Business Statistics (OL) BINUS BUSINESSSCHOOL https://www.coursehero.com/file/65607872/Final-Exam-STAT8097-Business-Statistics-OLpdf/ 89.4 85.9 90.8 89.2 83.3 90.5 Page 2 of 4 986 words DX English (United States) Focus + 100% 22:46 O O W A ( 1 / ENG 10/11/2020