Share
Explore BrainMass

Regression, Correlation, Least Squares Line, Etc.

** Please see attachment! **

The material is from MORE REGRESSION PROBLEM.
Please use any computer software to solve the problem if you want.
Please provide the evidence of your work and explain your solution.
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

Attachments

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