One between one within ANOVA

[ColinSaldanha]

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.

[#2]

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.

[#3]

@cool2021Thank you very much!!

[#4]

@ColinSaldanha here is some more information about ANOVA in Excel. https://support.microsoft.com/en-us/office/use-the-analysis-toolpak-to-perform-complex-data-analysis...