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

Need help with finding correlation coefficient.  COMPETENCY ASSESSMENT Introduction Assessment Rubric and Minimum Submission Requirements This

Need help with finding correlation coefficient.  COMPETENCY ASSESSMENT Introduction Assessment Rubric and Minimum Submission Requirements This competency assessment assesses the following Outcome(s): MM207M3: Determine the relationship between two variables. GEL-1.02: Demonstrate college-level communication through the composition of original materials in Standard English. It is time to demonstrate what you have

MUST HAVE/ BE FAMILIAR WITH THE SPSS STATISTICS SOFTWARE PROGRAM!!!!!!! PADM 810 Quantitative Analysis Report: Structure of

MUST HAVE/ BE FAMILIAR WITH THE SPSS STATISTICS SOFTWARE PROGRAM!!!!!!! PADM 810 Quantitative Analysis Report: Structure of Assignments 1. Use the following structure for your research article: Abstract, Introduction, Literature Review/Theory, Methods, Results, Discussion, and Conclusion. Include a robust discussion section distinct from your conclusion. 2. Give your article a

MAT210 – Week 3 Assignment Template Week 3

MAT210 – Week 3 Assignment Template Week 3 Assignment – The Foundation of Data-Driven Decisions Name: [Add your name] Professor Name: [Add your professor’s name] Date: [Add the Date Submitted] You would like to determine whether eating before bed influences sleep patterns. List each of the seven steps for conducting