Dose the one-way ANOVA in Excel correct for unequal sample sizes?

%3CLINGO-SUB%20id%3D%22lingo-sub-1538656%22%20slang%3D%22en-US%22%3EDose%20the%20one-way%20ANOVA%20in%20Excel%20correct%20for%20unequal%20sample%20sizes%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1538656%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3EI%20have%20three%20groups%26nbsp%3Bwith%20unequal%20sample%20sizes%3B%20n%3D5%2C%20n%3D4%20and%20n%3D10.%20I%20would%20like%20to%20perform%20a%20one-way%20ANOVA%20using%20the%20Analysis%20ToolPak%20in%20Excel.%20But%20I%20am%20worried%20about%20the%20different%20sample%20sizes.%20Excel%20will%20run%20the%20analysis%20without%20any%20error%20messages%2C%20so%20I%20wonder%20if%20the%20function%20automatically%20corrects%20for%20the%20different%20group%20sizes.%3C%2FP%3E%3CP%3EDoes%20anyone%20know%20if%20the%20one-way%20ANOVA%20in%20Excel%20corrects%20for%20unequal%20sample%20sizes%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20for%20your%20help!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBest%20regards%3C%2FP%3E%3CP%3ECharlotte%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1538656%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

Hi,

I have three groups with unequal sample sizes; n=5, n=4 and n=10. I would like to perform a one-way ANOVA using the Analysis ToolPak in Excel. But I am worried about the different sample sizes. Excel will run the analysis without any error messages, so I wonder if the function automatically corrects for the different group sizes.

Does anyone know if the one-way ANOVA in Excel corrects for unequal sample sizes?

 

Thank you for your help!

 

Best regards

Charlotte

0 Replies