

See Analysis of variance whiskers, 169 ANOVA two-way and, 419–422 Area chart, 83 working with, 165–174 checking availability of, 522 Arguments, 47 correlation matrix and, 343 Attribute charts, 493 descriptive statistics and, 154 Autocorrelation function (ACF) effects model and, 406 applications of, 441–443, 444–445 computing, 441–445 589īubble chart, 84 working with X 2 distribution, S-, 566 Bubble plots, creating, 110–117 293–295 subgroups, 493 upper and lower control C Coefficient(s) defined, 314 limits, 490 Calculated criteria, 56 of determination, 322 variable, 493 Calculated values, using, 62–63 multiple regression and, 359–360 x, 493–502, 565 Categorical variables.

See also Histograms 403–404 ANOVA, two-factor with cells in, 411 displaying categorical data in, comparing means, 402–404 replication command, 524 283–285 computing, 397–399 ANOVA, two-factor without effects model, 406, 408–409, 411 Bartlett’s test, 258 examples of, 393–401, 413 replication command, 525 Bernoulli distribution, 218 Excel used to perform two-way, correlation command, 526 Between-groups sum of squares, covariance command, 527 419–422 descriptive statistics command, 400 graphing data to verify, 395–397, Big Ten workbook example, 86 527–529 Bin(s) 414–417 exponential smoothing command, indicator variables, 406–407 counting with, 134–135 interaction plot, 417–419 457, 529–530 in frequency tables, 134–136 interpreting, 326–327, 399–401, F test command, 530–531 values, defining, 136–138 histogram command, 531–532 Binomial distribution, 218 422–424 moving average command, Bivariate density function, 192 means model, 393, 406, 409 Bivariate Normal command, 552 one-way, 393, 406–409 532–533 Bonferroni overparametrized model, 406 output options, 522–523 correction factor, 403–404 regression analysis and, 325, random number generation p values with, 342–343 Boxplots 326–327, 406–409 command, 533–534 command, 557–558 replicates, 410 rank and percentile command, comparing means with, 405–406 single-factor, 523 creating, 171–174 two-factor with replication, 524 535 defined, 166 two-factor without replication, 525 regression command, 535–537 fences, 167–168 two-way, 410–413 sampling command, 537–538 interquartile, 167 Analysis ToolPak/Data Analysis t test command, 539–542 outliers, 168 z test command, 542–543 seasonality and use of, 467–468 ToolPak, 24 ANOVA.

See Mean tab, 9 Axes, editing, 97–100 unloading, 30 357 Axis titles Additive seasonality, 464 t test and, 248 working with, 94–97 Advanced Filter, 56, 59–61 unloading, 30 Alternative hypothesis, 233 Analysis ToolPak add-ins B Analysis of variance (ANOVA) ANOVA, single-factor command, Bonferroni correction factor, Balanced data, 419 523 Bar charts, 84. See also Analysis percentiles and, 154 Autofill, entering data with, 37–39 random normal data and, 199 AutoFilter, 56–59 ToolPak add-ins regression analysis and, 323–325, Average. See Autocorrelation function loading, 28–29 role of, 440–441 Active cell, 6 moving average command, 448 seasonality and use of, 470–471 Add-ins, 24–28. Index A exponential smoothing, one- constant variance and, 441 parameter command, 457 formulas, 440–441 About StatPlus command, 33 patterns of, 443–444 Absolute reference, 50 frequency tables and, 134 plot command, 575 Acceptance region, 234–235 histograms and, 138 random walk model, 444 ACF.
