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.
本練習屬於課程
Google Sheets 統計學入門
練習說明
- 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.
