Note: Supplemental materials are not guaranteed with Rental or Used book purchases.
Purchase Benefits
What is included with this book?
Getting Started with Excel | p. 1 |
Getting Started | p. 2 |
Special Files for This Book | p. 2 |
Installing the StatPlus Files | p. 2 |
Excel and Spreadsheets | p. 4 |
Launching Excel | p. 5 |
Viewing the Excel Window | p. 6 |
Running Excel Commands | p. 7 |
Excel Workbooks and Worksheets | p. 10 |
Opening a Workbook | p. 10 |
Scrolling through a Workbook | p. 11 |
Worksheet Cells | p. 14 |
Selecting a Cell | p. 14 |
Moving Cells | p. 16 |
Printing from Excel | p. 18 |
Previewing the Print Job | p. 18 |
Setting Up the Page | p. 19 |
Printing the Page | p. 21 |
Saving Your Work | p. 22 |
Excel Add-Ins | p. 24 |
Loading the StatPlus Add-In | p. 24 |
Loading the Data Analysis ToolPak | p. 28 |
Unloading an Add-In | p. 30 |
Features of StatPlus | p. 30 |
Using StatPlus Modules | p. 30 |
Hidden Data | p. 31 |
Linked Formulas | p. 32 |
Setup Options | p. 32 |
Exiting Excel | p. 34 |
Working with Data | p. 35 |
Data Entry | p. 36 |
Entering Data from the Keyboard | p. 36 |
Entering Data with Autofill | p. 37 |
Inserting New Data | p. 40 |
Data Formats | p. 41 |
Formulas and Functions | p. 45 |
Inserting a Simple Formula | p. 46 |
Inserting an Excel Function | p. 47 |
Cell References | p. 50 |
Range Names | p. 51 |
Sorting Data | p. 54 |
Querying Data | p. 55 |
Using the AutoFilter | p. 56 |
Using the Advanced Filter | p. 59 |
Using Calculated Values | p. 62 |
Importing Data from Text Files | p. 63 |
Importing Data from Databases | p. 68 |
Using Excel's Database Query Wizard | p. 68 |
Specifying Criteria and Sorting Data | p. 71 |
Exercises | p. 75 |
Working with Charts | p. 81 |
Introducing Excel Charts | p. 82 |
Introducing Scatter Plots | p. 86 |
Editing a Chart | p. 91 |
Resizing and Moving an Embedded Chart | p. 91 |
Moving a Chart to a Chart Sheet | p. 93 |
Working with Chart and Axis Titles | p. 94 |
Editing the Chart Axes | p. 97 |
Working with Gridlines and Legends | p. 100 |
Editing Plot Symbols | p. 102 |
Identifying Data Points | p. 105 |
Selecting a Data Row | p. 106 |
Labeling Data Points | p. 107 |
Formatting Labels | p. 109 |
Creating Bubble Plots | p. 110 |
Breaking a Scatter Plot into Categories | p. 117 |
Plotting Several Variables | p. 120 |
Exercises | p. 123 |
Describing Your Data | p. 128 |
Variables and Descriptive Statistics | p. 129 |
Frequency Tables | p. 131 |
Creating a Frequency Table | p. 132 |
Using Bins in a Frequency Table | p. 134 |
Defining Your Own Bin Values | p. 136 |
Working with Histograms | p. 138 |
Creating a Histogram | p. 138 |
Shapes of Distributions | p. 141 |
Breaking a Histogram into Categories | p. 143 |
Working with Stem and Leaf Plots | p. 146 |
Distribution Statistics | p. 151 |
Percentiles and Quartiles | p. 151 |
Measures of the Center: Means, Medians, and the Mode | p. 154 |
Measures of Variability | p. 159 |
Measures of Shape: Skewness and Kurtosis | p. 162 |
Outliers | p. 164 |
Working with Boxplots | p. 165 |
Concept Tutorials: Boxplots | p. 166 |
Exercises | p. 175 |
Probability Distributions | p. 182 |
Probability | p. 183 |
Probability Distributions | p. 184 |
Discrete Probability Distributions | p. 185 |
Continuous Probability Distributions | p. 186 |
Concept Tutorials: PDFs | p. 187 |
Random Variables and Random Samples | p. 189 |
Concept Tutorials: Random Samples | p. 190 |
The Normal Distribution | p. 193 |
Concept Tutorials: The Normal Distribution | p. 194 |
Excel Worksheet Functions | p. 196 |
Using Excel to Generate Random Normal Data | p. 197 |
Charting Random Normal Data | p. 199 |
The Normal Probability Plot | p. 201 |
Parameters and Estimators | p. 205 |
The Sampling Distribution | p. 206 |
Concept Tutorials: Sampling Distributions | p. 211 |
The Standard Error | p. 212 |
The Central Limit Theorem | p. 212 |
Concept Tutorials: The Central Limit Theorem | p. 213 |
Exercises | p. 218 |
Statistical Inference | p. 224 |
Confidence Intervals | p. 225 |
z Test Statistic and z Values | p. 225 |
Calculating the Confidence Interval with Excel | p. 228 |
Interpreting the Confidence Interval | p. 229 |
Concept Tutorials: The Confidence Interval | p. 229 |
Hypothesis Testing | p. 232 |
Types of Error | p. 233 |
An Example of Hypothesis Testing | p. 234 |
Acceptance and Rejection Regions | p. 234 |
p Values | p. 235 |
Concept Tutorials: Hypothesis Testing | p. 236 |
Additional Thoughts about Hypothesis Testing | p. 239 |
The t Distribution | p. 240 |
Concept Tutorials: The t Distribution | p. 241 |
Working with the t Statistic | p. 242 |
Constructing a t Confidence Interval | p. 243 |
The Robustness of t | p. 243 |
Applying the t Test to Paired Data | p. 244 |
Applying a Nonparametric Test to Paired Data | p. 250 |
The Wilcoxon Signed Rank Test | p. 250 |
The Sign Test | p. 253 |
The Two-Sample t Test | p. 255 |
Comparing the Pooled and Unpooled Test Statistics | p. 256 |
Working with the Two-Sample t Statistic | p. 256 |
Testing for Equality of Variance | p. 258 |
Applying the t Test to Two-Sample Data | p. 259 |
Applying a Nonparametric Test to Two-Sample Data | p. 265 |
Final Thoughts about Statistical Inference | p. 267 |
Exercises | p. 268 |
Tables | p. 275 |
PivotTables | p. 276 |
Removing Categories from a PivotTable | p. 280 |
Changing the Values Displayed by the PivotTable | p. 282 |
Displaying Categorical Data in a Bar Chart | p. 283 |
Displaying Categorical Data in a Pie Chart | p. 285 |
Two-Way Tables | p. 288 |
Computing Expected Counts | p. 291 |
The Pearson Chi-Square Statistic | p. 293 |
Concept Tutorials: The ¿^{2} Distribution | p. 293 |
Working with the ¿^{2} Distribution in Excel | p. 296 |
Breaking Down the Chi-Square Statistic | p. 297 |
Other Table Statistics | p. 297 |
Validity of the Chi-Square Test with Small Frequencies | p. 299 |
Tables with Ordinal Variables | p. 302 |
Testing for a Relationship between Two Ordinal Variables | p. 303 |
Custom Sort Order | p. 307 |
Exercises | p. 309 |
Regression and Correlation | p. 313 |
Simple Linear Regression | p. 314 |
The Regression Equation | p. 314 |
Fitting the Regression Line | p. 315 |
Regression Functions in Excel | p. 316 |
Exploring Regression | p. 317 |
Performing a Regression Analysis | p. 318 |
Plotting Regression Data | p. 320 |
Calculating Regression Statistics | p. 323 |
Interpreting Regression Statistics | p. 325 |
Interpreting the Analysis of Variance Table | p. 326 |
Parameter Estimates and Statistics | p. 327 |
Residuals and Predicted Values | p. 328 |
Checking the Regression Model | p. 329 |
Testing the Straight-Line Assumption | p. 329 |
Testing for Normal Distribution of the Residuals | p. 331 |
Testing for Constant Variance in the Residuals | p. 332 |
Testing for the Independence of Residuals | p. 332 |
Correlation | p. 335 |
Correlation and Slope | p. 336 |
Correlation and Causality | p. 336 |
Spearman's Rank Correlation Coefficient s | p. 337 |
Correlation Functions in Excel | p. 337 |
Creating a Correlation Matrix | p. 338 |
Correlation with a Two-Valued Variable | p. 342 |
Adjusting Multiple p Values with Bonferroni | p. 342 |
Creating a Scatter Plot Matrix | p. 343 |
Exercises | p. 345 |
Multiple Regression | p. 352 |
Regression Models with Multiple Parameters | p. 353 |
Concept Tutorials: The F Distribution | p. 353 |
Using Regression for Prediction | p. 355 |
Regression Example: Predicting Grades | p. 356 |
Interpreting the Regression Output | p. 358 |
Multiple Correlation | p. 359 |
Coefficients and the Prediction Equation | p. 361 |
t Tests for the Coefficients | p. 362 |
Testing Regression Assumptions | p. 363 |
Observed versus Predicted Values | p. 363 |
Plotting Residuals versus Predicted Values | p. 366 |
Plotting Residuals versus Predictor Variables | p. 368 |
Normal Errors and the Normal Plot | p. 370 |
Summary of Calc Analysis | p. 371 |
Regression Example: Sex Discrimination | p. 371 |
Regression on Male Faculty | p. 372 |
Using a SPLOM to See Relationships | p. 373 |
Correlation Matrix of Variables | p. 374 |
Multiple Regression | p. 376 |
Interpreting the Regression Output | p. 377 |
Residual Analysis of Discrimination Data | p. 377 |
Normal Plot of Residuals | p. 378 |
Are Female Faculty Underpaid? | p. 380 |
Drawing Conclusions | p. 385 |
Exercises | p. 386 |
Analysis of Variance | p. 392 |
One-Way Analysis of Variance | p. 393 |
Analysis of Variance Example: Comparing Hotel Prices | p. 393 |
Graphing the Data to Verify ANOVA Assumptions | p. 395 |
Computing the Analysis of Variance | p. 397 |
Interpreting the Analysis of Variance Table | p. 399 |
Comparing Means | p. 402 |
Using the Bonferroni Correction Factor | p. 403 |
When to Use Bonferroni | p. 404 |
Comparing Means with a Boxplot | p. 405 |
One-Way Analysis of Variance and Regression | p. 406 |
Indicator Variables | p. 406 |
Fitting the Effects Model | p. 408 |
Two-Way Analysis of Variance | p. 410 |
A Two-Factor Example | p. 410 |
Two-Way Analysis Example: Comparing Soft Drinks | p. 413 |
Graphing the Data to Verify Assumptions | p. 414 |
The Interaction Plot | p. 417 |
Using Excel to Perform a Two-Way Analysis of Variance | p. 419 |
Interpreting the Analysis of Variance Table | p. 422 |
Summary | p. 424 |
Exercises | p. 424 |
Time Series | p. 431 |
Time Series Concepts | p. 432 |
Time Series Example: The Rise in Global Temperatures | p. 432 |
Plotting the Global Temperature Time Series | p. 433 |
Analyzing the Change in Global Temperature | p. 436 |
Looking at Lagged Values | p. 438 |
The Autocorrelation Function | p. 440 |
Applying the ACF to Annual Mean Temperature | p. 441 |
Other ACF Patterns | p. 443 |
Applying the ACF to the Change in Temperature | p. 444 |
Moving Averages | p. 445 |
Simple Exponential Smoothing | p. 448 |
Forecasting with Exponential Smoothing | p. 450 |
Assessing the Accuracy of the Forecast | p. 450 |
Concept Tutorials: One-Parameter Exponential Smoothing | p. 451 |
Choosing a Value for w | p. 455 |
Two-Parameter Exponential Smoothing | p. 457 |
Calculating the Smoothed Values | p. 458 |
Concept Tutorials: Two-Parameter Exponential Smoothing | p. 459 |
Seasonality | p. 462 |
Multiplicative Seasonality | p. 462 |
Additive Seasonality | p. 464 |
Seasonal Example: Liquor Sales | p. 464 |
Examining Seasonality with a Boxplot | p. 467 |
Examining Seasonality with a Line Plot | p. 468 |
Applying the ACF to Seasonal Data | p. 470 |
Adjusting for Seasonality | p. 471 |
Three-Parameter Exponential Smoothing | p. 473 |
Forecasting Liquor Sales | p. 474 |
Optimizing the Exponential Smoothing Constant (optional) | p. 479 |
Exercises | p. 482 |
Quality Control | p. 487 |
Statistical Quality Control | p. 488 |
Controlled Variation | p. 489 |
Uncontrolled Variation | p. 489 |
Control Charts | p. 490 |
Control Charts and Hypothesis Testing | p. 492 |
Variable and Attribute Charts | p. 493 |
Using Subgroups | p. 493 |
The <$>\bar {x}<$> Chart | p. 493 |
Calculating Control Limits When ¿ Is Known | p. 494 |
<$>\bar {x}<$> Chart Example: Teaching Scores | p. 495 |
Calculating Control Limits When ¿ Is Unknown | p. 498 |
<$>\bar {x}<$> Chart Example: A Coating Process | p. 500 |
The Range Chart | p. 502 |
The C Chart | p. 504 |
C Chart Example: Factory Accidents | p. 504 |
The P Chart | p. 506 |
P Chart Example: Steel Rod Defects | p. 507 |
Control Charts for Individual Observations | p. 509 |
The Pareto Chart | p. 513 |
Exercises | p. 517 |
Appendix | p. 521 |
Excel Reference | p. 581 |
Bibliography | p. 587 |
Index | p. 589 |
Table of Contents provided by Ingram. All Rights Reserved. |