Quantitative Analysis – independent and dependent variables.
(Q: 12)
Suppose you want to develop a model to predict assessed
value based on heating area. A sample of 15 single-family houses is selected in
a city. The assessed value (in thousands of dollars) and the heating area of
the houses (in thousands of square feet) are recorded with the following
results:
House Assessed Value Heating Area of Dwelling
(Thousands of Square Feet)
1 84.4 2.00
2 77.4 1.71
3 75.7 1.45
4 85.9 1.76
5 79.1 1.93
6 70.4 1.20
7 75.8 1.55
8 85.9 1.93
9 78.5 1.59
10 79.2 1.50
11 86.7 1.90
12 79.3 1.39
13 74.5 1.54
14 83.8 1.89
15 76.8 1.59
(Hint: First determine which are the independent and
dependent variables.)
a. Plot a
scatter diagram [Using Excel] and, assuming a linear relationship, use the
least-squares method to find the regression coefficients b0 & b1.
b. Interpret
the meaning of the Y intercept b0 and the slope b1 in this problem.
c. Use the
regression equation developed in (a) to predict the assessed value for a house
whose heating area is 1,750 square feet.
d. Determine
the standard error of the estimate.
e. Determine
the coefficient of determination r² and interpret its meaning in this problem.
f. Determine
the coefficient of correlation r.
g. Perform a
residual analysis on your results and determine the adequacy of the fit of the
model. (Continued
 )
h. At the
0.05 level of significance, is there evidence of a linear relationship between
assessed value and heating area?
i. Set up
a 95% confidence interval estimate of the average assessed value for houses
with a heating area of 1,750 square feet.
j. Set up a
95% prediction interval of the assessed value of an individual house with a
heating area of 1,750 square feet.
k. Set up a
95% confidence interval estimate of the population slope.
l. Suppose
that the assessed value for the fourth house was $79,700. Repeat (a) – (k) and
compare the results with your original results.





