Health Services Research and Analytics Using Excel
Cover -- Title -- Copyright -- Contents -- Preface -- Acknowledgments -- Chapter 1: Introduction to Healthcare Data and the Role of Excel® -- 1.1 Context -- 1.2 Approach Advocated -- 1.3 Outline of the Book -- 1.4 Competency Development -- 1.5 Summary -- 1.6 Discussion Questions -- Chapter 2: Working in Excel® and Importing Healthcare Data -- 2.1 Sources of Healthcare Data -- 2.2 Data Used for Decision-Making -- 2.3 Excel in Actionable Insights -- 2.4 Importing Data Into Excel -- 2.5 Editing Cells and Content -- 2.6 Managing Data -- 2.7 Managing Add-Ins in Excel -- 2.8 Competency Development -- 2.9 Summary -- 2.10 Discussion Questions -- 2.11 Practice Problems -- Chapter 3: Identifying, Categorizing, and Presenting Healthcare Data Using Excel® -- 3.1 Getting Started -- 3.2 Identifying Your Data -- 3.3 Using Pivot Tables -- 3.4 Pivot Charts -- 3.5 Using Chart Types in Excel -- 3.6 Considerations in Using Different Chart Types -- 3.7 Competency Development -- 3.8 Summary -- 3.9 Discussion Questions -- 3.10 Practice Problems -- Chapter 4: Setting Bounds for Healthcare Data and Hypothesis Testing Using Excel® -- 4.1 Introduction -- 4.2 Setting Bounds on Data -- 4.3 Sample and Population -- 4.4 Measure and Variation -- 4.5 Confidence Interval -- 4.6 Hypothesis Testing -- 4.7 Z-Test -- 4.8 Comparing Two Samples Using the Z-Test -- 4.9 Competency Development -- 4.10 Summary -- 4.11 Discussion Questions -- 4.12 Practice Problems -- Chapter 5: Testing and Comparing Means of Healthcare Datasets Using Excel® -- 5.1 t-Test -- 5.2 Assumptions for the t-Test -- 5.3 Example for t-Test -- 5.4 t-Test Two-Sample Mean Assuming Equal Variance -- 5.5 t-Test Two-Sample Mean Assuming Unequal Variance -- 5.6 t-Test Paired Two-Sample Mean -- 5.7 Competency Development -- 5.8 Summary -- 5.9 Discussion Questions -- 5.10 Practice Problems.