開始使用免費開始

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.

動手互動練習

將理論付諸實踐,立即體驗我們的互動練習

開始練習