More New and Used

from Private Sellers

**Note:**Supplemental materials are not guaranteed with Rental or Used book purchases.

# Statistics for Health Care Professionals : Working with Excel

ISBN13:

## 9780470393314

**by**Veney, James E.; Kros, John F.; Rosenthal, David A.

0470393319

2nd

Paperback

9/8/2009

Jossey-Bass

### Questions About This Book?

### What version or edition is this?

This is the 2nd edition with a publication date of 9/8/2009.

### What is included with this book?

- The
**Used**copy of this book is not guaranteed to include any supplemental materials. Typically, only the book itself is included. - The
**eBook**copy of this book is not guaranteed to include any supplemental materials. Typically only the book itself is included.

### Summary

There is a need for an updated comprehensive text on statistics in health care services. This important resource, that has been thoroughly revised and update to include Excel 2007, offers a comprehensive introduction to statistical methods for the health care researcher and professional. It also includes an overview of Excel 2007 as a powerful tool for research and analysis. This text includes new information on logic of statistical testing, dealing with missing data, relative risk and odds ratios, regression treatment of time series data, and more.

### Author Biography

John F. Kros is an associate professor of marketing and supply chain management at East Carolina University College of Business, Greenville, North Carolina.

David A. Rosenthal is an associate professor in the Department of Health Informatics and Information Management at the University of Tennessee's Health Science Center, Memphis.

### Table of Contents

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. |