ANOVA with different samples sizes

%3CLINGO-SUB%20id%3D%22lingo-sub-1413624%22%20slang%3D%22es-ES%22%3EAnova%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1413624%22%20slang%3D%22es-ES%22%3E%3CP%3EHey!%20I%20have%20tried%20making%20an%20ANOVA%20(2%20way)%20with%20different%20sample%20sizes%2C%20but%20Excel%20seems%20to%20not%20help%20me%3A(.%20%3CBR%20%2F%3E%20This%20is%20what%20I%20tried%3A%20Data%20analysis%20-%26gt%3B%20ANOVA%3A%202%20factor%20with%20replication%20-%26gt%3B%20I%20selected%20my%20entire%20data%20set%20(attached).%3C%2FP%3E%3CP%3EI'm%20learning%20this%20functions%2C%20the're%20new%20to%20me.%20I%20came%20here%20because%20my%20teacher%20did%20not%20help%20me%2C%20so%20I%20hope%20someone%20can%20help%20me%2C%20I%20would%20be%20very%20grateful!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CFONT%20color%3D%22%23808080%22%3EJoel%3C%2FFONT%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1413624%22%20slang%3D%22es-ES%22%3E%3CLINGO-LABEL%3EBI%20%26amp%3B%20Data%20Analysis%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ETraining%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1414278%22%20slang%3D%22en-US%22%3ERe%3A%20ANOVA%20with%20different%20samples%20sizes%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1414278%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F677745%22%20target%3D%22_blank%22%3E%40JoelAaron%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThere%20is%20a%20write%20up%20here%20for%20the%20analysis%20toolpack%20including%20ANOVA%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fsupport.office.com%2Fen-us%2Farticle%2Fuse-the-analysis-toolpak-to-perform-complex-data-analysis-6c67ccf0-f4a9-487c-8dec-bdb5a2cefab6%3FNS%3DEXCEL%26amp%3BVersion%3D19%26amp%3BSysLcid%3D1033%26amp%3BUiLcid%3D1033%26amp%3BAppVer%3DZXL190%26amp%3BHelpId%3Dxladdin.chm1782%26amp%3Bui%3Den-US%26amp%3Brs%3Den-US%26amp%3Bad%3DUS%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsupport.office.com%2Fen-us%2Farticle%2Fuse-the-analysis-toolpak-to-perform-complex-data-analysis-6c67ccf0-f4a9-487c-8dec-bdb5a2cefab6%3FNS%3DEXCEL%26amp%3BVersion%3D19%26amp%3BSysLcid%3D1033%26amp%3BUiLcid%3D1033%26amp%3BAppVer%3DZXL190%26amp%3BHelpId%3Dxladdin.chm1782%26amp%3Bui%3Den-US%26amp%3Brs%3Den-US%26amp%3Bad%3DUS%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20noticed%20you%20have%20some%20cells%20without%20data%20and%20you%20don't%20have%20the%20same%20unmber%20of%20data%20for%20each%20group%20%5BA%2CB%2CC%2CD%5D%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

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 entire data set (attached).

I'm learning this functions, the're new to me. I came here because my teacher did not help me, so I hope someone can help me, I would be very grateful!

 

Joel

1 Reply

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-6...

 

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]