How to do a linear regression on excel

[@raindropmangoes]

no long intro, no sponsorships, gets right into the content, love it !!

[@jaclynott468]

This video explained more in 5 minutes that two chapters from my assigned reading in Data Analytics class. Thank you!!

[@glovymaejoyceliza3277]

Ag

[@kelleyjernigan7045]

BEST TEACHER EVER!!! She explains it all so simply and clearly. Most importantly, she doesn’t assume we’re all statistical and Excel geniuses and doesn’t hyper speed through. So many other tutorial teachers click everything so fast I can’t even see what icon they clicked when I pause it. Thank you so much!!!!

[@carsonarrington5710]

Saved me at 11:30 on a math assignment that was due at 11:59, Thanks!

[@Liannet.b]

This video is GOLD! Did my homework in less than 5 minutes. THANK YOU!!!!!!

[@diannethereselosaria9734]

This is a holy grail man. It's already 5 am here in PH and I'm still doing my online worksheet due to Covid - 19. This saves me a lot. Time to watch Elite!

[@austinzzt3964]

SIS tangina me too HAHAHA

[@brittneymorales710]

as u should

[@hehehe9618]

wieeeeeeeee same

[@ivanchua1381]

same here sksksksksksk

[@2ez4frondy]

SIS DITO 2:48AM

[@morpheus7144]

Brilliant, thank you so much for explaining this in simple terms! I've been spending hours going through people explaining regression as if you need a degree in statistics to understand the jargon!

[@raihanjumatlkc]

Brilliant video. This tutorial explained to me what I did not know I did not know!

[@michaellevy5098]

This is incredibly helpful. Very clearly taught & explained. Thank you so much!

[@demarcusscott3761]

Can we say simple! Thanks I needed this 36 hours ago still have time to re-check all the calculations I made.

[@cynthiafonta6251]

I can't believe I found this video. Thanks a lot for this!!!! Awesome

[@selenciynekli4569]

This is my first comment for youtube videos. This help me a lot! Thank you so much. ❤️

[@romanvasiura6705]

Your tip about "Quick Layout" - is amazing) - Thank you!

[@toerogaine5390]

This is so clearly explained, by obviously a pro...Great tutorial, thanks!

[@rafaelk8806]

the video is precise and offer a summary of linear regression. it save me alot

[@JWard6176]

This video does a FAR better job explaining this than my current statistics class, thank you.

[@rihannas_taco_salad]

Helped me solve a math problem. 10/10

[@cdiva2102]

absolutely love it...thanks a lot....It took me few hours to understand this initially and the video did that in 5 minutes....

[@glennbrown306]

Thank you so much. This was so helpful. You did half a semester of college stats in about five minutes!

[@OluwaseunAdeyinka-j2p]

Best video so far on linear regression

[@letsseewhatsupwithlex9875]

You are so to the point and knowledgeable.

[@bradleyharbor8147]

THANK YOU! bro just saved my career🙏

[@vojtechbadal8618]

This videos was very useful for me. Thanks for it.

[@radugabriel9303]

Great explanation in the shortest amount of time. Thanks :)

[@jamesfredrick612]

You're a life saver. Thank you so much!

[@Phacix]

to the poin, clear, perfect. as keren Lin says, it is possible to do it in more than one way, this one is one of the basics and ur tutorial was just neat.

[@SusanKarimi-u8w]

You just saved my semester thank you

[@DIVINADADY]

Lady you just saved my thesis

[@accountingprofessor4389]

You can also use the regression in Data Analysis

[@kingog8873]

this was so helpful for me studying health science thank u soo much

[@haroonhafeez2368]

Thank you, too perfect....! You won a subscriber...

[@jaredcarter7432]

I had to leave a comment, you saved me

[@nubel5574]

This was an awesome video. I Learnt a lot in such a short time

[@wangiseruni]

What a clear explanation. I'm beginner and I understand clearly. Thank you for sharing Mona.

[@BayouBoi68]

Thank you for making this task easy. I appreciate your simple explanation.

[@sepehr6027]

ommggg thanks, I have an exam tomorrow and my teacher never explained this, I finally understand where the Y comes from

[@jeffcesta2493]

Thanks for showing the formulas and explaining the meaning of slope and intercept.

[@MohdAsif-Alpha]

no nonsense, straight to the point

[@clementtimothy2018]

a master at work 🥶

[@VirtualSolace]

Thanks for explaining it wonderfully 🙌🙌

[@xinjietang8344]

I learnt R,python,SAS all about linear reg and now I feel excel is still powerful and easier 😂

[@wta_Tanzania]

I need to learn Python but still on the way which way is easy

[@rishabhdowarah663]

and like all good channels, this channel too stopped posting. thank you for this video!

[@aaliyahakak9694]

Thank you so much. Short and to the point!

[@birasafabrice]

Thanks a lot for this great tutorial!

[@edwardching9922]

I had to replay parts of it many times but wow very good.

[@AztecStar]

I will forever be indebted to you thank you!

[@erikmier6349]

You are amazing!!! Thank you so much.

[@OmarAl93]

Hey, thanks for the explanatory video. Is there a way to build predictive or forecast with the last equation?

[@jayratsby784]

Thank you very much! So helpful

[@DaGoodStoff]

Fantastic, Incredible, Bellissimo! Thanks for the Great Vid :)

[@MariaBuendia]

Thank you Mona, nice video :)

[@Quetzal00358]

Great! Is it possible to do multiple lines in one graph in Excel? Is it also possible to keep the line but remove the scatterplot?

[@lvteachme973]

Excellent video! Thank you.

[@royami8627]

This is such a good video

[@ibrahimnahushal9353]

thank you :) this is very helpful

[@anthonymcgeough4813]

Hi! How would I add another layer to an existing regression formula, as in this example? If we wanted to show more data

[@DavidWilliams-ce8cu]

Great video, thank you very much!

[@tahmeenakhan7248]

Thank you for wonderful explanation.

[@Terences123]

How did you slope and intercept automatically pop up when you put your elements to linear

[@angeloandrea11]

Saved me on my Accounting Project, thanks

[@dasbumba5685]

this is brilliant. thanks so much

[@nittayasmine9772]

Exellent, thanks a lot, i would use this regression analysis using excel for my huge data of atmospheŕic chemistry, hope this method will work

[@Juan-Hdez]

Very useful. Thank you!

[@LeoMoralesSr]

Why is the R squared in the actual graph different than the R squared of .3846 vs the R squared outside the graph? Correlation measure of strength of .62? Thanks.

[@jrobelen8137]

If you were wondering about (-0.62_)^2=0.3844 vs the R^2=0.3846, they are really close. The issue is that the -0.62 is rounded. Before she reduced the number of decimal places, she had r=-0.62016, and that value squared does round to 0.3846. I hope this helps.

[@thinkvibrant5721]

You're awesome, thank you!

[@goncalomarques251]

Have I said I love you yet? Thanks!!!!!!!

[@jasontaylor2237]

Hello Mona I know this is an old video but I hope you see my question. Can this be done with Stocks? thank you in advance.

[@DY-vn2df]

ur the best !

[@superjdillydillio9040]

I do not know if we can use truncated graphs.

[@LeoMoralesSr]

Why was the year not used at all here? Asking because it is listed along the X and Y axis.

[@aditsud5354]

Because this is a simple regression which has only two variables (an independent variable and a dependent variable). We are seeing how changes in the interest rates (independent variable) explain changes in the house prices (dependent variable). To include year in our regression, would change it into a multiple regression model (which is actually more robust at explaining causal relationships as it holds the other variables constant).

[@divan_dt]

why is it all my physics professors say linear regression is different from a trendline but you dont??? Im so confused cuz I know if I put a trendline in my graph im getting points taken off...

[@AndreiLloydLGaila]

How did you calculate the median home price?

[@alexchiggs8877]

Excellent video

[@hannahkarylamagkilat9075]

still helping even thou its been 7 years thank you

[@linakhan5406]

can you do this but have two x variables aka two predictor variables?

[@mensahfrancis866]

Pls,u re moving fast.Take u time and teach us.Thank you

[@brittneymarshall8951]

What if the formula gives you a minus instead of addition? Did I enter something wrong? I mean excel did all the work.

[@aslhanaslhan1092]

Hello, I did linear regression, but my teacher did not accept it because the number of steps in the formula was low. How can I increase it?

[@karthikeyannandhakumar368]

I have three value Time , Data 1 and Data 2 these 3 value changes every 2 mins(Which is in only one row) . how to draw the line if the value change plot the graph. Please help

[@manishanegi9132]

HI Mona, if the x variable is the number of employees in various functions and Y variable is their productivity in %, would this method help to predict the increase in productivity in various functions if the number of employees is increased in such a way that more than 95% of employees in each team has =>30% productivity?

[@qballa2787]

I’m dumb I see this gives r2 but how would you find r1

[@vladimirmisin1876]

Really sweet.

[@yus3158]

where do we write the formula?

[@draytonnolin4040]

Great content, however, some may have a difficult time comprehending it. The content is presented too fast for learning something new.

[@ssm-56281]

saved my life

[@ghostpolo9484]

this is why im hopeless in my class, follow vids to a T and cant get it not going to graduate because of this i double click axis and the optjons are not there for me

[@MariaMaria-yr9xp]

Can u share your dataset?

[@amkhrjee]

Dhanyawaad Didi

[@debashreehalder8063]

Thanks a lot ❤

[@miriamdaughtery771]

Thanks this is great. For my course work I have to also include a p-value, do you know how I obtain this?

[@AztecStar]

for future reference use the data analysis tool under the data tab and click the regression option then you can manually add the x and y values with only one respective title of the column so that the software does not get confused, then you'll see many different values including the p-value

[@yuji8178]

THANK YOU SO MUCH !!

[@drallisimo34]

cool tut!!!

[@adammurphy5429]

Thank you woman

[@mrmoe5272]

You are awesome

[@saklinsk4618]

Thank you mam. :)) . .. ...

[@kelsman1054]

thanks very helpful :)

[@yurihong4079]

does anyone know how to get the average value for x and y?

[@huyphamgia4957]

really appreciate

[@artiome9893]

R-square of 0.38 indicates your model is not linear...

[@rasangikadilshani5614]

Thank you so much