To calculate the correlation factor (r), go to Excel, Formulas, Statistics, and select the CORREL function. To calculate the Regression Equation and

  • To calculate the correlation factor (r), go to Excel, Formulas, Statistics, and select the CORREL function.
  • To calculate the Regression Equation and Coefficient of Determination:

a. Select the x,y data

b. Insert a scatter chart from that data

c. Click the chart, go to Chart Design

d. Go to Quick Layout

e. Select Layout 9

f. Then you get the Regression Equation, and r square.

Using MS Excel, prepare a Simple Linear Regression for the following data:
In the data that follows, X=median diameter (in millimeters) of granules of sand, and Y=gradient of beach slope in degrees on natural ocean beaches.
 

   

X  
0.17
0.19
0.22
0.235
0.235
0.30
0.35
0.42
0.85 

Y

0.63
0.70
0.82
0.88
1.15
1.50
4.40
7.30
11.30

 

Then using MS Excel:

 1) Find the sample mean and standard deviation for x and y.
2) Calculate the Coefficient of Correlation (r).
3) Make a scatter plot.
4) If there is correlation, then find the equation of the least-square line or regression line, and then graph the line on the scatter plot.
5) Find the coefficient of determination r**2 (r square).

Share This Post

Email
WhatsApp
Facebook
Twitter
LinkedIn
Pinterest
Reddit

Order a Similar Paper and get 15% Discount on your First Order

Related Questions

I need support with a math question. I will attach the document for review. Borough of Manhattan Community CollegeMathematics

I need support with a math question. I will attach the document for review.  Borough of Manhattan Community College Mathematics Department Name___________________________ Instructor L. Erstenyuk Date ___________________________ MAT 216-_____________ EXAM 1 REVIEW Instructions. Show all steps and label answers. Papers will be graded on clarity, neatness and organization as well

Q2 ( A and B)Group Assignment-CMA Semester 4 pg.

Q2 ( A and B) Group Assignment-CMA Semester 4 pg. 1 DEPARTMENT OF UNDERGRADUATE PROGRAMME B.Sc. in Accounting, Auditing and Finance GROUP ASSIGNMENT BRIEF Weightage: 30% Student Name & ST Number 1. 2. 3. 4. 5 Semester IV Feb to May 2024-25 (Spring 2024-25) Assignment Title Material costs and Overheads.