Purchase Solution

Regression Analysis

Not what you're looking for?

Ask Custom Question

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
Purchase this Solution

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 .

Solution Preview

See attached file

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

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

n= 7
Σx= 160
Σy= 875
SS(x)= 1042.857
SS(y)= 26250
SS(xy)= 5000

See the answer on the following pages
A) Compute the regression line to explain "water consumption" in terms of "temperature".

Regression equation: Y=a+bX
b=SS(xy)/ SS(x)= 4.7945 =5000/1042.857

ΣY=na+bΣX
or 875=7*a + 4.7945*160
or ...

Purchase this Solution


Free BrainMass Quizzes
Measures of Central Tendency

Tests knowledge of the three main measures of central tendency, including some simple calculation questions.

Measures of Central Tendency

This quiz evaluates the students understanding of the measures of central tendency seen in statistics. This quiz is specifically designed to incorporate the measures of central tendency as they relate to psychological research.

Know Your Statistical Concepts

Each question is a choice-summary multiple choice question that presents you with a statistical concept and then 4 numbered statements. You must decide which (if any) of the numbered statements is/are true as they relate to the statistical concept.

Terms and Definitions for Statistics

This quiz covers basic terms and definitions of statistics.