The must-have statistics guide for students of health services Statistics for Health Care Management and Administration: Working with Excel introduces the uses of statistics in healthcare management and administration using the features and functions of Microsoft Excel. The book introduces students to statistics within the context of health care, focusing on the major data and analysis techniques used in the field. Step-by-step instructions in the latest version of Excel and numerous annotated screen shots make examples easy to follow and understand. This updated fourth edition provides…mehr
The must-have statistics guide for students of health services
Statistics for Health Care Management and Administration: Working with Excel introduces the uses of statistics in healthcare management and administration using the features and functions of Microsoft Excel. The book introduces students to statistics within the context of health care, focusing on the major data and analysis techniques used in the field. Step-by-step instructions in the latest version of Excel and numerous annotated screen shots make examples easy to follow and understand.
This updated fourth edition provides the same content and explanations that have made the previous editions so popular, offering revisions drawn directly from universities where the book has been used. All content has been brought current with the newest version of excel, and changes in the field of healthcare administration are covered as well. Statistics for Health Care Management and Administration gets students off to a great start by introducing statistics in the context of their chosen field. _ Learn the basics of statistics in the context of Excel _ Understand how to acquire data and display it for analysis _ Master important concepts and tests, including regression _ Turn test results into usable information with proper analysis
This book not only helps students develop the necessary data analysis skills, but also boosts familiarity with important software that employers will be looking for.Hinweis: Dieser Artikel kann nur an eine deutsche Lieferadresse ausgeliefert werden.
David A. Rosenthal is a Chief Information Officer at CampusWorks, Inc. He has over 20 years of health care industry experience in both academic and practitioner settings, having served in roles specific to hospital information technology leadership, multispecialty practice administration, and ambulatory services project management. Rosenthal earned a Master of Public Administration degree from Valdosta State University, and a PhD in Technology Management from Indiana State University. David is a proud veteran of the U.S. Air Force, and resides in Oakland, Tennessee with his wife Allyson. John F. Kros is the Vincent K. McMahon Distinguished Professor in the Marketing and Supply Chain Management Department in the College of Business at East Carolina University, in Greenville, North Carolina. He teaches business decision modeling, statistics, operations and supply chain management, and purchasing and materials management courses. Kros was honored as the College of Business's Scholar/Teacher for 2004???2005, again in 2009???2010, was awarded the College of Business Commerce Club's highest honor, the Teaching Excellence Award, for 2006 and again in 2011, in 2013???2014 was awarded the East Carolina Alumni Association Outstanding Teaching Award, and in 2014???2015 was awarded the Board of Governors Distinguished Professor for Teaching Award. Kros earned his PhD in systems engineering from the University of Virginia, his MBA from Santa Clara University, and his BBA from the University of Texas at Austin. His research interests include health care operations, applied statistics, design of experiments, multi-objective decision making, Taguchi methods, and applied decision analysis. His textbook titled Spreadsheet Modeling for Business Decisions is in the fifth edition. He is also coauthor of Health Care Operations and Supply Chain Management.
Inhaltsangabe
Preface xiii
Introducing Excel xiii
So How Did We Get to Here? xiii
Intended Level of the Textbook xiv
Textbook Organization xiv
Leading by Example(s) xv
Acknowledgments xvii
The Authors xix
About the Companion Website xxi
Part 1 1
Chapter 1 Statistics and Excel 3
1.1 How This Book Differs from Other Statistics Texts 3
1.2 Statistical Applications in Health Policy and Health Administration 4
Exercises for Section 1.2 14
1.3 What Is the ''Big Picture''? 15
1.4 Some Initial Definitions 16
Exercises for Section 1.4 26
1.5 Five Statistical Tests 28
Exercises for Section 1.5 30
Chapter 2 Excel as a Statistical Tool 33
2.1 The Basics 33
Exercises for Section 2.1 35
2.2 Working and Moving Around in a Spreadsheet 36
Exercises for Section 2.2 41
2.3 Excel Functions 41
Exercises for Section 2.3 46
2.4 The =IF() Function 47
Exercises for Section 2.4 50
2.5 Excel Graphs 51
Exercises for Section 2.5 56
2.6 Sorting a String of Data 57
Exercise for Section 2.6 60
2.7 The Data Analysis Pack 61
2.8 Functions That Give Results in More than One Cell 63
Exercises for Section 2.8 66
2.9 The Dollar Sign ($) Convention for Cell References 67
Chapter 3 Data Acquisition: Sampling and Data Preparation 71
3.1 The Nature of Data 71
Exercises for Section 3.1 78
3.2 Sampling 79
Exercises for Section 3.2 93
3.3 Data Access and Preparation 94
Exercises for Section 3.3 107
3.4 Missing Data 108
Chapter 4 Data Display: Descriptive Presentation, Excel Graphing Capability 111
4.1 Creating, Displaying, and Understanding Frequency Distributions 111
Exercises for Section 4.1 129
4.2 Using the Pivot Table to Generate Frequencies of Categorical Variables 131
Exercises for Section 4.2 135
4.3 A Logical Extension of the Pivot Table: Two Variables 135
Exercises for Section 4.3 140
Chapter 5 Basic Concepts of Probability 141
5.1 Some Initial Concepts and Definitions 141
Exercises for Section 5.1 150
5.2 Marginal Probabilities, Joint Probabilities, and Conditional Probabilities 150
Exercises for Section 5.2 160
5.3 Binomial Probability 161
Exercises for Section 5.3 171
5.4 The Poisson Distribution 173
Exercises for Section 5.4 178
5.5 The Normal Distribution 178
Chapter 6 Measures of Central Tendency and Dispersion: Data Distributions 183
6.1 Measures of Central Tendency and Dispersion 183
Exercises for Section 6.1 196
6.2 The Distribution of Frequencies 197
Exercises for Section 6.2 208
6.3 The Sampling Distribution of the Mean 209
Exercises for Section 6.3 219
6.4 Mean and Standard Deviation of a Discrete Numerical Variable 220
Exercises for Section 6.4 222
6.5 The Distribution of a Proportion 222
Exercises for Section 6.5 227
6.6 The t Distribution 227
Exercises for Section 6.6 232
Part 2 235
Chapter 7 Confidence Limits and Hypothesis Testing 237
7.1 What Is a Confidence Interval? 237
Exercises for Section 7.1 243
7.2 Calculating Confidence Limits for Multiple Samples 244
