A statistical program is recommended. The Cond Nast Traveler Gold List for 2012 provided ratings for the top 20 small cruise ships. 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

Ship	Overall	Itineraries/ Schedule	Shore Excursions	Food/ 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 Itineraries/Schedule, Shore Excursions, and Food/Dining. (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.)

=

(b)

Use the F test to determine the overall significance of the relationship.

State the null and alternative hypotheses.

H₀: ₁ = ₂ = ₃ = 0 H_a: All the parameters are not equal to zero.H₀: ₀ = 0 H_a: ₀ 0 H₀: ₁ = ₂ = ₃ = 0 H_a: One or more of the parameters is not equal to zero.H₀: One or more of the parameters is not equal to zero. H_a: ₁ = ₂ = ₃ = 0H₀: ₀ 0 H_a: ₀ = 0

Find the value of the test statistic. (Round your answer to two decimal places.)

Find the p-value. (Round your answer to three decimal places.)

p-value =

What is your conclusion at the 0.05 level of significance?

Reject H₀. There is sufficient evidence to conclude that there is a significant relationship among the variables.Do not reject H₀. There is insufficient evidence to conclude that there is a significant relationship among the variables. Do not reject H₀. There is sufficient evidence to conclude that there is a significant relationship among the variables.Reject H₀. There is insufficient evidence to conclude that there is a significant relationship among the variables.

(c)

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

State the null and alternative hypotheses for Itineraries/Schedule.

H₀: ₁ = 0 H_a: ₁ > 0H₀: ₁ 0 H_a: ₁ > 0 H₀: ₁ 0 H_a: ₁ = 0H₀: ₁ = 0 H_a: ₁ 0H₀: ₁ 0 H_a: ₁ < 0

Find the value of the test statistic. (Round your answer to two decimal places.)

Find the p-value. (Round your answer to three decimal places.)

p-value =

What is your conclusion at the 0.05 level of significance?

Reject H₀. There is sufficient evidence to conclude that Itineraries/Schedule is a significant factor.Reject H₀. There is insufficient evidence to conclude that Itineraries/Schedule is a significant factor. Do not reject H₀. There is sufficient evidence to conclude that Itineraries/Schedule is a significant factor.Do not reject H₀. There is insufficient evidence to conclude that Itineraries/Schedule is a significant factor.

State the null and alternative hypotheses for Shore Excursions.

H₀: ₂ 0 H_a: ₂ > 0H₀: ₂ 0 H_a: ₂ < 0 H₀: ₂ = 0 H_a: ₂ > 0H₀: ₂ 0 H_a: ₂ = 0H₀: ₂ = 0 H_a: ₂ 0

Find the value of the test statistic. (Round your answer to two decimal places.)

Find the p-value. (Round your answer to three decimal places.)

p-value =

What is your conclusion at the 0.05 level of significance?

Reject H₀. There is insufficient evidence to conclude that Shore Excursions is a significant factor.Do not reject H₀. There is sufficient evidence to conclude that Shore Excursions is a significant factor. Reject H₀. There is sufficient evidence to conclude that Shore Excursions is a significant factor.Do not reject H₀. There is insufficient evidence to conclude that Shore Excursions is a significant factor.

State the null and alternative hypotheses for Food/Dining.

H₀: ₃ 0 H_a: ₃ > 0H₀: ₃ = 0 H_a: ₃ 0 H₀: ₃ = 0 H_a: ₃ > 0H₀: ₃ 0 H_a: ₃ = 0H₀: ₃ 0 H_a: ₃ < 0

Find the value of the test statistic. (Round your answer to two decimal places.)

Find the p-value. (Round your answer to three decimal places.)

p-value =

What is your conclusion at the 0.05 level of significance?

Do not reject H₀. There is insufficient evidence to conclude that Food/Dining is a significant factor.Reject H₀. There is insufficient evidence to conclude that Food/Dining is a significant factor. Do not reject H₀. There is sufficient evidence to conclude that Food/Dining is a significant factor.Reject H₀. 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.)

=