Share
Explore BrainMass

Correlation Coefficient & Linear Regression Analysis

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

Solution Summary

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

$2.19