Completed
) FORECAST function
Class Central Classrooms beta
YouTube videos curated by Class Central.
Classroom Contents
Linear Regression Made Easy - The Epic Full Story with All Details - Excel Statistical Analysis
Automatically move to the next video in the Classroom when playback concludes
- 1 ) Introduction
- 2 ) Outline for topics
- 3 ) X and Y Data Sets. Regression shows correlation, not causation.
- 4 ) X-Y Scatter Chart
- 5 ) Types of Relationships
- 6 ) Add Ybar and Xbar Lines to X-Y Scatter Chart
- 7 ) Sample Covariance. Why the formula is cool
- 8 ) How to make sense of the Linear Regression Formulas, in a visual way
- 9 ) Calculate Sample Covariance
- 10 ) Calculate Coefficient of Correlation
- 11 ) Calculate Sample Standard Deviation
- 12 ) Simple Linear Regression Estimated Equation: Population Parameters and Sample Statistics.
- 13 ) Assumptions to use Estimated Equation to predictions won’t be too high or too low
- 14 ) Look at formulas for Slope and Y-Intercept. Look at Least Squares Method, including Deductive Proof
- 15 ) Calculate Slope
- 16 ) Calculate Y Intercept
- 17 ) Use formula to create algebra/statistics formulas. Learn about the FIXED function.
- 18 ) Experimental Range
- 19 ) Make prediction with estimated equation
- 20 ) Add equation to chart
- 21 ) Understanding SST = SSR + SSE and R Square.
- 22 ) What are Residuals?
- 23 ) Great Visuals for Residuals and SST + SSR + SSR and R Squared
- 24 ) Calculate SST, SSR and SSE
- 25 ) Calculate R Squared = Coefficient of Determination
- 26 ) Calculate Mean Square Error = MSE
- 27 ) Calculate Standard Error of Estimate (y) = s
- 28 ) Calculate Mean Square Regression = MSR, F Test Statistic and p-value to test reasonableness of relationship
- 29 ) Understanding Residual Plot to Test Regression Assumptions
- 30 ) Build Residual Plot
- 31 ) FORECAST function
- 32 ) Data Analysis Regression Tool
- 33 ) Summary of video
- 34 ) Closing, Next Video and Video Links
