Share
Explore BrainMass

# Regression, Correlation, Least Squares Line, Etc.

The material is from MORE REGRESSION PROBLEM.
Please use any computer software to solve the problem if you want.
Thank you.

June Rainfall Blueberry
4.1 56.2
5.18 40
4.52 45.9
5.49 45.3
4.89 38.5
1.11 32.4
5.35 31
2.09 50
0.6 18.2
6.53 30.1
1.4 45.8
3.8 56.1

#### Solution Preview

I answered these problems in Excel. Let me know if you have any questions or need more information.

June Rainfall Blueberry
4.1 56.2
5.18 40
4.52 45.9
5.49 45.3
4.89 38.5
1.11 32.4
5.35 31
2.09 50
0.6 18.2
6.53 30.1
1.4 45.8
3.8 56.1

(a) Correlation coefficient.

I had Excel calculate this automatically. Use the =CORREL() function.

r = 0.142406531

The correlation coeffiecient is r = 0.143.

(b) Least squares line.

I plotted the data in a scatterplot and put the regression line (and its equation) on the plot.
This graph happens to be the answer to part (c).

The linear regression line is y = 0.824x + ...

#### Solution Summary

The expert examines regression, correlation, and least square lines.

\$2.19