The Best Fit Line in Excel in Just Minutes!

Описание: The fastest way to find the equation of a regression line with Excel isn't what you think. I'll show you how to find the equation of the best fit line, then we'll see how to graph the scatter plot, trendline, equation of the regression line, and r^2 value. Finally, I'll show you a quick and accurate way to have Excel compute r, the correlation coefficient, for your data.

▶ Watch
Make A Box Plot    • How To Make A Box Plot In Excel | Make a B...  
More Excel Tutorials    • Excel + Google Sheets Tutorials  

Chapters
00:00 Introduction
00:17 Regressions In Excel The Easy Way
02:19 Scatter Plot and Trendline
04:31 Correlation Coefficient, R

Looking for more great videos? Check out these:
My Channel    / angieteachesmath  
   • Creating a Line of Best Fit on Excel  
   • Create an XY Scatter Chart in Excel  
   • Excel Basics - Linear Regression - Finding...