CommencerCommencer gratuitement

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.

Cet exercice fait partie du cours

Introduction to Statistics in Google Sheets

Afficher le cours

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.

Exercice interactif pratique

Passez de la théorie à la pratique avec l’un de nos exercices interactifs

Commencer l’exercice