Question

ch 15 rev q4

The Condé Nast Traveler Gold List for 2012 provided ratings for the top 20 small cruise ships (Condé Nast Traveler website, March 1, 2012). The data shown below are the scores each ship received based upon the results from Condé Nast Traveler's annual Readers' Choice Survey. 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. The highest ranked ship, the Seabourn Odyssey, has an overall score of 94.4, the highest component of which is 97.8 for food/dining.

Click on the datafile logo to reference the data.

$ansm13h_ch15_25.png$

a. Determine the estimated regression equation that can be used to predict the overall score given the scores for Itineraries/Schedule, Shore Excursions, and Food/Dining. Round your answers to three decimal places.

The regression equation is
Overall =   +   Itineraries/Schedule +   Shore Excursions +   Food/Dining

b. Use the F test to determine the overall significance of the relationship. Round your answers to two decimal places.

What is the conclusion at the .05 level of significance?
- Select your answer -The overall model is significant.The overall model is not significant.Item 6

c. Use the t test to determine the significance of each independent variable.

Itineraries/Schedule	- Select your answer -This variable is significant.This variable is not significant.Item 7
Shore Excursions	- Select your answer -This variable is significant.This variable is not significant.Item 8
Food/Dining	- Select your answer -This variable is significant.This variable is not significant.Item 9

What is your conclusion at the .05 level of significance?

Itineraries/Schedule	- Select your answer -Greater than the level of significance.Less than the level of significance.Item 10
Shore Excursions	- Select your answer -Greater than the level of significance.Less than the level of significance.Item 11
Food/Dining	- Select your answer -Greater than the level of significance.Less than the level of significance.Item 12

d. Remove any independent variable that is not significant from the estimated regression equation. What is your recommended estimated regression equation? Round your answers to three decimal places.

Overall =   +   - Select your answer -Itineraries/ScheduleShore ExcursionsFood/DiningItem 15  +   

Answer 1

Excel > Data > Data Analysis > Regression

SUMMARY OUTPUT
Regression Statistics
Multiple R	0.865921774
R Square	0.749820518
Adjusted R Square	0.702911865
Standard Error	1.387747298
Observations	20
ANOVA
	df	SS	MS	F	Significance F
Regression	3	92.35201899	30.78400633	15.98469518	4.51741E-05
Residual	16	30.81348101	1.925842563
Total	19	123.1655
	Coefficients	Standard Error	t Stat	P-value	Lower 95%	Upper 95%	Lower 95.0%	Upper 95.0%
Intercept	35.61837752	13.23082753	2.692074812	0.016030017	7.570276139	63.66647891	7.570276139	63.66647891
Itineraries/ Schedule	0.110453865	0.129662213	0.851858551	0.406862775	-0.164417747	0.385325477	-0.164417747	0.385325477
Shore Excursions	0.244537423	0.043357317	5.640049758	3.68903E-05	0.152624018	0.336450828	0.152624018	0.336450828
Food/ Dining	0.247356763	0.062116587	3.982137038	0.001071527	0.11567548	0.379038045	0.11567548	0.379038045

a)

The regression equation is

Overall = 35.618 +0.111 * Itineraries/Schedule +0.245 * Shore Excursions +0.247 * Food/Dining

b)

Hypothesis :

H0 : β1 = β2 = β3 = 0

Ha : at least one β is not equal to 0

Test :

F = 15.98

P value = 0 < 0.05. Reject H0

There enough evidence to conclude that overall model is significant

c)

Independent variable	t Stat	P-value		alpha	Significant
Itineraries/ Schedule	0.851859	0.406863	>	0.05	No
Shore Excursions	5.64005	3.69E-05	<	0.05	Yes
Food/ Dining	3.982137	0.001072	<	0.05	Yes

d)

Remove Itineraries/ Schedule variable and again do the same regression model like above

SUMMARY OUTPUT
Regression Statistics
Multiple R	0.859345037
R Square	0.738473893
Adjusted R Square	0.707706116
Standard Error	1.376504389
Observations	20
ANOVA
	df	SS	MS	F	Significance F
Regression	2	90.95450632	45.47725316	24.00153535	1.11912E-05
Residual	17	32.21099368	1.894764334
Total	19	123.1655
	Coefficients	Standard Error	t Stat	P-value	Lower 95%	Upper 95%	Lower 95.0%	Upper 95.0%
Intercept	45.17795848	6.951847689	6.498697972	5.45765E-06	30.51084193	59.84507502	30.51084193	59.84507502
Shore Excursions	0.252892474	0.041891237	6.036882459	1.33357E-05	0.16450969	0.341275259	0.16450969	0.341275259
Food/ Dining	0.248188929	0.061605727	4.028666536	0.00087138	0.118212208	0.378165651	0.118212208	0.378165651

Overall = 45.178 + 0.253 * Shore Excursions + 0.248 * Food/ Dining

Answer 2

Here is my answer

a.  Determine the estimated regression equation that can be used to predict the overall score given the scores for Itineraries/Schedule, Shore Excursions, and Food/Dining. Round your answers to three decimal places.

The regression equation is
Overall =   +   Itineraries/Schedule +   Shore Excursions +   Food/Dining

b.  Use the F test to determine the overall significance of the relationship. Round your answers to two decimal places.
 

What is the conclusion at the .05 level of significance?
- Select your answer -The overall model is significant.The overall model is not significant.Item 6 

c.  Use the t test to determine the significance of each independent variable.

Itineraries/Schedule	- Select your answer -This variable is significant.This variable is not significant.Item 7
Shore Excursions	- Select your answer -This variable is significant.This variable is not significant.Item 8
Food/Dining	- Select your answer -This variable is significant.This variable is not significant.Item 9

What is your conclusion at the .05 level of significance?

Itineraries/Schedule	- Select your answer -Greater than the level of significance.Less than the level of significance.Item 10
Shore Excursions	- Select your answer -Greater than the level of significance.Less than the level of significance.Item 11
Food/Dining	- Select your answer -Greater than the level of significance.Less than the level of significance.Item 12

d.  Remove any independent variable that is not significant from the estimated regression equation. What is your recommended estimated regression equation? Round your answers to three decimal places.

Overall =   +   - Select your answer -Itineraries/ScheduleShore ExcursionsFood/DiningItem 15  +   - Select your answer -Itineraries/ScheduleShore ExcursionsFood/DiningItem 17