Dive into a comprehensive video tutorial on linear regression, covering 12 crucial calculations including covariance, correlation, slope, y-intercept, and various sum of squares concepts. Explore Excel functions like FORECAST.LINEAR, COVARIANCE.S, and PEARSON through diagrams, animations, and practical examples. Learn to create X-Y scatter charts, understand different types of relationships, and interpret residual plots. Master the application of least squares method, calculate R-squared, and use the Data Analysis Regression Tool. Gain insights into testing regression assumptions and making predictions using the estimated equation.
Linear Regression Made Easy - The Epic Full Story with All Details - Excel Statistical Analysis
ExcelIsFun via YouTube
Overview
Syllabus
) Introduction.
) Outline for topics.
) X and Y Data Sets. Regression shows correlation, not causation..
) X-Y Scatter Chart .
) Types of Relationships.
) Add Ybar and Xbar Lines to X-Y Scatter Chart.
) Sample Covariance. Why the formula is cool.
) How to make sense of the Linear Regression Formulas, in a visual way.
) Calculate Sample Covariance.
) Calculate Coefficient of Correlation.
) Calculate Sample Standard Deviation.
) Simple Linear Regression Estimated Equation: Population Parameters and Sample Statistics..
) Assumptions to use Estimated Equation to predictions won’t be too high or too low.
) Look at formulas for Slope and Y-Intercept. Look at Least Squares Method, including Deductive Proof.
) Calculate Slope.
) Calculate Y Intercept.
) Use formula to create algebra/statistics formulas. Learn about the FIXED function..
) Experimental Range.
) Make prediction with estimated equation.
) Add equation to chart.
) Understanding SST = SSR + SSE and R Square..
) What are Residuals?.
) Great Visuals for Residuals and SST + SSR + SSR and R Squared.
) Calculate SST, SSR and SSE.
) Calculate R Squared = Coefficient of Determination.
) Calculate Mean Square Error = MSE.
) Calculate Standard Error of Estimate (y) = s.
) Calculate Mean Square Regression = MSR, F Test Statistic and p-value to test reasonableness of relationship.
) Understanding Residual Plot to Test Regression Assumptions.
) Build Residual Plot.
) FORECAST function.
) Data Analysis Regression Tool.
) Summary of video.
) Closing, Next Video and Video Links.
Taught by
ExcelIsFun
