Assignment
Answer all questions
Question 1
The data set HPRICE.XLS contains data on house prices (in dollars), house characteristics and location desirability.
Let Y= house price be the dependent variable and consider the following potential explanatory variables:
(a) Using the data the calculate, interpret and discuss the mean, standard deviation, minimum, maximum, skewness, kurtosis and of Y, , , , and .
(20 marks)
(b) Estimate correlation coefficients between variables in (a) and comment on your results.
(15 marks)
(c) Regress Y and all the explanatory variables and discuss your results.
(25 marks)
(d) Regress Y on various subsets of and discuss your results.
Comparing your results for (c) and (d), examine the effect of omitting explanatory variables.
(40 marks)
Question 2
The US Golf team has collected some data to try to estimate the distance travelled by a golf ball when it is hit by a player.
Other variables that they have collected which they believe offer some insight on the distance travelled by a golf ball when it is hit (Distance is measured in feet) (DIST) include:
Hang time (time in the air, in seconds) (HANG)
Right hand strength (measured in pounds of force) (RHSTH)
Left hand strength (in pounds of force) (LHSTH)
Right hand flexibility (in degrees) (RHFLX)
Left hand flexibility (in degrees) (LHFLX)
Overall strength (in pounds) (OLSTH)
The data collected on a sample of 13 shots (by right-handed players) is shown below.
DIST
HANG
RHSTH
LHSTH
RHFLX
LHFLX
OLSTH
1
162.50
4.75
170.00
170.00
106.00
106.00
240.57
2
144.00
4.07
140.00
130.00
92.00
93.00
195.49
3
147.50
4.04
180.00
170.00
93.00
78.00
152.99
4
163.50
4.18
160.00
160.00
103.00
93.00
197.09
5
192.00
4.35
170.00
150.00
104.00
93.00
266.56
6
171.75
4.16
150.00
150.00
101.00
87.00
260.56
7
162.00
4.43
170.00
180.00
108.00
106.00
219.25
8