The following data shown are the score each ship received based upon results from Travelling Magazine.                    Ship  Overall  Itineraries  Shore  Food/Dining Seabourn Odyssey 94.4 94.6 90.9 97.8 Seabourn Pride  93 96.7 84.2 96.7 National Geographic Endeavor 92.9 100 100 88.5 Seabourn Sojourn 91.3 88.6 94.8 97.1 Paul Gaugian 90.5 95.1 87.9 91.2 Seabourn Legend 90.3 92.5 82.1 98.8 Seabourn Spirit 90.2 96 86.3 92 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 88.6 National Geographic Explorer 89.1 93.1 93.1 89.7 Silver Cloud 88.7 92.6 78.3 91.3 Celebritiy Xpedition 87.2 93.1 91.7 73.6 Silver Shadow 87.2 91 75 89.7 SeaDream II 86.6 94.4 78.1 91.6 Wind Star 86.2 95.5 77.4 90 Wind Surf 86.1 94.9 76.5 91.5 Wind Spirit 86.1 92.1 72.3 89.3 Seabourn Star  85.2 93.5 77.4 91.9           a) determine the estimate regression equation that can be used to predict the overall score given the score for Itineraraies, Shore, Food/dining.                                        b) Use F-test to determine the overall significance of the relationship. What is your conclusion at the 5% level of significance?

Glencoe Algebra 1, Student Edition, 9780079039897, 0079039898, 2018
18th Edition
ISBN:9780079039897
Author:Carter
Publisher:Carter
Chapter10: Statistics
Section10.6: Summarizing Categorical Data
Problem 4BGP
icon
Related questions
icon
Concept explainers
Topic Video
Question
The following data shown are the score each ship received based upon results from Travelling Magazine.         
         
Ship  Overall  Itineraries  Shore  Food/Dining
Seabourn Odyssey 94.4 94.6 90.9 97.8
Seabourn Pride  93 96.7 84.2 96.7
National Geographic Endeavor 92.9 100 100 88.5
Seabourn Sojourn 91.3 88.6 94.8 97.1
Paul Gaugian 90.5 95.1 87.9 91.2
Seabourn Legend 90.3 92.5 82.1 98.8
Seabourn Spirit 90.2 96 86.3 92
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 88.6
National Geographic Explorer 89.1 93.1 93.1 89.7
Silver Cloud 88.7 92.6 78.3 91.3
Celebritiy Xpedition 87.2 93.1 91.7 73.6
Silver Shadow 87.2 91 75 89.7
SeaDream II 86.6 94.4 78.1 91.6
Wind Star 86.2 95.5 77.4 90
Wind Surf 86.1 94.9 76.5 91.5
Wind Spirit 86.1 92.1 72.3 89.3
Seabourn Star  85.2 93.5 77.4 91.9
         
a) determine the estimate regression equation that can be used to predict the overall score given the score for Itineraraies, Shore, Food/dining.         
         
         
         
b) Use F-test to determine the overall significance of the relationship. What is your conclusion at the 5% level of significance?         
         
         
         
C) Use t-test to determine the significance of each independent variable. What is your conclusion at the 5% level of significance?         
         
         
         
d) Remove any independent variable that is not significant from the estimated regression equation. What is your recommended estimated regression equation?         
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps

Blurred answer
Knowledge Booster
Centre, Spread, and Shape of a Distribution
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, statistics and related others by exploring similar questions and additional content below.
Recommended textbooks for you
Glencoe Algebra 1, Student Edition, 9780079039897…
Glencoe Algebra 1, Student Edition, 9780079039897…
Algebra
ISBN:
9780079039897
Author:
Carter
Publisher:
McGraw Hill