This is for Two-factor with Replication: https://www.drdawnwright.com/wp-content/uploads/2018/02/ANOVA-Excel-Calculator-1-V1.00.xlsx
This is for Two-factor with Replication: https://www.drdawnwright.com/wp-content/uploads/2018/02/ANOVA-Excel-Calculator-1-V1.00.xlsx
2 thoughts on “ANOVA Excel Calculator”
Hi, I downloaded the excel sheet but I am not able to enter data, as the excel is protected and requires a password. Wondering if you can provide a password for me to be able to import my specific data, or how do I go about this? Thank you!
Katie,
Sorry, I am just finding this comment. The best way to get an unprotected copy of a worksheet is to just copy the entire worksheet and paste it into a new empty worksheet. The copy will be unprotected. I protect my worksheets to make it difficult to overwrite or inadvertently change the underlying structure. If you make a copy and work on the copy of the worksheets, you will always have the original to fall back on if you make a mistake.