Please answer #28

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 3 A 43 60 6 1 65 200 30 355 10 290 7 230 21 11 10 120 55 5 27) Find the estimated heating cost when it is 42 degrees outside the attic insulation is ranked 7 and the age of the furnace is 8 years old. a. 147 b. 156 c. 162 d. 189 28) What is the slope of X(age of Furnace)? a. 9.2