Calculating Measures of Central Tendency and Variability

In this assignment, you will be presented with 3 sets of data that you might encounter in a healthcare setting. For each data set you will be asked to use Excel to create functions for calculating measures of central tendency and variability. Be sure you have installed the Analysis Toolpak add-in to your Excel Software.

Download this Excel data file and complete the assignment.

If you need help creating statistical functions in Excel, you can review the Lynda.com videos (introduced in Module 01) or perform an Internet search to find some great instructional videos on YouTube.