I can't seem to find a function that makes sense to me in this.
Edit:
Lets look at it like a party.
Say there is a party in 4 weeks. 10 people are going to the party. They each invite 10 others to the party. 50% of the people they invite will attend the party. This results in 50 new attendees in the 1st week. Each of those 50 invite 10 other people. Since 50% of the invites that go out are accepted now 250 new people have accepted the invitation in the 2nd week.
week 0 = 10
week 1 = 50
week 2 = 250
week 3 = 1,250
week 4 = 6,250
Total people who will be attending = 7,810
I'd like to be able to find out two things.
- How many new people are invited in any given week.
- How many total people are invited by the time of any given week.