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
