Preface | p. xi |

Acknowledgments | p. xv |

The Authors | p. xvii |

| p. 1 |

Statistics and Excel | p. 3 |

How This Book Differs from Other Statistics Texts | p. 4 |

Statistical Applications in Health Policy and Health Administration | p. 5 |

Exercises for Section 1.2 | p. 13 |

What Is the "Big Picture"? | p. 13 |

Some Initial Definitions | p. 14 |

Exercises for Section 1.4 | p. 23 |

Five Statistical Tests | p. 25 |

Exercises for Section 1.5 | p. 27 |

Key Terms | p. 27 |

Excel As A Statistical Tool | p. 29 |

The Basics | p. 30 |

Exercises for Section 2.1 | p. 32 |

Working and Moving Around in a Spreadsheet | p. 32 |

Exercises for Section 2.2 | p. 37 |

Excel Functions | p. 37 |

Exercises for Section 2.3 | p. 42 |

The = IF() Function | p. 43 |

Exercises for Section 2.4 | p. 45 |

Excel Graphs | p. 46 |

Exercises for Section 2.5 | p. 51 |

Sorting a String of Data | p. 53 |

Exercises for Section 2.6 | p. 56 |

The Data Analysis Pack | p. 56 |

Functions that Give Results in More than One Cell | p. 60 |

Exercises for Section 2.8 | p. 61 |

The Dollar Sign ($) Convention for Cell References | p. 62 |

Key Terms | p. 63 |

Data Acquisition: Sampling and Data Preparation | p. 65 |

The Nature of Data | p. 66 |

Exercises for Section 3.1 | p. 71 |

Sampling | p. 72 |

Exercises for Section 3.2 | p. 85 |

Data Access and Preparation | p. 86 |

Exercises for Section 3.3 | p. 99 |

Missing Data | p. 100 |

Key Terms | p. 101 |

Data Display: Descriptive Presentation, Excel Graphing Capability | p. 103 |

The = FREQUENCY() Function | p. 104 |

Exercises for Section 4.1 | p. 121 |

Using the Pivot Table to Generate Frequencies of Categorical Variables | p. 123 |

Exercises for Section 4.2 | p. 134 |

A Logical Extension of the Pivot Table: Two Variables | p. 135 |

Exercises for Section 4.3 | p. 137 |

Appendix: Using Excel 2007 to Generate Pivot Tables with One Variable | p. 137 |

Key Terms | p. 142 |

Basic Concepts of Probability | p. 145 |

Some Initial Concepts and Definitions | p. 146 |

Exercises for Section 5.1 | p. 153 |

Marginal Probabilities, Joint Probabilities, and Conditional Probabilities | p. 154 |

Exercises for Section 5.2 | p. 163 |

Binomial Probability | p. 164 |

Exercises for Section 5.3 | p. 174 |

The Poisson Distribution | p. 175 |

Exercises for Section 5.4 | p. 180 |

The Normal Distribution | p. 180 |

Key Terms | p. 183 |

Measures of Central Tendency and Dispersion: Data Distributions | p. 185 |

Measures of Central Tendency and Dispersion | p. 186 |

Exercises for Section 6.1 | p. 198 |

The Distribution of Frequencies | p. 199 |

Exercises for Section 6.2 | p. 209 |

The Sampling Distribution of the Mean | p. 210 |

Exercises for Section 6.3 | p. 220 |

Mean and Standard Deviation of a Discrete Numerical Variable | p. 221 |

Exercises for Section 6.4 | p. 223 |

The Distribution of a Proportion | p. 224 |

Exercises for Section 6.5 | p. 227 |

The t Distribution | p. 228 |

Exercises for Section 6.6 | p. 232 |

Key Terms | p. 233 |

| p. 235 |

Confidence Limits and Hypothesis Testing | p. 237 |

What Is a Confidence Interval? | p. 238 |

Exercises for Section 7.1 | p. 242 |

Calculating Confidence Limits for Multiple Samples | p. 243 |

Exercises for Section 7.2 | p. 246 |

What Is Hypothesis Testing? | p. 246 |

Exercises for Section 7.3 | p. 249 |

Type I and Type II Errors | p. 250 |

Exercises for Section 7.4 | p. 264 |

Selecting Sample Sizes | p. 265 |

Exercises for Section 7.5 | p. 267 |

Key Terms | p. 268 |

Statistical Tests for Categorical Data | p. 269 |

Independence of Two Variables | p. 270 |

Exercises for Section 8.1 | p. 279 |

Examples of Chi-Square Analyses | p. 280 |

Exercises for Section 8.2 | p. 285 |

Small Expected Values in Cells | p. 286 |

Exercises for Section 8.3 | p. 289 |

Key Terms | p. 289 |

t Tests for Related and Unrelated Data | p. 291 |

What Is a t Test? | p. 292 |

Exercises for Section 9.1 | p. 298 |

A t Test for Comparing Two Groups | p. 298 |

Exercises for Section 9.2 | p. 311 |

A t Test for Related Data | p. 313 |

Exercises for Section 9.3 | p. 316 |

Key Terms | p. 316 |

Analysis of Variance | p. 317 |

One-Way Analysis of Variance | p. 318 |

Exercises for Section 10.1 | p. 332 |

ANOVA for Repeated Measures | p. 334 |

Exercises for Section 10.2 | p. 342 |

Factorial Analysis of Variance | p. 343 |

Exercises for Section 10.3 | p. 355 |

Key Terms | p. 358 |

Simple Linear Regression | p. 359 |

Meaning and Calculation of Linear Regression | p. 360 |

Exercises for Section 11.1 | p. 367 |

Testing the Hypothesis of Independence | p. 368 |

Exercises for Section 11.2 | p. 374 |

The Excel Regression Add-In | p. 375 |

Exercises for Section 11.3 | p. 380 |

The Importance of Examining the Scatterplot | p. 380 |

The Relationship Between Regression and the t Test | p. 382 |

Exercises for Section 11.5 | p. 384 |

Key Terms | p. 385 |

Multiple Regression: Concepts and Calculation | p. 387 |

Introduction | p. 388 |

Exercises for Section 12.1 | p. 397 |

Multiple Regression and Matrices | p. 398 |

Exercises for Section 12.2 | p. 410 |

Key Terms | p. 413 |

Extensions of Multiple Regression | p. 415 |

Dummy Variables in Multiple Regression | p. 413 |

Exercises for Section 13.1 | p. 425 |

The Best Regression Model | p. 427 |

Exercises for Section 13.2 | p. 436 |

Correlation and Multicolinearity | p. 437 |

Exercises for Section 13.3 | p. 439 |

Nonlinear Relationships | p. 439 |

Exercises for Section 13.4 | p. 450 |

Key Terms | p. 452 |

Analysis with a Dichotomous Categorical Dependent Variable | p. 453 |

Introduction to the Dichotomous Dependent Variable | p. 454 |

An Example with a Dichotomous Dependent Variable: Traditional Treatments | p. 455 |

Exercises for Section 14.2 | p. 465 |

Logit for Estimating Dichotomous Dependent Variables | p. 466 |

Exercises for Section 14.3 | p. 48 |

A Comparison of Ordinary Least Squares, Weighted Least Squares, and Logit | p. 479 |

Exercises for Section | p. 480 |

Key Terms | p. 481 |

Glossary | p. 483 |

References | p. 493 |

Index | p. 495 |

Table of Contents provided by Ingram. All Rights Reserved. |