Data Analysis with Microsoft Excel: Updated for Office 2007

408 Statistical Methods Fitting the Effects Model With these columns of indicator variables, you can now fi t the effects model ...

Chapter 10 Analysis of Variance 409 The analysis of variance table produced by the regression (cells A10:F14) and shown in Figur ...

410 Statistical Methods Two-Way Analysis of Variance One-way analysis of variance compares several groups corresponding to a sin ...

Chapter 10 Analysis of Variance 411 for an appliance manufacturer. Assembly line and shift are the two factors; the assembly lin ...

412 Statistical Methods The cell means are plotted against the assembly line factor using separate lines for the shift factor. T ...

Chapter 10 Analysis of Variance 413 The assumptions for two-way ANOVA are essentially the same as those for one-way ANOVA. For o ...

414 Statistical Methods Graphing the Data to Verify Assumptions Before performing a two-way analysis of variance on the data, yo ...

Chapter 10 Analysis of Variance 415 Because of the number of charts, you must either reduce the zoom factor on your worksheet or ...

416 Statistical Methods 3 Click the Categories button, select Cola_Type from the range names list, and click OK. 4 Click the Out ...

Chapter 10 Analysis of Variance 417 there is much difference due to cola type (diet or regular)? Because the foam levels do not ...

418 Statistical Methods Next you can create a line chart based on the values in the PivotTable. To create a line chart of the ce ...

Chapter 10 Analysis of Variance 419 plot would seem to indicate that there is no interaction between cola brand and cola type. T ...

420 Statistical Methods To create a two-way table: 1 Return to the Cola Data worksheet. 2 Click Manipulate Columns from the Stat ...

Chapter 10 Analysis of Variance 421 You have to indicate the number of replicates in the two-way table for this command. 3 Type ...

422 Statistical Methods Interpreting the Analysis of Variance Table The Analysis of Variance table appears as in Figure 10-22, w ...

Chapter 10 Analysis of Variance 423 degrees of freedom for cola brand, DFI are the interaction degrees of freedom, and DFE are t ...

424 Statistical Methods Thus about 72% of the total variation in foam volume can be attributed to differences in cola brand, col ...

Chapter 10 Analysis of Variance 425 teaching method. The two factors are region (East, Midwest, South, or West) and teaching met ...

426 Statistical Methods on the basis of the city variable and then add trend lines to each of the four cities. Include the four ...

Chapter 10 Analysis of Variance 427 can you explain it? As a hint, con- sider that the college is in Vermont, which has a small ...