Začněte nyníZačněte zdarma

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.

Toto cvičení je součástí kurzu

Úvod do statistiky v Google Sheets

Zobrazit kurz

Pokyny k cvičení

  • 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.

Interaktivní praktické cvičení

Proměňte teorii v praxi s jedním z našich interaktivních cvičení

Začít cvičení