Excel Regression Analysis through the Toolpak

แชร์
ฝัง
  • เผยแพร่เมื่อ 30 ม.ค. 2025

ความคิดเห็น • 92

  • @marysevele1993
    @marysevele1993 5 ปีที่แล้ว +107

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

  • @blackbeltchiken
    @blackbeltchiken 5 ปีที่แล้ว +20

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

  • @AlizeMerchant
    @AlizeMerchant 4 ปีที่แล้ว +1

    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

  • @yalestultz1935
    @yalestultz1935 2 ปีที่แล้ว +3

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

  • @venuszavareh4522
    @venuszavareh4522 3 ปีที่แล้ว +7

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

  • @vanessarizo7228
    @vanessarizo7228 4 ปีที่แล้ว +22

    THIS VIDEO LOWERED MY STRESS LEVEL

  • @prasadkumanayake3785
    @prasadkumanayake3785 2 ปีที่แล้ว

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

  • @MI11E5_HI-LF
    @MI11E5_HI-LF 2 ปีที่แล้ว

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

  • @hayleyamethyst7233
    @hayleyamethyst7233 2 ปีที่แล้ว

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

  • @engrumarkhan
    @engrumarkhan 2 หลายเดือนก่อน

    Most helpful one, without wasting time, rite to the point. Thanks

  • @gopalakrishnanmanikandan6520
    @gopalakrishnanmanikandan6520 2 ปีที่แล้ว

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

  • @zfazzershroudvietcynide64e58
    @zfazzershroudvietcynide64e58 2 ปีที่แล้ว

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

  • @nep4912
    @nep4912 4 ปีที่แล้ว +7

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

  • @ThePlayerOfGames
    @ThePlayerOfGames 4 ปีที่แล้ว +1

    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

  • @ankajsharma3699
    @ankajsharma3699 4 ปีที่แล้ว

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

  • @chi3750
    @chi3750 2 ปีที่แล้ว

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

  • @TheReal_Antrey
    @TheReal_Antrey 2 ปีที่แล้ว +1

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

  • @NotWithinLimits
    @NotWithinLimits 2 ปีที่แล้ว +2

    This is awesome! I appreciate you very much!

  • @delesewilson429
    @delesewilson429 4 ปีที่แล้ว +1

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

    • @jeffreyotingo4513
      @jeffreyotingo4513 4 ปีที่แล้ว +1

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

  • @brittany_nichelle
    @brittany_nichelle 4 ปีที่แล้ว

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

  • @chenli9343
    @chenli9343 4 ปีที่แล้ว +1

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

  • @couga861900
    @couga861900 5 ปีที่แล้ว +1

    Very good video. It is very helpful.

  • @ekrajchaudhary7036
    @ekrajchaudhary7036 2 ปีที่แล้ว

    Good job, keep it up

  • @innocentinnocent5735
    @innocentinnocent5735 3 ปีที่แล้ว

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

  • @mohammedmojahidhossainchow5662
    @mohammedmojahidhossainchow5662 4 ปีที่แล้ว +1

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

  • @tenzint2268
    @tenzint2268 ปีที่แล้ว

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

  • @ShapinguptheBuiltForm-ArMohinM
    @ShapinguptheBuiltForm-ArMohinM 2 ปีที่แล้ว

    Thanks for sharing. Very helpful

  • @hariralatif4600
    @hariralatif4600 3 ปีที่แล้ว +2

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

  • @starbusttweety
    @starbusttweety ปีที่แล้ว

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

  • @nickcrawshaw9348
    @nickcrawshaw9348 3 ปีที่แล้ว +1

    Holy shit, cannot thank you enough!

  • @BesideTheVoid
    @BesideTheVoid 4 ปีที่แล้ว +1

    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?

  • @senpaitama8778
    @senpaitama8778 4 ปีที่แล้ว

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

  • @kavinp6423
    @kavinp6423 3 ปีที่แล้ว +1

    I can't thank you enough

  • @iucristi13
    @iucristi13 3 ปีที่แล้ว

    Thanks ! This helped me a lot ! Cheers !

  • @sangeethasockalingam6226
    @sangeethasockalingam6226 3 ปีที่แล้ว

    Thanks a lot sir. Very useful video.

  • @Joeman_Joeman
    @Joeman_Joeman 2 ปีที่แล้ว

    thank you, this videos is saving my ass right now

  • @UkrainianLiterature
    @UkrainianLiterature 3 ปีที่แล้ว

    Thank you so much for making real life example

  • @frankisneiderfierroguarniz359
    @frankisneiderfierroguarniz359 6 ปีที่แล้ว +2

    it is an excellent video...

  • @japeriawilliams4470
    @japeriawilliams4470 3 ปีที่แล้ว

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

  • @charbelkaram4943
    @charbelkaram4943 2 ปีที่แล้ว

    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?

  • @baezledesma3439
    @baezledesma3439 3 ปีที่แล้ว

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

  • @tahanialhumaid5651
    @tahanialhumaid5651 3 ปีที่แล้ว

    Short and informative! Thanks a lot

  • @crackshack2
    @crackshack2 6 ปีที่แล้ว +1

    Good tutorial on Regression Analysis!

  • @chipapamukupa6005
    @chipapamukupa6005 3 ปีที่แล้ว

    Thanks a lot this really helped me 🤗

  • @MrMosoani
    @MrMosoani 4 ปีที่แล้ว +1

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

  • @peelenerikpeelen
    @peelenerikpeelen 5 ปีที่แล้ว +1

    Great Video!

  • @xXKishann10Xx
    @xXKishann10Xx 3 ปีที่แล้ว

    this was a very very useful video thanks a lot !

  • @rishikulshrestha3128
    @rishikulshrestha3128 2 ปีที่แล้ว

    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

  • @ehsanjamshidi3684
    @ehsanjamshidi3684 6 ปีที่แล้ว +1

    Thanks Tobin. It was helpful.

  • @habyarimanajean761
    @habyarimanajean761 5 ปีที่แล้ว +1

    Very easy to understand.

  • @DaniBibiana
    @DaniBibiana 5 ปีที่แล้ว +2

    You're amazing! Thank you SO MUCH!

  • @hongduong260
    @hongduong260 2 ปีที่แล้ว

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

  • @freshtowels3917
    @freshtowels3917 4 ปีที่แล้ว

    Good stuff mate

  • @D0land0_94
    @D0land0_94 3 ปีที่แล้ว

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

  • @firstnameylastnameo4848
    @firstnameylastnameo4848 4 ปีที่แล้ว

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

  • @kylecrane1837
    @kylecrane1837 4 ปีที่แล้ว

    Excellent tutorial!

  • @leswrld2778
    @leswrld2778 2 ปีที่แล้ว

    OMG THABK U SO MUCH FOR THIS 😭

  • @TheB1GChill
    @TheB1GChill 4 ปีที่แล้ว +9

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

  • @shirishdineshtiwari1935
    @shirishdineshtiwari1935 4 ปีที่แล้ว

    very very helpful video, thank you very much!

  • @khushinarang5146
    @khushinarang5146 2 ปีที่แล้ว

    Sir from where you have collected the data

  • @khan1a1khan
    @khan1a1khan 5 ปีที่แล้ว +1

    God bless you

  • @caseysantiago9067
    @caseysantiago9067 4 ปีที่แล้ว

    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?

  • @afifahhasnu6411
    @afifahhasnu6411 3 ปีที่แล้ว +1

    Why Data Analysis is not on my Excel? T_T

  • @stezzytato
    @stezzytato 5 ปีที่แล้ว

    How do you get the estimated regression model formula

  • @UkrainianLiterature
    @UkrainianLiterature 3 ปีที่แล้ว

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

  • @povilasalkevicius7300
    @povilasalkevicius7300 4 ปีที่แล้ว

    Thank you! Helped a lot

  • @2339091q
    @2339091q 6 ปีที่แล้ว

    is the interpretation of R square proper?

  • @hec3676
    @hec3676 4 ปีที่แล้ว

    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

  • @glipk
    @glipk 4 ปีที่แล้ว +1

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

  • @mariyashevchuk
    @mariyashevchuk 4 ปีที่แล้ว

    god bless you

  • @magicmango69
    @magicmango69 3 ปีที่แล้ว

    gracias! 🐊

  • @HARDYBOY290988
    @HARDYBOY290988 4 ปีที่แล้ว

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

  • @lwazikhanye3344
    @lwazikhanye3344 3 ปีที่แล้ว

    thank you , thank you, thank you

  • @gustavduplessis1024
    @gustavduplessis1024 2 ปีที่แล้ว

    Thank you!

  • @rinadhmohamed2041
    @rinadhmohamed2041 4 ปีที่แล้ว

    Thank you Sir

  • @fredsempire1676
    @fredsempire1676 3 ปีที่แล้ว

    So what's the solution to this

  • @anthonywashington2885
    @anthonywashington2885 ปีที่แล้ว

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

  • @c-notethelastgreatest4298
    @c-notethelastgreatest4298 4 ปีที่แล้ว

    I cannot find out how to do these step on iphone

  • @hprovy1196
    @hprovy1196 4 ปีที่แล้ว

    Thank you

  • @victormoreno803
    @victormoreno803 2 ปีที่แล้ว

    thank youuu

  • @globtrotter1976
    @globtrotter1976 4 ปีที่แล้ว

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

  • @نجوى-ج6ف
    @نجوى-ج6ف 2 ปีที่แล้ว

    ❤️🙏

  • @mixi1370
    @mixi1370 6 ปีที่แล้ว

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

    • @misswinterstar
      @misswinterstar 5 ปีที่แล้ว

      You need to tick labels

    • @TheMysticRager
      @TheMysticRager 5 ปีที่แล้ว

      Me as well

    • @chetnawoyski8841
      @chetnawoyski8841 4 ปีที่แล้ว

      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”.

  • @zakarymartens4973
    @zakarymartens4973 4 ปีที่แล้ว

    Sounds like and Bernard from the office

    • @alisig8141
      @alisig8141 4 ปีที่แล้ว

      he sounds like jimmy kimmel to me ahhahah

  • @Minjarez96
    @Minjarez96 3 ปีที่แล้ว

    Here cheating on my final