Share
Explore BrainMass

Regression Analysis

An analyst would like to predict water consumption in a city based on daily temperature. She has gathered the following data for a random sample of n= 7 days.

Temperature ( C) 40 5 25 15 10 30 35
Water Consumption(million gallons) 225 25 150 100 75 125 175

Using the following sums and sums of squares and cross-products

Summation of x= 160 Summation of y= 875 SS(x)= 1042.857 SS(y)= 26,250 SS(xy)= 5,000

A) Compute the regression line to explain "water consumption" in terms of "temperature".
B) Test, at the alpha= 0.01 level of significance, whether temperature is a significant predictor of water consumption.
C) Compute the coefficient of determination of the regression model.
D) Find a 99% confidence interval for water consumption on a particular day when the temperature is 28ºC.

Attachments

Solution Summary

Computes the regression line to explain "water consumption" in terms of "temperature", tests whether temperature is a significant predictor of water consumption, computes the coefficient of determination of the regression model and finds a 99% confidence interval for water consumption on a particular .

$2.19