X AutoSave Off Ch13_58v4_18e (2) - Excel Search (Alt+Q) 1485493 X File Home Insert Draw Page Layout Formulas Data Review View Help Comments Share Insert Calibri 12 ~ A" A ab General Ap O Delete V V Paste $ ~ % " Conditional Format as Cell Sort & Find & Analyze Formatting Table Styles ~ Format Filter * Select v Data Font Alignment Styles Cells Editing Analysis Undo Clipboard Number A1 : XV fx Wattage A B C D E F G H I J K L M N O P Q R S T U Wattage Area W N - 750 73 750 62 1000 133 1250 51 1750 203 1250 250 1500 154 1000 243 10 1250 117 11 1250 112 12 750 130 13 2000 291 14 1500 298 15 1500 225 16 2000 225 17 1250 141 18 750 275 19 750 41 20 2000 76 21 1000 59 Ch13_58v4_18e + + 100% Ready 12:03 PM Type here to search O O W X 45 F O ENG 11/28/2021Question 5 - Unit 6 Assignment - X Course Hero X + X > C A ezto.mheducation.com/ext/map/index.html?_con=con&external_browser=0&launchUrl=https%253A%252F%252FIms.mheducation.com%252Fmghmiddleware%252Fmhepr... L . .. Unit 6 Assignment Saved Help Save & Exit Submit Check my work 5 A consumer buying cooperative tested the effective heating area of 20 different electric space heaters with different wattages. Here are the results. 2.5 Heater Wattage Area points 750 73 WNG 750 62 Skipped 1,000 133 4 1, 250 51 5 1, 750 203 6 1, 250 250 eBook 7 1, 500 154 8 1, 000 243 Print 1, 250 117 10 1, 250 112 References 11 750 130 12 2,000 291 13 1, 500 298 14 1 , 500 225 15 2,000 225 16 1, 250 141 17 750 275 18 750 41 19 2,000 76 20 1, 000 59 Click here for the Excel Data File a. Compute the correlation between the wattage and heating area. Is there a direct or an indirect relationship? (Round your answer to Mc Graw Hill Type here to search O W X A DE ENG 12:03 PM 45.F 11/28/2021Question 5 - Unit 6 Assignment - X Course Hero X + X > C A ezto.mheducation.com/ext/map/index.html?_con=con&external_browser=0&launchUrl=https%253A%252F%252FIms.mheducation.com%252Fmghmiddleware%252Fmhepr... L . .. Unit 6 Assignment i Saved Help Save & Exit Submit Check my work 5 a. Compute the correlation between the wattage and heating area. Is there a direct or an indirect relationship? (Round your answer to 4 decimal places.) 2.5 The correlation of Wattage and Area is The link (relationship) is points Skipped eBook Print References b. Conduct a test of hypothesis to determine if it is reasonable that the coefficient is greater than zero. Use the 0.100 significance level. (Round intermediate calculations and final answer to 3 decimal places.) Ho: p = 0; H1: p > 0 Reject He if t> 1.330 t = Mc Graw Type here to search O O W X 45OF ~ O ENG 12:03 PM 11/28/2021Question 5 - Unit 6 Assignment - X Course Hero X + X C A ezto.mheducation.com/ext/map/index.html?_con=con&external_browser=0&launchUrl=https%253A%252F%252FIms.mheducation.com%252Fmghmiddleware%252Fmhepr... L . .. Unit 6 Assignment Saved Help Save & Exit Submit Check my work 5 Ho. It is quite reasonable to say the population correlation is 2.5 points Skipped eBook Print References c. Develop the regression equation for effective heating based on wattage. (Negative value should be indicated by a minus sign. Round your answers to 3 decimal places.) The regression equation is: Mc Graw Hill Type here to search O O W X 45OF ~ O ENG 12:03 PM 11/28/2021Question 5 - Unit 6 Assignment - X Course Hero X + X > C A ezto.mheducation.com/ext/map/index.html?_con=con&external_browser=0&launchUrl=https%253A%252F%252FIms.mheducation.com%252Fmghmiddleware%252Fmhepr... L . .. Unit 6 Assignment i Saved Help Save & Exit Submit Check my work 5 d. What heating area corresponds with a 1,500-watt heater? (Round your answers to 4 decimal places.) 2.5 points Heating area Skipped eBook Print References e. What is the 95% confidence interval of heating the area if the wattage is 1,500? (Round your answers to 4 decimal places.) Mc Graw Type here to search O O W X 45OF ~ O ENG 12:03 PM 11/28/2021