When the dialog box in Figure 1 appears, enter A3:D38 in the Input Range, unclick Column headings included with data, select Std by Columns as the Input Format, select ANOVA as the Analysis Type and click on the OK button. To do this, enter Ctrl-m and select the Three Factor ANOVA option from the menu that appears. This is similar to the stacked format used for Two Factor Anova.Įxample 2: Perform an analysis of variance for the data in range A3:D38 of Figure 3.įigure 3 – Three-Factor ANOVA on data in stacked format In addition to the input format shown above, the data analysis tool also supports standard format by columns. Observation: As mentioned previously, two input formats are supported by the data analysis tool. The right side of the figure contains the Anova table, which is similar to the analysis shown in Figure 3 of ANOVA with more than Two Factors. Cell T30 contains the total sample size, cell U30 contains the total mean and cell V30 contains SS T. The left side of the figure contains a table of descriptive statistics. The output is shown in Figure 2.įigure 2 – Three-Factor ANOVA data analysis The dialog box in Figure 1 will now appear.įigure 1 – Dialog box for Three Factor AnovaĮnter A4:O11 in the Input Range, click on Column headings included with data, select Std by Rows as the Input Format and select Anova as the Analysis Type and click on the OK button.
To use the tool for the analysis of Example 1, click on cell Q1 (where the output will start), enter Ctrl-m and select the Three Factor ANOVA option from the menu that appears. We will look at the other format, standard format by columns shortly.Įxample 1: Repeat the analysis conducted in Example 1 of ANOVA with more than Two Factors using the Real Statistics’s Three Factor ANOVA data analysis tool. The first format, which we will call standard format by rows is like the input in Example 1 of ANOVA with more than Two Factors. Two types of input formats are supported. Real Statistics Data Analysis Tool: The Real Statistics Resource Pack provides the Three Factor ANOVA data analysis tool.
We show how to conduct Three Factor ANOVA using capabilities found in the Real Statistics Resource Pack.