Igor's Physics Class Linear Regression Tricks

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

Category:

Education

Tags:

• Excel
• Linear
• Regression
• X-Y
• Scatter
• Diagram
• Chart
• Graph
• Trend
• Line
• PEARSON
• mike
• Gel
• Girvin
• Highline
• Community
• College

[frebert]

Love your videos. I feel like a hungry kid in a candy store with a Black American Express card. Why doesn't the "Intercept" function deliver the same value as that shown in the slope analysis of the graph. Shouldn't both calcs be the same?

Also do you have more Regression Analysis videos?

Thanks again for all your efforts.

[ExcelIsFun]

Good catch!!!! All this time and I did not notice. But i just looked and the data I highlighted for the chart is missing the top row of the data!!! If you edit the source data (Design Ribbon tab, Surce data button) or just re-make the chart!!

[kims2009]

great video, thank you

[ExcelIsFun]

You are welcome!

[physhero]

Thank you. My physics students could learn much more thanks to your wonderful Youtube!

[ExcelIsFun]

I am glad that the video helps!

[joaocardoso123]

Thanks! very very helpful

[ExcelIsFun]

I am glad that the video helps you and others at your school!

[forzaitaly1]

OMG U just Made my Day, Now I don't have to calculate the slope of 15 different lines one at a time by hand. Everyone in my schools gonna know about this channel. thank u so much...

[ExcelIsFun]

You are welcome!