# Practical Applications for Health Statistics Using MS Excel

Author(s): Anne Pate

Edition: 2

Details: eBook w/Ancillary 3 | 180 days |

### STEP 2: CHOOSE YOUR PLATFORM Help Me Choose

This lab textbook is designed to teach undergraduate students how to use Microsoft Excel within the context of a health statistics course. The labs begin with introductory exercises teaching students basic navigation, terminology, and functions within Excel. The lab exercises are designed to build on themselves, applying previously learned skills and adding new ones with each lab. Students learn how to organize data, write formulas, create graphs with appropriate components, and use the data analysis toolpak to conduct basic statistical functions.

The lab culminates with a group project focusing on one of a variety of provided health topics. Each group is provided with a dataset that includes incidence, mortality, risk factors and demographics that they must apply their Excel and statistical knowledge and skills to analyze, summarize, and present their findings in both poster and presentation formats.

All lab exercises and the final group project use publicly available health datasets from the Centers for Disease Control and Prevention. This offers the students an opportunity to work with real health data and apply their statistical knowledge to a dataset representing populations throughout the United States.

Section 1 Microsoft Excel and Basic Statistics

Lab 1 MS Excel Basics

Terminology

Functions and Formatting

Formulas

Pivot Tables

Excel Basics Lab Instructions

Lab 2 Making Graphs in MS Excel

Types of Graphs

Anatomy of a Graph

Graphing Lab Instructions

Section 2 Detailed Instructions for Creating Graphs and Conducting Data Analysis in Excel

Scatterplots

Correlation Coefficient

Regression

Data Analysis Toolpak

Two Sample t-Test

Anova

Anne Pate

### Ebook Package

#### \$41.00

QTY:

ISBN 9781792492174

Details eBook w/Ancillary 3 180 days