Excel: Simple Linear Regression Manual Calculation (Step By Step)

Channel:
United Kingdom Hmran UK (Hmran)
Subscribers:
22,100
Published on ● Video Link: https://www.youtube.com/watch?v=ecmNH5TB7Ms


Category:
Tutorial
Duration: 22:50
128 views
3

In this video I show the steps of calculating simple linear regression manually and using Excel functions and compared against the result of the data analysis toolpack. I covered the following:

1. Correlation (R)
2. Coefficient of Determination (R2)
3. Adjusted R2
4. Standard Error (SE)
5. Observation (Sample Size)
6. Degree of Freedom (df)
7. Sum of Squares (SS)
8. Mean Sum of Error (MSE)
9. F Statistic
10, Regression Model Significance (P-Value)
11. Intercept
12. Slope
13. Standard Error of Coefficient
14. T Statistic
15. P-Value
16. Residuals

I hope you enjoy watching the video.



Other Videos By Hmran UK (Hmran)


2021-06-09Excel: Multiple Linear Regression Manual Calculation (Step By Step)
2021-06-08Pokemon Go: Three Lucky Trades Shiny Gible Kyogre Lugia
2021-06-07Pokemon Go: Evolving 10 Unique Shiny Pokemons (Batch 5)
2021-05-11Excel: Multi Coloured Line Chart (Step By Step)
2021-05-06Horsefield Tortoise Enjoying The Sunshine (Spring Season)
2021-05-06Pokemon Go: Evolving 10 Unique Shiny Pokemons (Batch 4)
2021-04-30Pokemon Go: Evolving 10 Unique Shiny Pokemons (Batch 3)
2021-04-13London Life Exposed In Reverse: Birds Eye Of South Kensington And Knightsbridge
2021-04-13The Fun Riding Banana Bike In Battersea Park In London
2021-04-12Royal Spotted Next Royal Air Force Helicopter Landing And Takeoff Buckingham Palace London
2021-03-07Excel: Simple Linear Regression Manual Calculation (Step By Step)
2021-03-06Pokemon Go: Evolving 10 Unique Shiny Pokemons (Batch 2)
2021-03-05Pokemon Go: Purifying 3 Stars Shadow Pokemons From Zero To Hero
2021-02-11Pokemon Go: Evolving 10 Unique Shiny Pokemons (Batch 1)
2021-02-10Pokemon Go: Weather Logic Is Crazy
2021-02-08Horsefield Tortoise 3 Months Old Enjoying The Snow (Winter Season)
2021-01-24Snowing In The UK: Relaxing Time-Laps & Slow-Mo Capturing Snowflakes Using iPhone 12 Pro & iPad Pro
2021-01-24Pokemon Go: Lucky Trade Shiny Groudon Unexpected IV Almost Shundo
2021-01-11The Last Campfire: The Cave: A Brief Journey Puzzle
2021-01-11The Last Campfire: The Cave: Into The Dark Puzzle
2021-01-11The Last Campfire: The Cave: Turned Around Puzzle


Tags:
excel
simple
linear
regression
slope
intercept
constant
beta
alpha
gradient
trend
function
formula
equation
residual
standard
mean
error
sum
squars
correlation
determination
pvalue
value
anova
df
degree
freedom
Coefficient
sample
population
variance
deviation