Excel ANOVA with Sum of Squares Calculations

Поделиться
HTML-код
  • Опубликовано: 22 авг 2024

Комментарии • 36

  • @praveenkumawat5183
    @praveenkumawat5183 5 лет назад +5

    This is GREAT! No kidding....after watching so many ambiguous, confusing videos finally i have reached this perfect video which has all i was looking for! Keep up the good work man..you rock!!

  • @Mhziko
    @Mhziko 3 года назад

    Having a non-statistical bg, this video along with the ANOVA: Khan Academy series gave me a pleasure of joy after an exhausting week of struggle to understand regression analysis. Just a humble thank is not enough for this altruistic gentleman. Keep up the good work!

  • @reelelinn8378
    @reelelinn8378 10 лет назад +1

    love love love this video! statistics is not the easiest thing for me to follow nor is it easy to figure out how to calculate anything. thank you for the step-by-step process. it took a little of the "scary" out of ANOVA calculations and tables for excel.

  • @THEKEKAMUSIC
    @THEKEKAMUSIC 7 лет назад

    Thank you so much, you don't know how much I understand with your explanation!

  • @HerdingDogRescuer
    @HerdingDogRescuer 8 лет назад

    So very very helpful!! Thanks for posting this. I was able to work through an extremely vaguely worded example in my text book and this video answered so many questions!

  • @hoursivlang5425
    @hoursivlang5425 9 месяцев назад

    Thank you so much. This video is really helpful and useful for my statistic course.

  • @shazaibmughal777
    @shazaibmughal777 3 месяца назад

    very well explained thank u so much

  • @wrightw2093
    @wrightw2093 11 лет назад

    Dude this was absolutely awesome! I had no idea how to do this yet it's for homework. You made it so easy it's like I can teach this now. I'm subscribing to your channel RIGHT NOW! Thank you, thank you, thank you!

  • @ceeri6335
    @ceeri6335 Год назад

    Very helpful

  • @hellokitty121997
    @hellokitty121997 4 года назад +2

    very well explained, thank you

  • @DrStevenHobbs
    @DrStevenHobbs 10 месяцев назад

    Thanks so much!

  • @PraiseTheLord1611
    @PraiseTheLord1611 8 лет назад +1

    Very helpful Video! Thanks a ton for sharing!

  • @abiramiponnusamy1940
    @abiramiponnusamy1940 3 года назад

    literally saved me so much time!!

  • @eli22nov69
    @eli22nov69 7 лет назад

    omg my head was blown up, that was a lot of help. I also need to know how to do this question :
    I figured out ANOVA part, but not the t stat
    1. Part of an Excel output relating X (independent variable) and Y (dependent variable) is shown below. Fill in all the blanks marked with "?".
    Summary Output
    Regression Statistics
    Multiple R 0.1347
    R Square ?
    Adjusted R Square ?
    Standard Error 3.3838
    Observations ?
    2.
    ANOVA
    df SS MS F Significance F
    Regression ? 2.7500 ? ? 0.632
    Residual ? ? 11.45
    Total 14 ?
    3.
    Coefficients Standard Error t Stat P-value
    Intercept 8.6 2.2197 ? 0.0019
    x 0.25 0.5101 ? 0.632
    please help :D

  • @taylorprice400
    @taylorprice400 2 года назад

    This video helped me so much, thank you :)

  • @leandrodiasteixeira8392
    @leandrodiasteixeira8392 8 лет назад

    Hi friend. Wonderful video. Congrats.

    • @rdjalayer
      @rdjalayer  8 лет назад

      Thank you for your thoughtful comment.

  • @Muuip
    @Muuip 4 года назад

    Excellent! Much appreciated!

  • @bjornkjerfve1105
    @bjornkjerfve1105 3 года назад

    Very well done, indeed!

  • @eratohome
    @eratohome 7 лет назад

    Thanks a lot. It's really useful and helpful for my studying!

  • @BuiVanDung1
    @BuiVanDung1 3 года назад

    I love this video, Can you please share Correlation with same things?

  • @melekali5811
    @melekali5811 4 года назад

    Thanks so much for your sharing, its valuable ^_^

  • @gracezaras3623
    @gracezaras3623 9 лет назад +1

    Hello, this video is very helpful. I have a question though, can you enter percentages in the "groups or factors" chart? Or do the numbers in this chart have to be whole numbers? Thank you so much!

  • @user-wo5fi3qy7c
    @user-wo5fi3qy7c 7 лет назад

    good job

  • @HiLife4Ewa
    @HiLife4Ewa 8 лет назад

    Thank you so much! This helps a lot!

  • @CAPT1ANGU1TAR
    @CAPT1ANGU1TAR 9 лет назад +1

    Thank you! helped a lot

  • @dhakab48
    @dhakab48 8 лет назад

    THANKS A LOT . its very very useful

  • @JR-ly6bx
    @JR-ly6bx 2 года назад

    so F Critical is "how many standard deviations away from zero is the start of rejection region"?

  • @syntexerrorku429
    @syntexerrorku429 3 года назад

    Problem in p value and f crit
    How to find it normally not excel.

  • @fuego786
    @fuego786 4 года назад

    DO YOU HAVE THE SUM OF SQUARES BLOCK THERE?

  • @thatkidval
    @thatkidval 7 лет назад

    HOW WOULD YOU CALCULATE THIS IN SPSS?

  • @stephanierojas6633
    @stephanierojas6633 8 лет назад

    I followed the exact same steps with my data, my original points are a lot smaller e.g. 10.8 or even 7.0, and i ended up with a extremely small p value 2.89388E-21... Is that possible?

    • @rdjalayer
      @rdjalayer  8 лет назад

      +stephanie rojas It is possible to get a very very small p-value. This means that there is a LOT of evidence against the Null Hypothesis.

    • @stephanierojas6633
      @stephanierojas6633 8 лет назад

      +Jalayer Academy Perfect, i'll just write that in my conclusion. Thank You so much for replying!

  • @jabezgenorga4413
    @jabezgenorga4413 7 лет назад

    If there are 4 groups, can I still use a One-way Anova? Thanks..

  • @anshumansarthakmeher3811
    @anshumansarthakmeher3811 3 года назад

    where's the link