One between one within ANOVA

Copper Contributor

Hello. I am new to Excel (Mac) and would like to use it to perform a 2-way ANOVA on a data set with one between and one within variable. Any help would be much appreciated.

3 Replies
Hi Colin. You need to organize your data so that your columns are the variables and then within each column you have your measure (eg # of customers) data points on which you are performing the F-Test and ANOVA using the Excel Data Analysis Toolpak. It is an Excel Add-In.

@cool2021Thank you very much!!