Skip to Main Content

William Madison Randall Library

Data Analysis

Descriptive Statistics in Excel

We have created some short tutorials for how to compute descriptive statistics in tables and graphs.

Practice dataset--Diabetes.xlsx
Variables include: subject ID, # pregnancies, Plasma-Glucose Concentration, Diastolic Blood-Pressure, Body Mass Index, Age, Diabetes status.
Data obtained 9/2022 from: http://www.liacc.up.pt/ML/statlog/datasets/diabetes/diabetes.doc.html

How to Install Data Analysis ToolPak in Excel (~1.5 min)
Guide to adding access to data analysis features using an Excel add-in called "Data Analysis ToolPak." (Video created at UNCW 9/2022)

How to Calculate Descriptive Statistics in Excel (~3 min)
Guide to calculating descriptive statistics using Excel. (Video created at UNCW 9/2022)

How to Calculate IQR in Excel (~3.5 min)
Guide to calculating the Interquartile Range using Excel. (Video created at UNCW 9/2022)

How to Make a Frequency Distribution Table in Excel (~4 min)
Guide to making a frequency distribution table using Excel. (Video created at UNCW 9/2022)

How to Make a Bar Chart in Excel (~5.5 min)
Guide to making a bar chart using Excel. (Video created at UNCW 9/2022)

How to Make a Boxplot in Excel (~5 min)
Guide to making a boxplot using Excel. (Video created at UNCW 9/2022)

How to Make a Histogram in Excel (~2.5 min)
Guide to making a histogram using Excel. (Video created at UNCW 9/2022)