Statistics for Health Care Professionals : Working with Excel

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

• ISBN13: 9780470393314
• ISBN10: 0470393319
• Edition: 2nd
• Format: Paperback
• Copyright: 2009-09-08
• Publisher: Jossey-Bass

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.