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.
Next, copy cell A2, highlight cells A3 through A5, and paste.
We get 35 240 in the fifth row. This tells us that a_5=35 240.
=Round(0.8)*(A1)+5000in cell A2. When we hit enter, we will get the following.
Notice that the sequence stabilizes around cell A63.
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.