Health Services Research and Analytics Using Excel.

Format:

Book

Author/Creator:

Johri, Nalin, PhD, MPH.

Contributor:

ProQuest ebook central.

William Pepper Medical Library Fund.

Language:

English

Subjects (All):

Medical care--Research--Data processing.

Medical care.

Medical care--Research.

Physical Description:

1 online resource (253 pages)

Place of Publication:

New York : Springer Publishing Company, 2020.

System Details:

text file

Contents:

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

Chapter 6: Checking Patterns in Healthcare Data Using Scatterplots, Correlations, and Regressions in Excel®

6.1 Exploring Relationships and Patterns

6.2 Scatterplot and Correlation

6.3 Regression

6.4 Single Linear Regression

6.5 Multiple Regression

6.6 Revisiting Missing Values

6.7 Competency Development

6.8 Summary

6.9 Discussion Questions

6.10 Practice Problems

Chapter 7: Visualization and Spatial Analysis of Healthcare Data Using 3D Maps in Excel®

7.1 Why and When to Map Data

7.2 Converting Data to Tables

7.3 Turn to 3D Maps

7.4 Steps in Visualizing 3D Maps

7.5 Working With Scenes

7.6 Including Time Element

7.7 Production of Tour

7.8 Competency Development

7.9 Summary

7.10 Discussion Questions

7.11 Practice Problems

Chapter 8: Using Analysis of Variance (ANOVA) in Healthcare Datasets to Compare Groups and Test Hypotheses in Excel®

8.1 ANOVA

8.2 Creating Categories

8.3 Stating Hypotheses

8.4 Getting Data Ready in Excel

8.5 Interpreting ANOVA Output

8.6 Competency Development

8.7 Summary

8.8 Discussion Questions

Notes:

8.9 Practice Problems.

Electronic reproduction. Ann Arbor, MI Available via World Wide Web.

Print version record.

Local Notes:

Acquired for the Penn Libraries with assistance from the William Pepper Medical Library Fund.

Other Format:

Print version: Johri, Nalin, PhD, MPH. Health Services Research and Analytics Using Excel.

ISBN:

9780826150288

0826150284

Publisher Number:

99984159438

Access Restriction:

Restricted for use by site license.