ADMS 3330 Assignment 1
Due: Monday, May 28 (Section D)
Tuesday, May 29 (Sections B and E)
Wednesday, May 30 (Section C)
Notes: 1. Questions must be done manually. You are not allowed to present Excel output as a solution,
however Excel use is recommended to check if your calculations are correct.
2. The assignments must be typed and to be handed in your registered section.
3. All assignments may be done individually or in groups of up to four. Refer to the course outline for
Question 1 (50 points, Keller Ch16):
The following information was obtained from the manager of a power department for predicting the
consumption of power (in units) from the size of households:
Size (x) Used (y)
You are helping the manager to estimate power consumption as a liner function of household size using
least squares method.
a) Determine the least squares regression line. (Treat the household size as an interval variable).
b) Assuming that the diagnostics checks do not indicate a violation of the required conditions, interpret
the value of the slope of the regression line.
c) Determine the coefficient of determination and discuss what its value tells you about the two