5. Using Recursive Rules with Sequences
Sign In
At the beginning of the (n-1)^(th) year the number of members is a_(n-1). Each year, the company loses 20 %= 0.2 of members. The number of old members at the end of (n-1)^(th) year is (1- 0.2)a_(n-1)= 0.8a_(n-1). The service gains 5000 new members every year. This tells us that a_n= 0.8a_(n-1)+ 5000. Recursive Rule: a_1=50 000, a_n=0.8a_(n-1)+5000forn>1
=Round((0.8)*(A1)+5000,2)in cell A2. When we hit enter, we will get the following.
=Round(0.8)*(A1)+5000in cell A2. When we hit enter, we will get the following.
After cell A62 we will keep getting the same value, 25 000.02. This tells us that the number of members stabilizes around 25 000 people.