Forum Discussion

Copper Contributor

May 23, 2020

ANOVA with different samples sizes

Hey! I have tried making an ANOVA (2 way) with different sample sizes, but Excel seems to not help me:(. This is what I tried: Data analysis -> ANOVA: 2 factor with replication -> I selected my enti...

Iron Contributor

May 24, 2020

Hi JoelAaron

There is a write up here for the analysis toolpack including ANOVA

https://support.office.com/en-us/article/use-the-analysis-toolpak-to-perform-complex-data-analysis-6c67ccf0-f4a9-487c-8dec-bdb5a2cefab6?NS=EXCEL&Version=19&SysLcid=1033&UiLcid=1033&AppVer=ZXL190&HelpId=xladdin.chm1782&ui=en-US&rs=en-US&ad=US

I noticed you have some cells without data and you don't have the same unmber of data for each group [A,B,C,D]