Please check my work and answer d

An overall score was also reported and used to rank the ships. The highest ranked ship, the Seabourn Odyssey, has an over the highest component of which is 97.8 for Food/Dining. Ship Overall Itineraries/ Shore Food/ Schedule Excursions Dining Seabourn Odyssey 94.4 94.6 90.9 97.8 Seabourn Pride 93.0 96.7 84.2 96.7 National Geographic Endeavor 92. 9 100.0 100.0 88.5 Seabourn Sojourn 91.3 88.6 94.8 97.1 Paul Gauguin 90.5 95.1 87.9 91.2 Seabourn Legend 90.3 92.5 82.1 98.8 Seabourn Spirit 90.2 96.0 86.3 92.0 Silver Explorer 89.9 92.6 92.6 88.9 Silver Spirit 89.4 94.7 85.9 90.8 Seven Seas Navigator 89.2 90.6 83.3 90.5 Silver Whisperer 89.2 90.9 82.0 88.6 National Geographic Explorer 89. 1 93.1 93.1 89.7 Silver Cloud 88.7 92.6 78.3 91.3 Celebrity Xpedition 87.2 93.1 91.7 73.6 Silver Shadow 87.2 91.0 75.0 89.7 Silver Wind 86.6 94.4 78.1 91.6 SeaDream II 86.2 95.5 77.4 90.9 Wind Star 86.1 94.9 76.5 91.5 Wind Surf 86.1 92.1 72.3 89.3 Wind Spirit 85.2 93.5 77.4 91.9 (a) Determine the estimated regression equation that can be used to predict the overall score given the scores for Itin Shore Excursions, and Food/Dining. (Let X1 represent Itineraries/Schedule, X2 represent Shore Excursion, X3 represe represent Overall score. Round your constant term to one decimal place and coefficients to two decimal places.) *= 0.25ex+ 69. 30 58.0 - 0. 01 x, + 0 . 15 x 2 + 0. 21 x3State the null and alternative hypotheses. O Ho: B1 = B2 = B3 = 0 Ha: One or more of the parameters is not equal to zero. O HO: Bo = 0 Ha : Bo * 0 Ho: One or more of the parameters is not equal to zero. Ha: B1 = B2 = B3 = 0 K HO: B 1 = B2 = B3 = 0 H : All the parameters are not equal to zero. O Ho: Bo * 0 Ha : Bo = 0 Find the value of the test statistic. (Round your answer to two decimal places.) 1. 73 Find the p-value. (Round your answer to three decimal places.) p-value = 0 .201 What is your conclusion at the 0.05 level of significance? X Do not reject Ho. There is insufficient evidence to conclude that there is a significant relationship among the variabl Reject Ho. There is insufficient evidence to conclude that there is a significant relationship among the variables. Reject Ho. There is sufficient evidence to conclude that there is a significant relationship among the variables. Do not reject Ho. There is sufficient evidence to conclude that there is a significant relationship among the variable (c) Use the t test to determine the significance of each independent variable. State the null and alternative hypotheses for Itineraries/Schedule. O HO: B, SO Ha : B , > 0 O Ho : B1 = 0 Ha : B1 > 0 OH : B , $ 0 Ha : B 1 = 0 O Ho : B 1 20 Ha : B1 o O Ho : B2 50 Ha : B2 > o * HO : B2 = 0 Ha : B2 * 0 O Ho: B2 * 0 Ha: B2 = 0 Find the value of the test statistic. (Round your answer to two decimal places.) 1.73 Find the p-value. (Round your answer to three decimal places.) p-value = 0.103 What is your conclusion at the 0.05 level of significance? Do not reject Ho. There is insufficient evidence to conclude that Shore Excursions is a significant factor. Reject Ho. There is insufficient evidence to conclude that Shore Excursions is a significant factor. O Reject Ho. There is sufficient evidence to conclude that Shore Excursions is a significant factor. Do not reject Ho. There is sufficient evidence to conclude that Shore Excursions is a significant factor. State the null and alternative hypotheses for Food/Dining. X Ho : B3 = 0 Ha: B3 = 0 O Ho: B3 = 0 Ha : B3 > 0 O Ho : B3 20 Ha : B3 0 Find the value of the test statistic. (Round your answer to two decimal places.) 1.64 Find the p-value. (Round your answer to three decimal places.) p-value = 0. 121 What is your conclusion at the 0.05 level of significance? Do not reject Ho. There is insufficient evidence to conclude that Food/Dining is a significant factor. Reject Ho. There is insufficient evidence to conclude that Food/Dining is a significant factor. Do not reject Ho. There is sufficient evidence to conclude that Food/Dining is a significant factor. Reject Ho. There is sufficient evidence to conclude that Food/Dining is a significant factor. (d) Remove any independent variable that is not significant from the estimated regression equation. What is the resulting estimated regression equation? (Let x, represent Itineraries/Schedule, X2 represent Shore Excursion, X3 represent Food/Dining, and y representFind the value of the test statistic. (Round your answer to two decimal places.) Faxi the pvalue. (Found your answer to three decimal places.) evoke -0. 121] what is your conclusion at the 0.05 level of significance? Do not reject My. There is insufficient evidence to conclude that Food/Dining is a significant factor, O Reject My. There is insufficient evidence to conclude that Food/Dining is a significant factor. Do not reject No. There is sufficient evidence to conclude that Food/Dining is a significant factor. O Reject My. There is sufficient evidence to conclude that Food/Dining is a significant factor. (d) Remove any independent variable that is not significant from the estimated regression equation. What is the resulting estimated regression equation? (Let X, represent Itineraries/Schedule, x, represent Shore Excursion, x, represent Food/Dining, and y represent Overall score. Round your constant term to one decimal place and coefficients to two decimal places.) Need Help? Read It Talk to a Tutor