Question: Using the above dataset please run a regression analysis in Excel and use the output to answer the below questions. Home Heating Cost Mean Outside

Using the above dataset please run a regression analysis in Excel and use the output to answer the below questions. Home Heating Cost Mean Outside Temperature Attic Insulation Age of Furnace 250 35 3 6 360 29 10 165 36 43 60 6 92 65 200 30 355 10 290 7 230 21 11 10 120 55 5 31) Using a 95% confidence and the p-values for each of th X variables which variable is shown not to have a linear relationship to heating cost? Mean Outside Temperature . Attic Insulation Age of Furnance (.199 is greater than .05) No variable should be thrown out
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
