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
Pokyny k cvičení
- In cell
F3, calculate the mode. - In cell
F4, calculate the standard deviation usingSTDEV(). - 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í