Visualizing customer donations

Some banks will buy third party information to help with marketing. For example, some non-profit donations are publicly available. A bank can market to these likely affluent customers for additional banking services. This sample data has the household identifier joined to example third party data for public donations.

In this exercise, you will focus on the mode and standard deviation. Since the data is expected to be a proxy for affluence with most people not making donations, these descriptive statistics can aid you in understanding the distribution before you create another histogram.

This exercise is part of the course

Introduction to Statistics in Google Sheets

View Course

Exercise instructions

  • In cell F3, calculate the mode.
  • In cell F4, calculate the standard deviation using STDEV().
  • Visualize this new distribution in a histogram to see the shape and how the "tails" of the histogram behave.

Hands-on interactive exercise

Turn theory into action with one of our interactive exercises

Start Exercise