Excel ANOVA with Sum of Squares Calculations

[praveenkumawat]

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

[reelelinn]

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.

[GnM]

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!

[THEKEKAMUSIC]

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

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

[hoursivlang]

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

[wrightw]

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!

[PraiseTheLord]

Very helpful Video! Thanks a ton for sharing!

[taylorprice]

This video helped me so much, thank you :)

[eratohome]

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

[BuiVanDung]

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

[elinov]

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

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

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

[JR-lybx]

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

[gracezaras]

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!

[fuego]

DO YOU HAVE THE SUM OF SQUARES BLOCK THERE?

[syntexerrorku]

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

[jabezgenorga]

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

[stephanierojas]

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?