statistics help

learn'humber'ca I ,mmwi; i,' 3 i _ ,3 ,',., QUIZ7Blackboard Learn illi,,' I' Irina Nemiceva @'HUMBER Blackboard Is your overall satisfaction with a hotel room correlated with the cost of the room? Suppose that satisfaction scores (in percent) and the median room prices (in Canadian dollars) were recorded for a sample of 12 hotels with the following results: Hotel Median Rate Score Accent Inn 95 80 Econo Lodge 80 75 Twelve Months 110 90 Paradise 100 88 Travelodge 60 60 Days Inn 90 82 Coast Inn 70 70 Holiday Inn 120 93 Motel 6 150 95 Best Western 100 95 Crossways 140 90 Comfort Inn 85 85 The following is the summary statistics for the table above generated from an Excel regression analysis: SUMMARY OUTPUT Regression Statistics Multiple R 0.824019789 R Square 0.679008612 Adjusted R Square 0.646909473 Standard Error 6.417205012 Observations 12 E learn.humber.ca Skillbox - OHnaNH-yHNBepcuteT, ... (3) A ce69 3Halo! AeHNc Aopoxo... QUIZ 7 - Blackboard Learn https://learn-ca-central-1-prod-f... Bxonawne - irysia345@gmail.co... Course Hero H HUMBER Irina Nemtceva Blackboard MyCourses ... > QUIZ 7 > QUIZ 7 ANOVA df SS MS F Significance F Regression 871. 111465 871. 111465 21. 15348377 0.000981 183 Residual 10 411.8052017 41. 18052017 Total 11 1,282.9166667 Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Intercept 50.27123142 7.476026443 .72432498 5.20503E-05 33.61360645 6.9288564 Median 0.072428766 0.000981183 0. 171739672 0.494502367 Rate 0.333121019 4.599291659 Based on the Excel output, does there appear to be a significant linear relationship between the median rate and the satisfaction score for all similar hotels? Use the F-test for the population slope at 5% significance level. (a) State the null and alternative hypotheses, and identify which one is the claim. Ho: Select an answer ? H1: Select an answer ? Which one is the claim: OH1 OHo learn'humber'ca l mm, i,' 3 ' _ ,3 , QUlZ7Blackboard Learn ins q}. H U M B F R l' Irina Nemtceva Blackboard Which one is the claim: \"'2 H1 77' Ho For part (b), round your answer to 5 decimal places. (b) What is the test P-value that should be used in your hypothesis test? :} (C) Is the null hypothesis rejected? (\"1 No 7' Yes (d) Is the claim supported? dYes, there is sufficient evidence to support the claim that there is a significant linear relationship between the median rate and the satisfaction score for all similar hotels. i\" No, there is not sufficient evidence to support the claim that there is a significant linear relationship between the median rate and the satisfaction score for all similar hotels. Add Work