Statistics 101: ANCOVA in Excel, What's Going On?

In this Statistics 101 video, we take a look at some of the fundamental concepts of ANCOVA using Microsoft Excel. How does the covariate relate to the overall model and group differences? How can we isolate the effect of a factor and its levels? We look at that and more in this simple video. Enjoy!
My playlist table of contents, Video Companion Guide PDF documents, and file downloads can be found on my website: www.bcfoltz.com
For more info on XLSTAT: www.xlstat.com/en/
Happy learning!
#statistics #machinelearning #datascience

[@npt0112]

You are the greatest person in the world.

[@alifarahani4398]

The first time I really understood what is ANCOVA, Thanks for the great explanation!

[@doddpower]

Thanks. Really hoping to see more videos!

[@namratapandey4014]

Thank you for this video. You are GREAT!!

[@ankursharma7812]

Big fan have gone through all the video playlist 1 to 20 thank you very much

[@mrs.witchersenglishonline7783]

Thank you, Brandon. This was very helpful!

[@danielsossa1]

Thank you very much, these videos are great!

[@jieunboy]

great explanation thanks!

[@ltbhupinder1811]

Thanks you Sir
hope i will also make video like you in the field of financial accounting
you are a great inspiration for me
thanks very much

[@HuadongWu]

excellent! the best I see

[@samsung6980]

I think I have a pretty good understanding of the method. Thanks :)

[@raymondgeorge6634]

Thank you sir.

[@perrysellers9198]

Great videos Brandon, One thing I didn't notice in this particular video is how exactly the mean shifts occur using Ancova. Your breakdown shows the reduction in SSE or that contribution described by the covariate but not the second purpose of mean adjustment. Thanks for the great instruction!

[@ianstats97]

Yes, this is a great comment. I think a follow-up video showing how to get the 2.9 value to adjust the ancova

[@lou3489]

Thank you for the presentation... it helps people like me who are not fond of numbers.
Can you show how it is done using Jamovi?
Thanks!

[@liranzaidman1610]

Great video!
Question please - If we would get a

[@alexandrahovsepian7415]

Thank you Brandon αγορι μου!

[@QZainyQ]

Beautiful

[@BrandonFoltz]

Thank you! Cheers!

[@kendesmarais9018]

Do I need equal sample size for each group?

[@dominicj7977]

How is interaction between year and score taken to account

[@matthewgoldenberg5285]

How do you handle multiple covariates?

[@jogiprasadyadav7968]

Good afternoon sir, actually I took 3 independent variables and 4 dependent variables how can do analysis, explain me step by step like mean, standard deviation like that step by step

[@edgarl.calvadoresii9479]

why is year 1 and 2 coded as 1?