{"product_id":"statistics-for-health-care-management-and-administration-working-with-excel-fourth-edition-9781119901679","title":"Statistics for Health Care Management and","description":"\u003cb\u003eBook Synopsis\u003c\/b\u003e\u003cbr\u003eThe 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 ExcelUnderstand how to acquire data and display it for analysisMaster important concepts and tests, including regressionTurn test results into usable information with proper analysisThis book not only helps students develop the necessary data analysis skills, but also boosts familiarity with important software that employers will be looking for.\u003cbr\u003e\u003cbr\u003e\u003cb\u003eTable of Contents\u003c\/b\u003e\u003cbr\u003e\u003cp\u003ePreface xiii\u003c\/p\u003e \u003cp\u003eIntroducing Excel xiii\u003c\/p\u003e \u003cp\u003eSo How Did We Get to Here? xiii\u003c\/p\u003e \u003cp\u003eIntended Level of the Textbook xiv\u003c\/p\u003e \u003cp\u003eTextbook Organization xiv\u003c\/p\u003e \u003cp\u003eLeading by Example(s) xv\u003c\/p\u003e \u003cp\u003eAcknowledgments xvii\u003c\/p\u003e \u003cp\u003eThe Authors xix\u003c\/p\u003e \u003cp\u003eAbout the Companion Website xxi\u003c\/p\u003e \u003cp\u003e\u003cb\u003ePart 1 1\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 1 Statistics and Excel 3\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003e1.1 How This Book Differs from Other Statistics Texts 3\u003c\/p\u003e \u003cp\u003e1.2 Statistical Applications in Health Policy and Health Administration 4\u003c\/p\u003e \u003cp\u003eExercises for Section 1.2 14\u003c\/p\u003e \u003cp\u003e1.3 What Is the ‘‘Big Picture’’? 15\u003c\/p\u003e \u003cp\u003e1.4 Some Initial Definitions 16\u003c\/p\u003e \u003cp\u003eExercises for Section 1.4 26\u003c\/p\u003e \u003cp\u003e1.5 Five Statistical Tests 28\u003c\/p\u003e \u003cp\u003eExercises for Section 1.5 30\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 2 Excel as a Statistical Tool 33\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003e2.1 The Basics 33\u003c\/p\u003e \u003cp\u003eExercises for Section 2.1 35\u003c\/p\u003e \u003cp\u003e2.2 Working and Moving Around in a Spreadsheet 36\u003c\/p\u003e \u003cp\u003eExercises for Section 2.2 41\u003c\/p\u003e \u003cp\u003e2.3 Excel Functions 41\u003c\/p\u003e \u003cp\u003eExercises for Section 2.3 46\u003c\/p\u003e \u003cp\u003e2.4 The =IF() Function 47\u003c\/p\u003e \u003cp\u003eExercises for Section 2.4 50\u003c\/p\u003e \u003cp\u003e2.5 Excel Graphs 51\u003c\/p\u003e \u003cp\u003eExercises for Section 2.5 56\u003c\/p\u003e \u003cp\u003e2.6 Sorting a String of Data 57\u003c\/p\u003e \u003cp\u003eExercise for Section 2.6 60\u003c\/p\u003e \u003cp\u003e2.7 The Data Analysis Pack 61\u003c\/p\u003e \u003cp\u003e2.8 Functions That Give Results in More than One Cell 63\u003c\/p\u003e \u003cp\u003eExercises for Section 2.8 66\u003c\/p\u003e \u003cp\u003e2.9 The Dollar Sign ($) Convention for Cell References 67\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 3 Data Acquisition: Sampling and Data Preparation 71\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003e3.1 The Nature of Data 71\u003c\/p\u003e \u003cp\u003eExercises for Section 3.1 78\u003c\/p\u003e \u003cp\u003e3.2 Sampling 79\u003c\/p\u003e \u003cp\u003eExercises for Section 3.2 93\u003c\/p\u003e \u003cp\u003e3.3 Data Access and Preparation 94\u003c\/p\u003e \u003cp\u003eExercises for Section 3.3 107\u003c\/p\u003e \u003cp\u003e3.4 Missing Data 108\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 4 Data Display: Descriptive Presentation, Excel Graphing Capability 111\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003e4.1 Creating, Displaying, and Understanding Frequency Distributions 111\u003c\/p\u003e \u003cp\u003eExercises for Section 4.1 129\u003c\/p\u003e \u003cp\u003e4.2 Using the Pivot Table to Generate Frequencies of Categorical Variables 131\u003c\/p\u003e \u003cp\u003eExercises for Section 4.2 135\u003c\/p\u003e \u003cp\u003e4.3 A Logical Extension of the Pivot Table: Two Variables 135\u003c\/p\u003e \u003cp\u003eExercises for Section 4.3 140\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 5 Basic Concepts of Probability 141\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003e5.1 Some Initial Concepts and Definitions 141\u003c\/p\u003e \u003cp\u003eExercises for Section 5.1 150\u003c\/p\u003e \u003cp\u003e5.2 Marginal Probabilities, Joint Probabilities, and Conditional Probabilities 150\u003c\/p\u003e \u003cp\u003eExercises for Section 5.2 160\u003c\/p\u003e \u003cp\u003e5.3 Binomial Probability 161\u003c\/p\u003e \u003cp\u003eExercises for Section 5.3 171\u003c\/p\u003e \u003cp\u003e5.4 The Poisson Distribution 173\u003c\/p\u003e \u003cp\u003eExercises for Section 5.4 178\u003c\/p\u003e \u003cp\u003e5.5 The Normal Distribution 178\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 6 Measures of Central Tendency and Dispersion: Data Distributions 183\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003e6.1 Measures of Central Tendency and Dispersion 183\u003c\/p\u003e \u003cp\u003eExercises for Section 6.1 196\u003c\/p\u003e \u003cp\u003e6.2 The Distribution of Frequencies 197\u003c\/p\u003e \u003cp\u003eExercises for Section 6.2 208\u003c\/p\u003e \u003cp\u003e6.3 The Sampling Distribution of the Mean 209\u003c\/p\u003e \u003cp\u003eExercises for Section 6.3 219\u003c\/p\u003e \u003cp\u003e6.4 Mean and Standard Deviation of a Discrete Numerical Variable 220\u003c\/p\u003e \u003cp\u003eExercises for Section 6.4 222\u003c\/p\u003e \u003cp\u003e6.5 The Distribution of a Proportion 222\u003c\/p\u003e \u003cp\u003eExercises for Section 6.5 227\u003c\/p\u003e \u003cp\u003e6.6 The t Distribution 227\u003c\/p\u003e \u003cp\u003eExercises for Section 6.6 232\u003c\/p\u003e \u003cp\u003e\u003cb\u003ePart 2 235\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 7 Confidence Limits and Hypothesis Testing 237\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003e7.1 What Is a Confidence Interval? 237\u003c\/p\u003e \u003cp\u003eExercises for Section 7.1 243\u003c\/p\u003e \u003cp\u003e7.2 Calculating Confidence Limits for Multiple Samples 244\u003c\/p\u003e \u003cp\u003eExercises for Section 7.2 246\u003c\/p\u003e \u003cp\u003e7.3 What Is Hypothesis Testing? 247\u003c\/p\u003e \u003cp\u003eExercises for Section 7.3 249\u003c\/p\u003e \u003cp\u003e7.4 Type I and Type II Errors 250\u003c\/p\u003e \u003cp\u003eExercises for Section 7.4 266\u003c\/p\u003e \u003cp\u003e7.5 Selecting Sample Sizes 267\u003c\/p\u003e \u003cp\u003eExercises for Section 7.5 269\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 8 Statistical Tests for Categorical Data 271\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003e8.1 Independence of Two Variables 271\u003c\/p\u003e \u003cp\u003eExercises for Section 8.1 282\u003c\/p\u003e \u003cp\u003e8.2 Examples of Chi-Square Analyses 283\u003c\/p\u003e \u003cp\u003eExercises for Section 8.2 289\u003c\/p\u003e \u003cp\u003e8.3 Small Expected Values in Cells 290\u003c\/p\u003e \u003cp\u003eExercises for Section 8.3 292\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 9 t Tests for Related and Unrelated Data 295\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003e9.1 What Is a t Test? 295\u003c\/p\u003e \u003cp\u003eExercises for Section 9.1 302\u003c\/p\u003e \u003cp\u003e9.2 A t Test for Comparing Two Groups 303\u003c\/p\u003e \u003cp\u003eExercises for Section 9.2 316\u003c\/p\u003e \u003cp\u003e9.3 A t Test for Related Data 318\u003c\/p\u003e \u003cp\u003eExercises for Section 9.3 321\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 10 Analysis of Variance 323\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003e10.1 One-Way Analysis of Variance 323\u003c\/p\u003e \u003cp\u003eExercises for Section 10.1 339\u003c\/p\u003e \u003cp\u003e10.2 ANOVA for Repeated Measures 340\u003c\/p\u003e \u003cp\u003eExercises for Section 10.2 348\u003c\/p\u003e \u003cp\u003e10.3 Factorial Analysis of Variance 349\u003c\/p\u003e \u003cp\u003eExercises for Section 10.3 362\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 11 Simple Linear Regression 365\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003e11.1 Meaning and Calculation of Linear Regression 365\u003c\/p\u003e \u003cp\u003eExercises for Section 11.1 373\u003c\/p\u003e \u003cp\u003e11.2 Testing the Hypothesis of Independence 374\u003c\/p\u003e \u003cp\u003eExercises for Section 11.2 380\u003c\/p\u003e \u003cp\u003e11.3 The Excel Regression Add-In 381\u003c\/p\u003e \u003cp\u003eExercises for Section 11.3 388\u003c\/p\u003e \u003cp\u003e11.4 The Importance of Examining the Scatterplot 388\u003c\/p\u003e \u003cp\u003e11.5 The Relationship between Regression and the t Test 391\u003c\/p\u003e \u003cp\u003eExercises for Section 11.5 392\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 12 Multiple Regression: Concepts and Calculation 395\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003e12.1 Introduction 395\u003c\/p\u003e \u003cp\u003eExercises for Section 12.1 406\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 13 Extensions of Multiple Regression 409\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003e13.1 Dummy Variables in Multiple Regression 409\u003c\/p\u003e \u003cp\u003eExercises for Section 13.1 420\u003c\/p\u003e \u003cp\u003e13.2 The Best Regression Model 421\u003c\/p\u003e \u003cp\u003eExercises for Section 13.2 431\u003c\/p\u003e \u003cp\u003e13.3 Correlation and Multicolinearity 432\u003c\/p\u003e \u003cp\u003eExercises for Section 13.3 435\u003c\/p\u003e \u003cp\u003e13.4 Nonlinear Relationships 435\u003c\/p\u003e \u003cp\u003eExercises for Section 13.4 447\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 14 Analysis with a Dichotomous Categorical Dependent Variable 449\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003e14.1 Introduction to the Dichotomous Dependent Variable 450\u003c\/p\u003e \u003cp\u003e14.2 An Example with a Dichotomous Dependent Variable: Traditional Treatments 451\u003c\/p\u003e \u003cp\u003eExercises for Section 14.2 462\u003c\/p\u003e \u003cp\u003e14.3 Logit for Estimating Dichotomous Dependent Variables 463\u003c\/p\u003e \u003cp\u003eExercises for Section 14.3 475\u003c\/p\u003e \u003cp\u003e14.4 A Comparison of Ordinary Least Squares, Weighted Least Squares, and Logit 476\u003c\/p\u003e \u003cp\u003eExercises for Section 14.4 480\u003c\/p\u003e \u003cp\u003eAppendix A Multiple Regression and Matrices 481\u003c\/p\u003e \u003cp\u003eAn Introduction to Matrix Math 481\u003c\/p\u003e \u003cp\u003eAddition and Subtraction of Matrices 482\u003c\/p\u003e \u003cp\u003eMultiplication of Matrices 483\u003c\/p\u003e \u003cp\u003eMatrix Multiplication and Scalars 484\u003c\/p\u003e \u003cp\u003eFinding the Determinant of a Matrix 484\u003c\/p\u003e \u003cp\u003eMatrix Capabilities of Excel 486\u003c\/p\u003e \u003cp\u003eExplanation of Excel Output Displayed with Scientific Notation 489\u003c\/p\u003e \u003cp\u003eUsing the b Coefficients to Generate Regression Results 490\u003c\/p\u003e \u003cp\u003eCalculation of All Multiple Regression Results 491\u003c\/p\u003e \u003cp\u003eExercises for Appendix A 494\u003c\/p\u003e \u003cp\u003eReferences 497\u003c\/p\u003e \u003cp\u003eGlossary 499\u003c\/p\u003e \u003cp\u003eIndex 513\u003c\/p\u003e","brand":"John Wiley \u0026 Sons Inc","offers":[{"title":"Default Title","offer_id":49528866505047,"sku":"9781119901679","price":73.76,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0817\/1739\/5799\/files\/9781119901679.jpg?v=1731873334","url":"https:\/\/bookcurl.com\/products\/statistics-for-health-care-management-and-administration-working-with-excel-fourth-edition-9781119901679","provider":"Book Curl","version":"1.0","type":"link"}