Forum Discussion

ColinSaldanha's avatar
ColinSaldanha
Copper Contributor
Feb 08, 2023

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.

Excel on Mac

3 Replies

  • cool2021's avatar
    cool2021
    Iron Contributor
    Apr 18, 2023
    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.
      • cool2021's avatar
        cool2021
        Iron Contributor
        Apr 19, 2023

        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

Resources