Question #1 (use EXCEL commands - excel file is
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 equation of multiple regression
2. sign of the coefficients
2. Multiple Standard error of equation
3. Adjusted R square
4. P value test
5. Global test
250
35
3
0
360
29
4
1
165
36
7
0
43
60
6
0
92
65
5
0
200
30
5
0
355
10
6
1
290
7
10
1
230
21
9
0
120
55
2
0
73
54
12
0
205
48
5
1
400
20
5
1
320
39
4
1
72
60
8
0
272
20
5
1
94
58
7
0
190
40
8
1
235
27
9
0
139
30
7
0
Question # 2 use EXCEL commands
Consider the following ordered pair:
Price 17
6 12 3
Demand 16 8
9 16
Compute the correlation coefficient (r) and interpret your
results.
