Data Analysis with Microsoft Excel: Updated for Office 2007

This page intentionally left blank ...

589 Index A About StatPlus command, 33 Absolute reference, 50 Acceptance region, 234–235 ACF. See Autocorrelation function Activ ...

Bubble chart, 84 Bubble plots, creating, 110–117 C Calculated criteria, 56 Calculated values, using, 62–63 Categorical variables ...

Index 591 Database query, 68 Database Query Wizard, 68–71 Databases, importing data from, 68–75 Data format buttons, 42 Data poi ...

592 Index Histograms breaking into categories, 143–146 commands, 531–532, 558–559, 561 comparing, 144 creating, 138–141, 558–559 ...

Index 593 Out of control process, 491 Output options, 522–523 Output sheet, 33 Overparametrized model, 406 P Page Layout tab, 8 ...

594 Index Regression, multiple, 376 coeffi cients and prediction equation, 361–362 example using, 371–385 F distribution, 353–35 ...

Index 595 scatter plots and, 118 seasonality and, 471 setup options, 32–33 Sign test and, 253–255 table statistics, 297–299 t te ...

596 Index Vertical scroll bar, 7 View tab, 9 W Whiskers, 169 Wilcoxon Signed Rank test, 250–253 command, 571–572 Windows startin ...

Quick Reference Guide for Berk & Carey’s Data Analysis with Microsoft® Excel: Updated for Office 2007®. Objective Steps Refe ...

Objective Steps Refer to Histogram, create Click the Data Analysis button from the Analysis group on the Data tab and then click ...

Patterned data, create Click StatPlus > Create Data > Patterned Data. Chapter 7 Specify the data pattern. Requires StatPlu ...

Quick Reference Guide for Berk & Carey’s Data Analysis with Microsoft® Excel: Updated for Office 2007®. Objective Steps Refe ...