"Normal" views of money

In this set of exercises, you'll work with this sample of US accounts. The first column is a unique account identifier, and the second contains the amount of savings that account has.

It is helpful to visualize distributions using a histogram. A histogram buckets each observation into a "bin". It reduces information, just like an average, but not down to a single value. Instead, the count of observations in each bin is represented in a histogram. Keep in mind when making a histogram that it's best to have more than 20 observations. Furthermore, if you are working with samples of data, you will want a random sample to prevent biased results.

Let's now take a look at what the savings distribution is and how it compares to the descriptive statistics that have already been calculated for you.

This exercise is part of the course

Introduction to Statistics in Google Sheets

View Course

Exercise instructions

  • In the highlighted region between H1 and K1, insert a histogram to visualize the savings column (B2:B101).

Hands-on interactive exercise

Turn theory into action with one of our interactive exercises

Start Exercise