Explore BrainMass
Share

Correlation Coefficient & Linear Regression Analysis

This content was STOLEN from BrainMass.com - View the original, and get the already-completed solution here!

1. Find the equation of the regression line for the given data. Predict the value of Y when X=-2? Predict the value of Y when X = 4?

x -5 -3 4 1 -1 -2 0 2 3 -4
y -10 -8 9 1 -2 -6 -1 3 6 -8

2. The data below are the final exam scores of 10 randomly selected statistics students and the number of hours they studied for the exam. Find the equation of the regression line for the given data. Predict the final exam score when a student studied for 4 hours. Predict the final exam score when a student studied for 6 hours.

Hours, x 3 5 2 8 2 4 4 5 6 3
Scores, y 65 80 60 88 66 78 85 90 90 71

3. A manager wishes to determine the relationship between the number of miles (in hundreds of miles) the manager's sales representatives travel per month and the amount of sales (in thousands of dollars) per month. Find the equation of the regression line for the given data. Predict the value of sales when the sales representative travel 8 miles. Predict the value of sales when the sales representative traveled 11 miles.

miles traveled, x 2 3 10 7 8 15 3 1 11
Sales, y 31 33 78 62 65 61 48 55 120

4. Find the correlation coefficient between X and Y. Is there a weak or strong, positive or negative linear correlation between X and Y?

x -5 -3 4 1 -1 -2 0 2 3 -4
y -10 -8 9 1 -2 -6 -1 3 6 -8

5. The data below are the final exam scores of 10 randomly selected statistics students and the number of hours they studied for the exam. Find the correlation coefficient between hours studied and final exam scores. Is there a weak or strong, positive or negative correlation between hours studied and final exam scores?

hours, x 3 5 2 8 2 4 4 5 6 3
scores, y 65 80 60 88 66 78 85 90 90 71

© BrainMass Inc. brainmass.com October 25, 2018, 5:59 am ad1c9bdddf
https://brainmass.com/math/interpolation-extrapolation-and-regression/correlation-coefficient-linear-regression-analysis-443572

Solution Summary

The solution is given in report form in a Word document which is backed up with calculations shown in Excel.

$2.19
See Also This Related BrainMass Solution

Simple Linear Regression Analysis - Correlation Coefficient

Q: A very broad consensus has emerged around the proposition that global warming is a reality with likely serious global consequences. Moreover, while there is still not unanimity that is desirable to cut emissions from coal and petroleum. Finally, many energy economist and political leaders are advocating a multipronged approach to providing alternative energy including nuclear, natural gas, clean coal, and renewable sources from solar and wind. Municipalities and states have been asked by the Department of Energy to assess their energy requirements for the each of the alternative fuels. In particular, they have decided to focus initially on natural gas, given the enormity of U.S. reserves and its relative cleanliness. The regression output for selected municipalities in Illinois for 10 reporting periods (weeks) see below. The dependent variable is consumption of natural gas in millions of cubic feet (Fuelcons) and the independent variables is the temperature (Temp), measure in degrees Fahrenheit.
Regression Analysis

r² 0.836 n 10
r -0.915 k 1
Std. Error 0.766 Dep. Var. FuelCons

ANOVA table
Source SS df MS F p-value
Regression 24.0074 1 24.0074 40.89 .0002
Residual 4.6966 8 0.5871
Total 28.7040 9

Regression output confidence interval
variables coefficients std. error t (df=8) p-value 95% lower 95% upper
Intercept 15.2569 0.7913 19.282 5.43E-08 13.4323 17.0816
Temp -0.1173 0.0183 -6.395 .0002 -0.1595 -0.0750

Predicted values for: FuelCons
95% Confidence Interval 95% Prediction Interval
Temp Predicted lower upper lower upper Leverage
44 10.0976 9.5254 10.6698 8.2404 11.9548 0.105

Coefficient of determination = ______ (round to three decimal places)
Interpretation of the coefficient of determination:
A. This is the proportion of the total variation in temperature (in degrees Fahrenheit) that is explained by simple linear regression model.
B. This is the point estimate of the change in fuel consumption (in millions of cubic feet) associated with each degree (Fahrenheit) increase in temperature.
C. This is a measure of the variability of the observed values of fuel consumption from their predicted values at particular temperatures.
D. This is the proportion of the total variation in fuel consumption that is explained by the simple linear regression model.
E. This value has no practical interpretation.
Select your choice: _______ (A, B, C, D, E)
Correlation coefficient = _______ (round to three decimal places)
Interpretation of the correlation coefficient:
A. This tells us that there is a strong negative relationship between fuel consumption and temperature.
B. This is the point estimate of the change in fuel consumption (in millions of cubic feet) associated with each degree (Fahrenheit) increase in temperature.
C. Because of the negative value, this tells us to drop the temperature variable and look for other ways to explain what drives fuel consumption.
D. This tells us the proportion of the total variation in the 10 fuel consumption values that is explained by the simple linear regression model.
E. This value has no practical interpretation.
Select your choice: _______ (A, B, C, D, E)

Regression Analysis

r² 0.836 n 10
r -0.915 k1
Std. Error 0.766 Dep. Var. FuelCons

View Full Posting Details