Question #1 (use excel file attached)

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:

X176123

Y168916

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?