Excel Regression Analysis through the Toolpak

Using Data Analysis Toolpak Regression analysis and interpreting the results. Its one of those powerful tools in Excel Data Analysis Toolpak that can save your from having to learn other software like STATA and SPSS.

[@blackbeltchiken]

This video saved my college career, thank you so much. Great explanations for everything and really easy to follow. Keep up the videos.

[@marysevele1993]

By far, the most helpful video I've come across on regression analysis! Thank you :)

[@yalestultz1935]

Truly one of the most helpful videos I have seen for my college econometrics class, thanks!

[@nep4912]

this was helpful and to the point, without any unnecessary filler! great stuff, thank you :)

[@ThePlayerOfGames]

I was having a nightmare doing regression analysis until I started simplifying my thoughts, doing big-scale simpler queries to filter data before going more specific This video helped me a lot

[@vanessarizo7228]

THIS VIDEO LOWERED MY STRESS LEVEL

[@chi3750]

Thank you for your clear explanation! Still very useful in 2022!

[@NotWithinLimits]

This is awesome! I appreciate you very much!

[@TheB1GChill]

Why could I not understand this in class?? Thanks!

[@benjaminogonyo3505]

It's because of tension 😂

[@venuszavareh4522]

I’ve been watching multiple videos on regression and data analysis and this is the only one I understood! Thank you so so so much! 😊

[@japeriawilliams4470]

really helpful, and easy to understand based on example. Thank you!

[@senpaitama8778]

Thank you so much! You're a life saver! Please make more videos

[@Joeman_Joeman]

thank you, this videos is saving my ass right now

[@baezledesma3439]

Great video, very nice explanation, thank you for taking the time to make it for learners :)

[@hariralatif4600]

I can't select two rows on my excel sheet ?

[@sangeethasockalingam6226]

Thanks a lot sir. Very useful video.

[@chipapamukupa6005]

Thanks a lot this really helped me 🤗

[@xXKishann10Xx]

this was a very very useful video thanks a lot !

[@TheReal_Antrey]

Who are you that shows me EXACTLY what Im looking for? Thx btw

[@crackshack2]

Good tutorial on Regression Analysis!

[@hongduong260]

hi, thanks for your usefull tutoriial, but can't find "Data Analysis" tool on my office 365

[@kavinp6423]

I can't thank you enough

[@kylecrane1837]

Excellent tutorial!

[@afifahhasnu6411]

Why Data Analysis is not on my Excel? T_T

[@povilasalkevicius7300]

Thank you! Helped a lot

[@stezzytato]

How do you get the estimated regression model formula

[@charbelkaram4943]

the P value is higher than 0.05, normally we accept the hypothesis, which means there is a relation between dependent and independent variables. In the end of the video, you are saying that there is no relation, any clarifications?

[@anthonywashington2885]

It's too bad they removed this feature in excel 2023. Such a useful tool Microsoft removed!

[@AlizeMerchant]

TOBIN, GOD BLESS YOU- nearly midnight trying to wrap my head around the cobb-douglas production function, given me the trick to get my coefficients in 5 minutes MY MAN

[@nickcrawshaw9348]

Holy shit, cannot thank you enough!

[@ShapinguptheBuiltForm-ArMohinM]

Thanks for sharing. Very helpful

[@glipk]

Going to watch Cocoa Crisps the Film later as a way to celebrate

[@couga861900]

Very good video. It is very helpful.

[@tenzint2268]

whats the output range? my laptop says i need to fill an outpuj-ut range as well

[@MrMosoani]

can we also use regression to know what drives long talk time in Call Center?

[@starbusttweety]

Is P- value the only way to determine whether these factors affect sales or not?

[@frankisneiderfierroguarniz359]

it is an excellent video...

[@BesideTheVoid]

4:11 but you would say they "these variables have a significant correlation with ticket sales" or something, to avoid claiming causation from correlation, right? Could you rephrase that sentence?

[@rishikulshrestha3128]

I have done a regression analysis on a dataset, but due to the way the data is, one of the variable is getting a negative coefficient in the final equation. Eg. Y = aX1 - bX2. But I know for sure that the variable X2 has a positive effect on Y. So, my question is: What to do when your regression or correlation analysis gives you a coefficient which is either of opposite sign or of low magnitude but you theoretically know that for sure the variable has a positive and a strong influence.please help

[@DaniBibiana]

You're amazing! Thank you SO MUCH!

[@khushinarang5146]

Sir from where you have collected the data

[@chenli9343]

Thank you so....much, you save my life! I will finish my homework, it’s near to deadline

[@isaaca5043]

same

[@hayleyamethyst7233]

Thanks for the big help! Im stressing with my project in school and I saw this. It helped me really .

[@zfazzershroudvietcynide64e58]

you explained this in 5mins and i learn so much, my teacher explained this in 1hr and I didn't learn that much.

[@habyarimanajean761]

Very easy to understand.

[@lwazikhanye3344]

thank you , thank you, thank you

[@fredsempire1676]

So what's the solution to this

[@caseysantiago9067]

how come when i do this i get n-1 observations even if i clicked n observations? for example i have 10 observations but it says 9 and each x has a corresponding y value?

[@victormoreno803]

thank youuu

[@ekrajchaudhary7036]

Good job, keep it up

[@D0land0_94]

What if you just have a set of values and your x-axis is the date? is this possible?

[@ehsanjamshidi3684]

Thanks Tobin. It was helpful.

[@gustavduplessis1024]

Thank you!

[@khan1a1khan]

God bless you

[@globtrotter1976]

Hi there. anybody knows how to perform the same task with linux?

[@peelenerikpeelen]

Great Video!

[@prasadkumanayake3785]

Truly, this was helpful. So simple. Reflects the depth of knowledge of the Tutor.

[@hec3676]

Does someone knows how excel computed the adjusted R^2 when using this regression analysis? I actually tried using the formula, but it gives a different value. Thanks

[@leswrld2778]

OMG THABK U SO MUCH FOR THIS 😭

[@innocentinnocent5735]

Thank you so much sir Prof Tobin ......More Blessings!

[@نجوى-ج6ف]

❤️🙏

[@gopalakrishnanmanikandan6520]

Very clear explanations on analysis results, and interpretations. One of the most useful and simple video. Thanks!

[@magicmango69]

gracias! 🐊

[@firstnameylastnameo4848]

Thanks for your video. I need to know the mathematical formulas Excel uses in linear regression (intercept, coefficients, etc.)

[@UkrainianLiterature]

Thank you so much for making real life example

[@HARDYBOY290988]

Please Tell how to calculate manually the standard error of the coefficients

[@ankajsharma3699]

Very helpful in understanding the regression analysis using excel. Thank you very much Mr Tobin.

[@shirishdineshtiwari1935]

very very helpful video, thank you very much!

[@STING-AH]

Years later this has saved me on my final thank you!

[@iucristi13]

Thanks ! This helped me a lot ! Cheers !

[@UkrainianLiterature]

If you could explain each result in the regression tab, that would be super helpful.

[@mariyashevchuk]

god bless you

[@tahanialhumaid5651]

Short and informative! Thanks a lot

[@c-notethelastgreatest4298]

I cannot find out how to do these step on iphone

[@brittany_nichelle]

Wait, this made it so easy to understand. Thank you so much!

[@rinadhmohamed2041]

Thank you Sir

[@freshtowels3917]

Good stuff mate

[@2339091q]

is the interpretation of R square proper?

[@mohammedmojahidhossainchow5662]

Great!!! Good and lucid explanation of regression analysis within 5 minutes

[@zakarymartens4973]

Sounds like and Bernard from the office

[@alisig8141]

he sounds like jimmy kimmel to me ahhahah

[@hprovy1196]

Thank you

[@mixi1370]

Why excel keep telling me the data contains non-numerical value?

[@misswinterstar]

You need to tick labels

[@escobar8617]

Me as well

[@chetnawoyski8841]

When selecting the Values, Do Not Select Column “A”. For the 1st range of values Only Select the data in Column “B”, For the 2nd range of values Only Select the data in Columns “C, D and E”.

[@delesewilson429]

Amazing job! You did more for me than what my teacher has been doing in the 11weeks of this semester.

[@jeffreyotingo4513]

We must be in the same university because these are my exact sentiments lol

[@Minjarez96]

Here cheating on my final