Excel ANOVA with Sum of Squares Calculations

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

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

  • @praveenkumawat5183
    @praveenkumawat5183 5 ปีที่แล้ว +6

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

  • @G3nM
    @G3nM 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!

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

    Finding this video is like finding treasure. Thank you so much sir

  • @reelelinn8378
    @reelelinn8378 11 ปีที่แล้ว +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.

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

  • @THEKEKAMUSIC
    @THEKEKAMUSIC 7 ปีที่แล้ว

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

  • @HerdingDogRescuer
    @HerdingDogRescuer 9 ปีที่แล้ว

    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 ปีที่แล้ว

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

  • @leandrodiasteixeira8392
    @leandrodiasteixeira8392 8 ปีที่แล้ว

    Hi friend. Wonderful video. Congrats.

    • @rdjalayer
      @rdjalayer  8 ปีที่แล้ว

      Thank you for your thoughtful comment.

  • @PraiseTheLord1611
    @PraiseTheLord1611 9 ปีที่แล้ว +1

    Very helpful Video! Thanks a ton for sharing!

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

    This video helped me so much, thank you :)

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

    very well explained, thank you

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

    literally saved me so much time!!

  • @JR-ly6bx
    @JR-ly6bx 2 ปีที่แล้ว

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

  • @shazaibmughal777
    @shazaibmughal777 9 หลายเดือนก่อน

    very well explained thank u so much

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

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

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

  • @eratohome
    @eratohome 8 ปีที่แล้ว

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

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

    Excellent! Much appreciated!

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

    Very well done, indeed!

  • @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

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

    Very helpful

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

    Thanks so much!

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

    DO YOU HAVE THE SUM OF SQUARES BLOCK THERE?

  • @HiLife4Ewa
    @HiLife4Ewa 8 ปีที่แล้ว

    Thank you so much! This helps a lot!

  • @H.j.f.g.h.j
    @H.j.f.g.h.j 4 ปีที่แล้ว

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

  • @泽洋-y6o
    @泽洋-y6o 8 ปีที่แล้ว

    good job

  • @Dhaka_Raj
    @Dhaka_Raj 8 ปีที่แล้ว

    THANKS A LOT . its very very useful

  • @CAPT1ANGU1TAR
    @CAPT1ANGU1TAR 10 ปีที่แล้ว +1

    Thank you! helped a lot

  • @thatkidval
    @thatkidval 7 ปีที่แล้ว

    HOW WOULD YOU CALCULATE THIS IN SPSS?

  • @stephanierojas6633
    @stephanierojas6633 9 ปีที่แล้ว

    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  9 ปีที่แล้ว

      +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 9 ปีที่แล้ว

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

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

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

  • @jabezgenorga4413
    @jabezgenorga4413 7 ปีที่แล้ว

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

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

    where's the link