Forum Discussion
One between one within ANOVA
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.
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!!
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-6c67ccf0-f4a9-487c-8dec-bdb5a2cefab6
