Excel ANOVA with Sum of Squares Calculations

[@praveenkumawat5183]

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

[@mishogaming22]

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

[@G3nM]

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]

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]

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

[@wrightw2093]

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!

[@HerdingDogRescuer]

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]

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

[@leandrodiasteixeira8392]

Hi friend. Wonderful video. Congrats.

[@rdjalayer]

Thank you for your thoughtful comment.

[@shazaibmughal777]

very well explained thank u so much

[@PraiseTheLord1611]

Very helpful Video! Thanks a ton for sharing!

[@hellokitty121997]

very well explained, thank you

[@taylorprice400]

This video helped me so much, thank you :)

[@JR-ly6bx]

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

[@abiramiponnusamy1940]

literally saved me so much time!!

[@eratohome]

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

[@gracezaras3623]

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!

[@fuego786]

DO YOU HAVE THE SUM OF SQUARES BLOCK THERE?

[@H.j.f.g.h.j]

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

[@BuiVanDung1]

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

[@bjornkjerfve1105]

Very well done, indeed!

[@Muuip]

Excellent! Much appreciated!

[@Dhaka_Raj]

THANKS A LOT . its very very useful

[@ceeri6335]

Very helpful

[@eli22nov69]

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

[@stephanierojas6633]

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]

+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]

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

[@thatkidval]

HOW WOULD YOU CALCULATE THIS IN SPSS?

[@HiLife4Ewa]

Thank you so much! This helps a lot!

[@syntexerrorku429]

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

[@泽洋-y6o]

good job

[@CAPT1ANGU1TAR]

Thank you! helped a lot

[@DrStevenHobbs]

Thanks so much!

[@jabezgenorga4413]

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

[@anshumansarthakmeher3811]

where's the link