Please enable JavaScript.
Coggle requires JavaScript to display documents.
Correlation and Regression - Coggle Diagram
Correlation and Regression
Positive Correlation: One variable increase as another variable increases.
Negative Correlation: One variable decreases as another variable increases.
The Correlation Coefficient
=1: all the data points on
the set are found on the positive trend line.
=-1: all the data points
are found on the negative trend line.
=0: no relationship between the variables, and there is no trend line.
Steps to calculate correlation Coefficient
Excel’s CORREL formula
Data Analysis ToolPak
Linear Regression Analysis - predict how one variable might behave
given changes in the other variable
Creating the Regression Worksheet
Copy the data table into a new worksheet in Excel.
Select Data and then Data Analysis from the top menu.
Select Regression and click OK.
Select A as your Y input range and as your X input range.
If you selected header data when inputting ranges, check that labels are included.
Check the box for new worksheet.
Check the box for line fit plots.
Click OK