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

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

[@statisticsfun]

Thanks so much for the feedback, much appreciated. Make sure you like MyBookSucks on Facebook. Search MyBookSucks or click on the link above.

[@patricksilva2345]

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!

[@aaronlai04]

How do you derive the b(0) = 39 and b(1) = 12?

[@84charlotte84]

I LOVE your videos! Statistics suddenly makes more sense :)))

[@English29534]

Why did you youse mean of actual y numbers instead of mean of predicted values itself in calculating SSR...Thank you in advance

[@rishabhmalhotra7017]

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?

[@ryansmylie8974]

meow

[@statisticsfun]

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.

[@statisticsfun]

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.

[@statisticsfun]

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.

[@statisticsfun]

Well, thank you very much for the compliment -- it is much appreciated.

[@rodrigocustodio1955]

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.

[@pshearer80]

These vids are excellent. I actually like them better than Khan. Clearer, to the point and right down to business.

[@DanielaILungu]

Absolutely brilliant! Thank you so much! Would be so helpful if you could do one on Event Studies as they are quite related :)

[@reenhashim8462]

Hi Sir David, may I request from you what Canonical Analysis is? I'm struggling to understand it. Thank you for any response.

[@statisticsfun]

Thanks. PARTY MORE study less. Like MyBookSucks on FaceBook.

[@JanforWidol]

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!!!

[@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.

[@karolinenavntoft5050]

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

[@mulualemtefera2253]

what about Standard error of the estimate?

[@jdd32005]

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.

[@skillsandresearch2485]

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

[@nitinvirat]

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.

[@statisticsfun]

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.

[@statisticsfun]

Awesome! Thanks.

[@megazzeth]

Hi, Could anybody please tell me what is d x e? Thanks

[@mulualemtefera2253]

best tutorial

[@abdulghanialarabi9931]

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

[@andrewstubbs8158]

What is the b_1 value? everything in this video is great except not saying what that is. It's 12 but ?

[@s2korpionic]

Why should we put a dollar sign before and after the B @2:45?

[@YoshiBoshiPoochy]

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.

[@English29534]

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

[@edutechbharat.]

Hello sir 🙏 how to calculate b0 and b1 ?

[@manaskrthk]

YOU ARE A WONDERFUL TEACHER

[@HieuNguyen-pd2dt]

thank you, amazing

[@kalpeshkhairnar4545]

how to take b1

[@Strive12]

immensely helpful. thank you...

[@juniphdr]

Statisfaction :) Thank you

[@natskis]

Great videos! Btw, you keep calling it the "predicted" values... but the column header is "predicated". Is there a reason for this?

[@baronnavadne8731]

the reason is inability to spell correctly. It is predicted, not 'predicated'.

[@rydercarter7035]

​@@baronnavadne8731It's most likely just a typo, and definately not due to his "inability to spell correctly".

[@bdpatton2]

move faster haha

[@maxsharifi3803]

bla blaa and then in the end not saying how to do it

[@therealone4113]

this made 0 sense

[@apotheosis00]

Clear and helpful explanation. I really enjoy your videos. Thank you.