Рет қаралды 788
In this video you will find 6 different methods to perform linear regression using Excel, from the simple to the advanced.
We'll start with the basics of linear regression and work our way up to more advanced techniques. You'll learn how to use the LINEST function, the Regression Analysis tool, SOLVER, and even how to build from scratch the equation with the mathematical formulas.
By the end of this video, you'll have a solid understanding of linear regression in Excel and be able to choose the best method for your specific data analysis needs.
===CHAPTERS===
01:48 Manual method
04:54 Solver method
09:25 Excel Regression tool
11:30 Trendline from Scatter Chart method
12:36 LINEST() method
14:04 Mathematical formulas method
#ExcelLinearRegression #DataAnalysis #DataVisualization #RegressionAnalysis #DataScience #ExcelTips #ExcelTricks #LINESTfunction #linearregression