score of $94\mathrm{.}3,$ the highest component of which is $97\mathrm{.}7$ for in$-$house dining. If required, round your answers to three decimal places.

Click on the datafile logo to reference the data.

DATA

$\backslash$table$[[$Hotel$,$Overall,Comfort,Amenities,In$-$House Dining$],[$Muri Beach Odyssey,$94\mathrm{.}3,94\mathrm{.}5,90\mathrm{.}8,97\mathrm{.}7],[$Pattaya Resort,$92\mathrm{.}9,96\mathrm{.}6,84\mathrm{.}1,96\mathrm{.}6],[$Sojourner$\text{'}$s Respite,$92\mathrm{.}8,99\mathrm{.}9,100\mathrm{.}0,88\mathrm{.}4],[$Spa Carribe,$91\mathrm{.}2,88\mathrm{.}5,94\mathrm{.}7,97\mathrm{.}0],[$Penang Resort and Spa,$90\mathrm{.}4,95\mathrm{.}0,87\mathrm{.}8,91\mathrm{.}1],[$Mokihana H$$kele$,90\mathrm{.}2,92\mathrm{.}4,82\mathrm{.}0,98\mathrm{.}7],[$Theo$\text{'}$s of Cape Town,$90\mathrm{.}1,95\mathrm{.}9,86\mathrm{.}2,91\mathrm{.}9],[$Cap d'Agde Resort,$89\mathrm{.}8,92\mathrm{.}5,92\mathrm{.}5,88\mathrm{.}8],[$Spirit of Mykonos,$89\mathrm{.}3,94\mathrm{.}6,85\mathrm{.}8,90\mathrm{.}7],[$Turismo del Mar,$89\mathrm{.}1,90\mathrm{.}5,83\mathrm{.}2,90\mathrm{.}4],[$Hotel Iguana,$89\mathrm{.}1,90\mathrm{.}8,81\mathrm{.}9,88\mathrm{.}5],[$Sidi Abdel Rahman Palace,$89\mathrm{.}0,93\mathrm{.}0,93\mathrm{.}0,89\mathrm{.}6],[$Sainte$-$Maxime Quarters,$88\mathrm{.}6,92\mathrm{.}5,78\mathrm{.}2,91\mathrm{.}2],[$Rotorua Inn,$87\mathrm{.}1,93\mathrm{.}0,91\mathrm{.}6,73\mathrm{.}5],[$Club Lapu$-$Lapu,$87\mathrm{.}1,90\mathrm{.}9,74\mathrm{.}9,89\mathrm{.}6],[$Terracina Retreat,$86\mathrm{.}5,94\mathrm{.}3,78\mathrm{.}0,91\mathrm{.}5],[$Hacienda Punta Barco,$86\mathrm{.}1,95\mathrm{.}4,77\mathrm{.}3,90\mathrm{.}8],[$Rendezvous Kolocep,$86\mathrm{.}0,94\mathrm{.}8,76\mathrm{.}4,91\mathrm{.}4],[$Cabo de Gata Vista,$86\mathrm{.}0,92\mathrm{.}0,72\mathrm{.}2,89\mathrm{.}2],[$Sanya Deluxe,$85\mathrm{.}1,93\mathrm{.}4,77\mathrm{.}3,91\mathrm{.}8]]$

$\backslash$table$[[$Terracina Retreat,$86\mathrm{.}5,94\mathrm{.}3,78,0,91\mathrm{.}5],[$Haclenda Punta Barco,$86\mathrm{.}1,95\mathrm{.}4,77\mathrm{.}3,90\mathrm{.}8],[$Rendezvous Kolocep,$86\mathrm{.}0,94\mathrm{.}8,76\mathrm{.}4,91,4],[$Cabo de Gata Vista,$86\mathrm{.}0,92\mathrm{.}0,72\mathrm{.}2,89\mathrm{.}2],[$Sanya Deluxe,$85\mathrm{.}1,93,4,77\mathrm{.}3,91\mathrm{.}8]]$

$($a$)$ Determine the estimated multiple linear, regression equation that can be used to predict the overall score given the scores for comfort, amenitles, and in$-$houge dining. Let $x_1$ represent Comfort.

Let $x_2$ represent Amenities.

Let $x_3$ represent In$-$House Dining,

hat$(y)=,x_1+,x_2+,x_3$

$($b$)$ Use the $t$ test to determine the significance of each independent variable, What is the conclusion for each test at the $0,01$ level of significance? If your answer is zero, onter $"0,$

The $p-$value assoclated with the estimated regresslon parameter $b_1$ is $0\mathrm{.}01.$ Because this $p-$value $1$ than the level of significance, we the hypothesis that ${}_1=0,$ We conclude that there a relationship between the score on comfort and the overall score at the $0\mathrm{.}01$ level of significance when controlling for amenities and in$-$house dining $.$

The $p-$value associated with the estimated regression parameter $b_2$ is $0\mathrm{.}01.$ Because this $p-$value is Decause this $p-$value is the level of significance, we the hypothesis that ${}_2=0.$ We conclude that there a relationship between the score on amenities and the overall score at the $0\mathrm{.}01$ level of signincance when controling for comfort and in$-$house dining

The $p-$value associated with the estimated regression parameter $b_3$ is $0\mathrm{.}01.$ Because this $p-$value is than the level of significance, we the hypothesis that ${}_3=0,$ We conclude that there is a relationship between the score on in$-$house dining and the overall score at the $0\mathrm{.}01$ leyel of significance when controlling for comfort and amenities

$($c$)$ Remove all independent varlables that are not significant at the $0\mathrm{.}01$ level of significance from the estimated regression equation. What is your recommended estimated regression equation? Enter o coefficient of zero for any independent variable you chose to remove.

hat$(y)=,+,x_1+,x_2+,x_3$

Hine$($s$)$

Chesk My Work $(2$ romaining$)$

$\backslash$table$[[$Hotel$,$Overall,Comfort,Amenities,In$-$House Dining$],[$Muri Beach Odyssey,$94\mathrm{.}3,94\mathrm{.}5,90\mathrm{.}8,97\mathrm{.}7],[$Pattaya Resort,$92\mathrm{.}9,96\mathrm{.}6,84\mathrm{.}1,96\mathrm{.}6],[$Sojourner$\text{'}$s Respite,$92\mathrm{.}8,99\mathrm{.}9,100\mathrm{.}0,88\mathrm{.}4],[$Spa Carribe,$91\mathrm{.}2,88\mathrm{.}5,94\mathrm{.}7,97\mathrm{.}0],[$Penang Resort and Spa,$90\mathrm{.}4,95\mathrm{.}0,87\mathrm{.}8,91\mathrm{.}1],[$Mokihana H$$kele$,90\mathrm{.}2,92\mathrm{.}4,82\mathrm{.}0,98\mathrm{.}7],[$Theo$\text{'}$s of Cape Town,$90\mathrm{.}1,95\mathrm{.}9,86\mathrm{.}2,91\mathrm{.}9],[$Cap d'Agde Resort,$89\mathrm{.}8,92\mathrm{.}5,92\mathrm{.}5,88\mathrm{.}8],[$Spirit of Mykonos,$89\mathrm{.}3,94\mathrm{.}6,85\mathrm{.}8,90\mathrm{.}7],[$Turismo del Mar,$89\mathrm{.}1,90\mathrm{.}5,83\mathrm{.}2,90\mathrm{.}4],[$Hotel Iguana,$89\mathrm{.}1,90\mathrm{.}8,81\mathrm{.}9,88\mathrm{.}5],[$Sidi Abdel Rahman Palace,$89\mathrm{.}0,93\mathrm{.}0,93\mathrm{.}0,89\mathrm{.}6],[$Sainte$-$Maxime Quarters,$88\mathrm{.}6,92\mathrm{.}5,78\mathrm{.}2,91\mathrm{.}2],[$Rotorua Inn,$87\mathrm{.}1,93\mathrm{.}0,91\mathrm{.}6,73\mathrm{.}5],[$Club Lapu$-$Lapu,$87\mathrm{.}1,90\mathrm{.}9,74\mathrm{.}9,89\mathrm{.}6],[$Terracina Retreat,$86\mathrm{.}5,94\mathrm{.}3,78\mathrm{.}0,91\mathrm{.}5],[$Hacienda Punta Barco,$86\mathrm{.}1,95\mathrm{.}4,77\mathrm{.}3,90\mathrm{.}8],[$Rendezvous Kolocep,$86\mathrm{.}0,94\mathrm{.}8,76\mathrm{.}4,91\mathrm{.}4],[$Cabo de Gata Vista,$86\mathrm{.}0,92\mathrm{.}0,72\mathrm{.}2,89\mathrm{.}2],[$Sanya Deluxe,$85\mathrm{.}1,93\mathrm{.}4,77\mathrm{.}3,91\mathrm{.}8]]$