Walmart has collected the retention rates in the first 10 periods in Table 2 (see Excel File). Suppose the retention rate ceiling je 90% and the cohort size is 2,000. Please fill in the relevant cells from Columb 2 to Column 7. How much is the aberage retention rate? How long is the average customer lifetime duration? Please use Excel to solve this problem.

a. Please manually calculaye the r value for Period 8.

b. Suppose the value of r is 0.28. Please manually calculate the projected retention rate in Period 12.

c.) From your works with Excel, how much is the aberage retention rate? How long is the average customer lifetime duration?

1.Period Since 2. Actua 13.Predicted 4.Defection 5.Survival Rate Acquisition Retention Rate Retention Rate Rate % 2 6.Expected Number of 7. Number of A Active Customers Periods 3 1 2 3 5 6 N 4 0.39 0.43 0.44 0.45 0.50 0.54 5 0.60 0.68 0.70 0.74 6 7 10 8 TI 9 12 10 13 11 14 12 15 13 10 14 17 15 10 16 1917 2018 21 19 22 20 23 2. Rr celling 25 Cohort 90% 2000 1.Period Since 2. Actua 13.Predicted 4.Defection 5.Survival Rate Acquisition Retention Rate Retention Rate Rate % 2 6.Expected Number of 7. Number of A Active Customers Periods 3 1 2 3 5 6 N 4 0.39 0.43 0.44 0.45 0.50 0.54 5 0.60 0.68 0.70 0.74 6 7 10 8 TI 9 12 10 13 11 14 12 15 13 10 14 17 15 10 16 1917 2018 21 19 22 20 23 2. Rr celling 25 Cohort 90% 2000