Главная
Study mode:
on
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
Description:
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
Add to list
#Business #Business Software #Microsoft Office 365 #Microsoft Excel #Data Science #Data Visualization #Mathematics #Statistics & Probability #Linear Regression #Statistical Analysis #Correlation #Covariance
0:00 / 0:00
1 of 34

) Introduction