A worksheet called ANOVA is always added to the workbook. The top part of this sheet contains the ANOVA table for the various sources of variation as well as the ANOVA table for the model and a few statistics.
Additional worksheets will be added depending on the options selected. The ANOVA output options are listed below with an explanation of what worksheets are added to the workbook.
- ANOVA worksheet: contains the ANOVA table and other statistics.
- Variability Chart: add a chart sheet named “Variability Chart” containing the variability chart.
- Residuals Analysis: adds a worksheet named “Residuals” that contains the residual analysis
- Residual Plots: Contains the various chart options for the residuals.
- Xbar-s Control Chart: adds a worksheet named “Xbar-s ” containing the Xbar and the s control charts.
- Xbar-R Control Chart: adds a worksheet named “Xbar-R ” containing the Xbar and the R control charts.
- Compare Means and Variances (Fixed Factors Only): this option adds additional information to the ANOVA worksheet for comparing the treatment means (Fisher’s LSD method, Bonferroni’s method and Tukey’s method) and for testing the equality of treatment variances (Bartlett’s test and Levene’s Modified method); chart sheets may also be added if the option to chart the comparison of treatment means was selected
- Display Components of Variance and Expected Mean Squares: this option adds additional information to the ANOVA worksheet for the components of variance and the expected mean squares; a chart sheet is also added that contains the components of variance graph.
- Display F Calculation Information: this option adds additional information to the ANOVA worksheet for how the F value was determined.
- Control Chart Rollup: this option adds a worksheet called Rollup Charts to the workbook containing the control charts for the rollup of factors.