Igor’s Physics Class Linear Regression Tricks



Online Courses for microsoft excel :

Course updated 2009-01-29 19:26:43

Instructor : ExcelIsFun

Course Duration : 15:21

Rating : 4.72 / 5

Step by step & Descreption :
Linear Regression
X-Y Scatter Diagram Chart Graph
X Y Scatter diagram Chart Graph
Add Axis Labels to X Y Scatter diagram Chart Graph
Add Data Points Labels to X Y Scatter diagram Chart Graph
Add Trend Line (y = mx + b) to X Y Scatter diagram Chart Graph
Add R squared R^2 Coefficient of Determination to X Y Scatter diagram Chart Graph
Calculate Correlation with PEARSON and CORREL function formulas in Excel
Calculate slope with SLOPE function formula in Excel
Calculate intercept with INTERCEPT function formula in Excel
Calculate Coefficient of Determination with RSQ function formula in Excel