Bar chart of competitive counts
So far you've examined numeric data. What should you do to learn about categorical data? This sheet contains 150 online auctions with non-numeric data. One method to explore this type of variable is with a bar chart, also called a "column chart".
Here, the COUNTIF()
function has been to used to count the number of "1"s and "0"s.
In DataCamp's Pivot Tables in Google Sheets course, you can learn efficient ways like this to count data.
Your job in this exercise is to create two types of bar charts: stacked, and side-by-side. The difference is subtle but helps your audience in different ways.
- Stacked: helps you focus on the proportion of the total that is a particular class. You will visually understand the amount of the total that represents competitive online auctions.
- Side-by-side: lets the audience understand the values in relation to each other. You will visually interpret how similar each class values are.
This exercise is part of the course
Introduction to Statistics in Google Sheets
Exercise instructions
- Insert a column chart referencing
D2:E2
in cellG1
. - Create another visual of the same data at
G10
, this time selecting "Stacked column chart".
Hands-on interactive exercise
Turn theory into action with one of our interactive exercises
