How to calculate a regression equation, R Square, Using Excel Statistics

  Рет қаралды 244,779

statisticsfun

statisticsfun

15 жыл бұрын

Tutorial shows how to calculate a linear regression line using excel.
Like MyBooKSucks on: / partymorestudyless
Playlist on Regression
• Linear Regression.
Created by David Longstreet, Professor of the Universe, MyBookSucks
/ davidlongstreet

Пікірлер: 45
@patricksilva2345
@patricksilva2345 6 жыл бұрын
You are a real Professor. After this, I can understand all the formulas behind it, but also the idea (logic). Thank you so much. I will be here with you to support you, always! You are changing this world. My respect!
@tusharsaini6558
@tusharsaini6558 Ай бұрын
Hi David, you are amazing. I am a PhD student in finance and wanted to go back to the basics, in this world of complicated analysis, I forgot the basics, but I have a solid grip now. Thank you for all the videos. It's amazing! although I cannot cite youtube videos in my classes, but ill definately share your link to the students. You are doing a great service.
@statisticsfun
@statisticsfun 12 жыл бұрын
I would encourage to watch the playlist on regression. In the playlist I walk you step by step how to calculate all the different parts of the linear regression.
@pshearer80
@pshearer80 11 жыл бұрын
These vids are excellent. I actually like them better than Khan. Clearer, to the point and right down to business.
@aaronlai04
@aaronlai04 12 жыл бұрын
How do you derive the b(0) = 39 and b(1) = 12?
@rodrigocustodio1955
@rodrigocustodio1955 4 жыл бұрын
Highly effective way of teaching, breakdown concepts into manageable parts and students will master more complex material in future stages. You should consider teaching other teachers how to teach.
@statisticsfun
@statisticsfun 11 жыл бұрын
Column d is the difference between the mean of x and the x and column e is the difference between the mean of y and y. So d x e (or column F) is just column d and column e times each other.
@apotheosis00
@apotheosis00 13 жыл бұрын
Clear and helpful explanation. I really enjoy your videos. Thank you.
@statisticsfun
@statisticsfun 12 жыл бұрын
Thanks so much for the feedback, much appreciated. Make sure you like MyBookSucks on Facebook. Search MyBookSucks or click on the link above.
@statisticsfun
@statisticsfun 11 жыл бұрын
Well, thank you very much for the compliment -- it is much appreciated.
@DanielaILungu
@DanielaILungu 10 жыл бұрын
Absolutely brilliant! Thank you so much! Would be so helpful if you could do one on Event Studies as they are quite related :)
@84charlotte84
@84charlotte84 12 жыл бұрын
I LOVE your videos! Statistics suddenly makes more sense :)))
@statisticsfun
@statisticsfun 11 жыл бұрын
What a great observation. You are exactly right that Higher Education is broken! I have thought that for many years myself. That is the focus on research instead of teaching. In the end, what gets rewarded, get's repeated and get's improved. Professors are only doing what is getting rewarded, you are right. Another problem, on this same topic, is those that want to focus on teaching are somehow being shunned by higher education as not real academics.
@jdd32005
@jdd32005 13 жыл бұрын
Excel tip: Hitting F4 is the hotkey to "absolute reference" cells, so you don't have to manually type in the dollar signs. Hitting it multiple times will change it to lock in only the row, only the column, or both the row and the column.
@reenhashim8462
@reenhashim8462 5 жыл бұрын
Hi Sir David, may I request from you what Canonical Analysis is? I'm struggling to understand it. Thank you for any response.
@manaskrthk
@manaskrthk 3 жыл бұрын
YOU ARE A WONDERFUL TEACHER
@statisticsfun
@statisticsfun 11 жыл бұрын
Awesome! Thanks.
@Strive12
@Strive12 13 жыл бұрын
immensely helpful. thank you...
@skillsandresearch2485
@skillsandresearch2485 2 жыл бұрын
THANKS FOR THE BEST EXPLANATION. WHEN I CALCULATE VALUE OF B0 and B1 and it is not like that as you mentioned in the excel sheet
@JanforWidol
@JanforWidol 11 жыл бұрын
These online videos teach me more than any of my college courses ever have, and I didn't have to pay a dime for tuition. I think the problem stems from the fact that professors are not actually professional teachers -- they're first and foremost *researchers*. Most of them care staggeringly little about how effectively they teach. But how could you blame them? Most of their income comes from the grants they bring in with their research. The higher education system is BROKEN!!!
@abdulghanialarabi9931
@abdulghanialarabi9931 9 жыл бұрын
Excellent work , just I have one comment , the last column in the excel sheet should be named as the explained sum of squares (systematic variation) not the residual sum squares (the random variation) as r square = explained sum squares/total sum squares . My understanding to the Explained sum squares is = sum squares of the deviation of the estimated values from the mean of a dependent (response) variable While SSR = sum squares of the deviation of the estimated values from the actual values of a dependent (response) variables I think you explained this nicely in other video
@statisticsfun
@statisticsfun 12 жыл бұрын
The honest answers is while I can do statistics well I am not such a good speller. I could just blame Excel for autocorrecting to the wrong word. The column heading should be predicated as well.
@HieuNguyen-pd2dt
@HieuNguyen-pd2dt 4 жыл бұрын
thank you, amazing
@mulualemtefera2253
@mulualemtefera2253 2 жыл бұрын
best tutorial
@juniphdr
@juniphdr 12 жыл бұрын
Statisfaction :) Thank you
@megazzeth
@megazzeth 11 жыл бұрын
Hi, Could anybody please tell me what is d x e? Thanks
@English29534
@English29534 12 жыл бұрын
Why did you youse mean of actual y numbers instead of mean of predicted values itself in calculating SSR...Thank you in advance
@s2korpionic
@s2korpionic 8 жыл бұрын
Why should we put a dollar sign before and after the B @2:45?
@YoshiBoshiPoochy
@YoshiBoshiPoochy 5 жыл бұрын
To keep the variables constant in the equation. (b0 + b1*x). b0 and b1 will not change throughout the equation, but x (the thing we control) will. I'm not super pro at excel, but from what I'm looking at, I'm assuming the $ symbol (dollar sign) will keep the values tied to the equation whenever you format the column while allowing x to change accordingly. He also does the $ thing around 5:27 since he wants to keep the mean constant. Hope that helps.
@karolinenavntoft5050
@karolinenavntoft5050 2 жыл бұрын
I have a reoccuring problem: the values that should sum up to zero - some of them don't add up to zero. What could the problem be? I have redone calculations, but it keeps happening... Can you please help
@English29534
@English29534 12 жыл бұрын
Why we usead mean of y data during calculating SST instead of mean of predicted value. The predicted datas has its own mean ...Thank you in advance
@mulualemtefera2253
@mulualemtefera2253 2 жыл бұрын
what about Standard error of the estimate?
@rishabhmalhotra7017
@rishabhmalhotra7017 2 жыл бұрын
I have a doubt. What is sum of squares? I have been watching the entire playlist for regression but this video kind of confused me. Sum of squares was suddenly mentioned in the beginning of this video. Could you explain what it is? I mean, why are we doing it? Why do we need to calculate SSE, SST before doing SSR?
@natskis
@natskis 12 жыл бұрын
Great videos! Btw, you keep calling it the "predicted" values... but the column header is "predicated". Is there a reason for this?
@baronnavadne8731
@baronnavadne8731 Жыл бұрын
the reason is inability to spell correctly. It is predicted, not 'predicated'.
@rydercarter7035
@rydercarter7035 6 ай бұрын
​@@baronnavadne8731It's most likely just a typo, and definately not due to his "inability to spell correctly".
@edutechbharat.
@edutechbharat. 2 жыл бұрын
Hello sir 🙏 how to calculate b0 and b1 ?
@statisticsfun
@statisticsfun 12 жыл бұрын
Thanks. PARTY MORE study less. Like MyBookSucks on FaceBook.
@andrewstubbs8158
@andrewstubbs8158 7 жыл бұрын
What is the b_1 value? everything in this video is great except not saying what that is. It's 12 but ?
@nitinvirat
@nitinvirat 4 жыл бұрын
To calculate R square we need SST and SSR, now I don't understand why we are calculating SSE. Can anyone help me with this.
@kalpeshkhairnar4545
@kalpeshkhairnar4545 5 жыл бұрын
how to take b1
@ryansmylie8974
@ryansmylie8974 8 жыл бұрын
meow
@bdpatton2
@bdpatton2 8 жыл бұрын
move faster haha
@therealone4113
@therealone4113 5 жыл бұрын
this made 0 sense
@maxsharifi3803
@maxsharifi3803 3 жыл бұрын
bla blaa and then in the end not saying how to do it
How to Calculate Linear Regression SPSS
7:09
statisticsfun
Рет қаралды 220 М.
Interpreting Linear Regression Results
16:08
Sergio Garcia, PhD
Рет қаралды 296 М.
MEGA BOXES ARE BACK!!!
08:53
Brawl Stars
Рет қаралды 36 МЛН
Me: Don't cross there's cars coming
00:16
LOL
Рет қаралды 15 МЛН
How to calculate linear regression using least square method
8:29
statisticsfun
Рет қаралды 1,7 МЛН
How to calculate a Regression Equation Using Excel Statistics
6:18
statisticsfun
Рет қаралды 93 М.
Calculating r and r2
13:56
Erika Malinoski
Рет қаралды 132 М.
Learn Statistical Regression in 40 mins! My best video ever. Legit.
40:25
Using Multiple Regression in Excel for Predictive Analysis
9:18
Management Information Systems
Рет қаралды 1,7 МЛН
How To Perform Simple Linear Regression In Excel
14:51
Steven Bradburn
Рет қаралды 417 М.
Correlation and Regression Analysis: Learn Everything With Examples
9:50
LEARN & APPLY : Lean and Six Sigma
Рет қаралды 1,5 МЛН
How to perform ANOVA in MS Excel #statistics #shorts #viral
1:00
Abrar Knowledge
Рет қаралды 52 М.
MEGA BOXES ARE BACK!!!
08:53
Brawl Stars
Рет қаралды 36 МЛН