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

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!