Question #1 (use excel file attached) question 1 data attached in the uploaded picture,

Data is about Home heating costs, temperature, insulation, and presence of a garage for a sample of 20 homes.

Use data and excel program to answer following questions. You must explain your numerical answers to get full credit. 50 % of the credit is for explanation of your values.

Perform multiple regression analysis on excel, then

Answer/ Explain following in words:

1. Predicted equationof multiple regression

2. Multiple Standard error of equation

3. coefficient of multiple determination

4. Global test

5. Evaluate individual regression coefficients

Question # 2

Consider the following ordered pair:

X 176123

Y 16 89 16

r = 0.13

Perform a hypothesis test to determine if the population

Correlation coefficient is less than zero using alpha = 0.05.

What are your conclusions?

Copy of Final exam AutoSave OFF Share Comments Draw Page Layout Formulas Data Review View Tell me Home Insert Insert ab v Calibri (Body) 11 AA General Delete v Cell Sort & Find & Ideas Sensitivity A = = FE F V % 9 Conditional Format Formatting as Table Styles Format v Filter Select Paste BI UV F24 X V fx M N O Q R S U V W E F G H A D Heating Cost Temperature Insulation Garage $250 360 29 165 36 43 60 92 65 200 30 355 10 290 7 230 21 120 55 73 54 O O H O H O H H H O O O H H O O O O 205 48 400 20 320 39 72 60 272 20 94 58 190 40 235 139 30 Sheet1 Sheet2 Sheet3 + 100%