Online College Courses for Credit

Presenting Single Variable Data

Presenting Single Variable Data

Author: Laura Kniffin

This packet teaches:

How and when to use pie charts and bar graphs
How to create pie charts and bar graphs in Excel
How and when to use dotplots

A compilation of videos, images, and text on how to present single variable data

Co-Authors: Kendra Wheeler and Craig Nelson

See More

Try Our College Algebra Course. For FREE.

Sophia’s self-paced online courses are a great way to save time and money as you earn credits eligible for transfer to many different colleges and universities.*

Begin Free Trial
No credit card required

37 Sophia partners guarantee credit transfer.

299 Institutions have accepted or given pre-approval for credit transfer.

* The American Council on Education's College Credit Recommendation Service (ACE Credit®) has evaluated and recommended college credit for 32 of Sophia’s online courses. Many different colleges and universities consider ACE CREDIT recommendations in determining the applicability to their course and degree programs.


Terms To Know

Variable- a number that can change. We use variables when collecting data.

Quantitative- a number value, a measurement 

Qualitative- The categories used, a descriptive of the variable

When to use the graphs

- A pie chart is used when you have percentages

- A bar graph is used when comparing numerical values

- A dot plot is used to show a correlation between two variables

How to Graph Bar and Pie Charts on Excel

Making Dot Plots!

To make dot plots on excel, you follow the same instructions (making pie and bar graphs) in the video above, but you pick the graph that represents a dot plot.

*As said above, dot plots can be used to show correlation between data. When used in excel, it shows clear correlations, and can help the viewer to better understand the connection between your data recieved.