Paper instructions:
Microsoft Excel Project Directions Refer to the “Cruise Ships” Microsoft Excel file on Blackboard. To submit: Save your Excel file with your scatter diagram and regression outputs. You may also type up the answers to the other parts of the problems in the same Excel file, or type them up in a separate document file. Submit your file(s) using the Microsoft Excel Project Dropbox on Blackboard. You have started a new job working in the marketing department of a cruise ship company. Your company is very interested in the results of the Conde Nast Traveler’s annual Readers’ Choice Survey. The “Cruise Ships” Microsoft Excel file contains scores for several cruise ships. Each score represents the percentage of respondents who rated a ship as excellent or very good on several criteria, including Itineraries/Schedule, Shore Excursions, and Food/Dining. An Overall Score was also reported and used to rank the ships. Part 1. Your boss strongly believes that a cruise ship’s Itineraries/Schedule score is the main driver of customer satisfaction and has the most influence on the Overall Score a cruise ship gets. a. Create a scatter diagram (using Microsoft Excel) with Itineraries/Schedule as the independent (x) variable and Overall Score as the dependent (y) variable. Make sure to include a trendline. b. Develop an estimated regression equation using the regression tool in Microsoft Excel. C. Based on your equation, what is the estimate of a cruise ship’s Overall Score when their itineraries/Schedule score is 90? d. State the coefficient of determination (taken from your Excel regression output). What does this number mean? Part 2. After looking at the regression results you are not very confident in your boss’s belief. You decide to re- do the regression analysis using Itineraries/Schedule, Score Excursions, and Food/Dining scores as independent variables. a. Develop an estimated regression equation using the regression tool in Microsoft Excel with Itineraries/Schedule, Score Excursions, and Food/Dining as the independent variables and Overall Score as the dependent variable. b. Based on your equation, what is the estimate of a cruise ship’s Overall Score when their Itineraries/Schedule score is 90, Score Excursions score is 92, and Food/Dining score is 94? C. State the coefficient of determination (taken from your Excel regression output). What does this number mean? d. Which formula do you think is more accurate (the simple regression from Part 1 or the multiple regression from Part 2)? Briefly explain why. Ship Itineraries/ Overall Seabourn Odyssey 94.6 93.4 Seabourn Pride 96.7 93 National Geographic Endeavor 100 92.9 Seabourn Sojourn 88.6 91.3 Paul Gauguin 95.1 90.5 Seabourn Legend 97 90.3 Seabourn Spirit 97 90.2 Silver Explorer 92.6 89.9 Silver Spirit 94.7 89.4 Seven Seas Navigator 90.6 89.2 Silver Whisperer 90.9 89.2 National Geographic Explorer 93.1 89.1 Silver Cloud 92.6 88.7 Celebrity Xpedition 93.1 87.2 Silver Shadow 87.2 Silver Wind 94.4 86.6 SeaDream II 95.5 86.2 Wind Star 94.9 86.1 Wind Surf 92.1 86.1 Wind Spirit 90.5 85.2 91 Part 1 Part 2 Ship Itineraries/ Food/Dining Overall 94.6 96.7 100 88.6 95.1 97 96.8 96.7 88.5 97.1 91.2 98.8 97 92 Seabourn Odyssey Seabourn Pride National Geographic Endeavor Seabourn Sojourn Paul Gauguin Seabourn Legend Seabourn Spirit Silver Explorer Silver Spirit Seven Seas Navigator Silver Whisperer National Geographic Explorer Silver Cloud Celebrity Xpedition Silver Shadow Silver Wind SeaDream II Wind Star Wind Surf Wind Spirit 92.6 94.7 90.6 90.9 93.1 92.6 93.1 91 94.4 95.5 94.9 92.1 90.5 Shore Excursions 93.4 93 92.9 91.3 90.5 90.3 90.2 89.9 89.4 89.2 89.2 89.1 88.7 87.2 87.2 86.6 86.2 86.1 86.1 85.2 88.9 90.8 90.5 88.6 89.7 91.3 73.6 89.7 91.6 90.9 91.5 89.3 94.4 93 92.9 91.3 90.5 91.5 90.2 89.9 89.4 89.2 89.2 89.1 88.7 87.2 87.2 87.2 86.2 86.1 86.1 85.2 91.9
Tired of low grades? We can help you write a successful essay that will boost your grades.
Order With Us Today!
