开始使用免费开始使用

Visualizing customer longevity

Now that you see that savings has a peak with roughly equal "tails" to the left and right, let's explore another variable in the data: "Retention". The bank measures "retention" of each customer, which measures how long a customer stays with the company. This measure can be one aspect of a healthy bank because there is a lot of cost associated with acquiring and setting up new accounts.

When you made the savings histogram the peak was centered around ~1400. This sample data ranges from 1 to 65 months so the peak will be different, and you should note how the "tails" look in this visual. Additionally, review the mean and mode to see if they are as close to each other as the previous exercise.

本练习是课程的一部分

Google Sheets 统计学入门

查看课程

练习说明

  • In cell F1, calculate the mean retention.
  • In cell F2, calculate the median retention and compare it to the mean. What do you expect the histogram to look like as a result?
  • Insert a histogram in the highlighted region to view the tails of the data.

动手互动练习

通过我们的互动练习之一,将理论转化为实践

开始练习