Statistics for Health Care Professionals : Working with Excel

by ; ;
  • ISBN13:


  • ISBN10:


  • Edition: 2nd
  • Format: Paperback
  • Copyright: 2009-09-08
  • Publisher: Jossey-Bass
  • View Upgraded Edition
  • Purchase Benefits
  • Free Shipping On Orders Over $35!
    Your order must be $35 or more to qualify for free economy shipping. Bulk sales, PO's, Marketplace items, eBooks and apparel do not qualify for this offer.
  • Get Rewarded for Ordering Your Textbooks! Enroll Now
List Price: $98.98 Save up to $22.19


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

Prefacep. xi
Acknowledgmentsp. xv
The Authorsp. xvii
p. 1
Statistics and Excelp. 3
How This Book Differs from Other Statistics Textsp. 4
Statistical Applications in Health Policy and Health Administrationp. 5
Exercises for Section 1.2p. 13
What Is the "Big Picture"?p. 13
Some Initial Definitionsp. 14
Exercises for Section 1.4p. 23
Five Statistical Testsp. 25
Exercises for Section 1.5p. 27
Key Termsp. 27
Excel As A Statistical Toolp. 29
The Basicsp. 30
Exercises for Section 2.1p. 32
Working and Moving Around in a Spreadsheetp. 32
Exercises for Section 2.2p. 37
Excel Functionsp. 37
Exercises for Section 2.3p. 42
The = IF() Functionp. 43
Exercises for Section 2.4p. 45
Excel Graphsp. 46
Exercises for Section 2.5p. 51
Sorting a String of Datap. 53
Exercises for Section 2.6p. 56
The Data Analysis Packp. 56
Functions that Give Results in More than One Cellp. 60
Exercises for Section 2.8p. 61
The Dollar Sign ($) Convention for Cell Referencesp. 62
Key Termsp. 63
Data Acquisition: Sampling and Data Preparationp. 65
The Nature of Datap. 66
Exercises for Section 3.1p. 71
Samplingp. 72
Exercises for Section 3.2p. 85
Data Access and Preparationp. 86
Exercises for Section 3.3p. 99
Missing Datap. 100
Key Termsp. 101
Data Display: Descriptive Presentation, Excel Graphing Capabilityp. 103
The = FREQUENCY() Functionp. 104
Exercises for Section 4.1p. 121
Using the Pivot Table to Generate Frequencies of Categorical Variablesp. 123
Exercises for Section 4.2p. 134
A Logical Extension of the Pivot Table: Two Variablesp. 135
Exercises for Section 4.3p. 137
Appendix: Using Excel 2007 to Generate Pivot Tables with One Variablep. 137
Key Termsp. 142
Basic Concepts of Probabilityp. 145
Some Initial Concepts and Definitionsp. 146
Exercises for Section 5.1p. 153
Marginal Probabilities, Joint Probabilities, and Conditional Probabilitiesp. 154
Exercises for Section 5.2p. 163
Binomial Probabilityp. 164
Exercises for Section 5.3p. 174
The Poisson Distributionp. 175
Exercises for Section 5.4p. 180
The Normal Distributionp. 180
Key Termsp. 183
Measures of Central Tendency and Dispersion: Data Distributionsp. 185
Measures of Central Tendency and Dispersionp. 186
Exercises for Section 6.1p. 198
The Distribution of Frequenciesp. 199
Exercises for Section 6.2p. 209
The Sampling Distribution of the Meanp. 210
Exercises for Section 6.3p. 220
Mean and Standard Deviation of a Discrete Numerical Variablep. 221
Exercises for Section 6.4p. 223
The Distribution of a Proportionp. 224
Exercises for Section 6.5p. 227
The t Distributionp. 228
Exercises for Section 6.6p. 232
Key Termsp. 233
p. 235
Confidence Limits and Hypothesis Testingp. 237
What Is a Confidence Interval?p. 238
Exercises for Section 7.1p. 242
Calculating Confidence Limits for Multiple Samplesp. 243
Exercises for Section 7.2p. 246
What Is Hypothesis Testing?p. 246
Exercises for Section 7.3p. 249
Type I and Type II Errorsp. 250
Exercises for Section 7.4p. 264
Selecting Sample Sizesp. 265
Exercises for Section 7.5p. 267
Key Termsp. 268
Statistical Tests for Categorical Datap. 269
Independence of Two Variablesp. 270
Exercises for Section 8.1p. 279
Examples of Chi-Square Analysesp. 280
Exercises for Section 8.2p. 285
Small Expected Values in Cellsp. 286
Exercises for Section 8.3p. 289
Key Termsp. 289
t Tests for Related and Unrelated Datap. 291
What Is a t Test?p. 292
Exercises for Section 9.1p. 298
A t Test for Comparing Two Groupsp. 298
Exercises for Section 9.2p. 311
A t Test for Related Datap. 313
Exercises for Section 9.3p. 316
Key Termsp. 316
Analysis of Variancep. 317
One-Way Analysis of Variancep. 318
Exercises for Section 10.1p. 332
ANOVA for Repeated Measuresp. 334
Exercises for Section 10.2p. 342
Factorial Analysis of Variancep. 343
Exercises for Section 10.3p. 355
Key Termsp. 358
Simple Linear Regressionp. 359
Meaning and Calculation of Linear Regressionp. 360
Exercises for Section 11.1p. 367
Testing the Hypothesis of Independencep. 368
Exercises for Section 11.2p. 374
The Excel Regression Add-Inp. 375
Exercises for Section 11.3p. 380
The Importance of Examining the Scatterplotp. 380
The Relationship Between Regression and the t Testp. 382
Exercises for Section 11.5p. 384
Key Termsp. 385
Multiple Regression: Concepts and Calculationp. 387
Introductionp. 388
Exercises for Section 12.1p. 397
Multiple Regression and Matricesp. 398
Exercises for Section 12.2p. 410
Key Termsp. 413
Extensions of Multiple Regressionp. 415
Dummy Variables in Multiple Regressionp. 413
Exercises for Section 13.1p. 425
The Best Regression Modelp. 427
Exercises for Section 13.2p. 436
Correlation and Multicolinearityp. 437
Exercises for Section 13.3p. 439
Nonlinear Relationshipsp. 439
Exercises for Section 13.4p. 450
Key Termsp. 452
Analysis with a Dichotomous Categorical Dependent Variablep. 453
Introduction to the Dichotomous Dependent Variablep. 454
An Example with a Dichotomous Dependent Variable: Traditional Treatmentsp. 455
Exercises for Section 14.2p. 465
Logit for Estimating Dichotomous Dependent Variablesp. 466
Exercises for Section 14.3p. 48
A Comparison of Ordinary Least Squares, Weighted Least Squares, and Logitp. 479
Exercises for Sectionp. 480
Key Termsp. 481
Glossaryp. 483
Referencesp. 493
Indexp. 495
Table of Contents provided by Ingram. All Rights Reserved.

Rewards Program

Write a Review