Please Help Sequence Problem Excel Assumptions Generation 1 Start One Pair Rabbits Generat Q43825224
Can you please help me with a sequence problem in Excel.Assumptions:
- In Generation (1), we start off with one pair of rabbits.
- In Generation (2), this pair of rabbits matures.
- In Generation (3), the original pair of rabbits give birth toanother pair of rabbits.
- In Generation (4), the original pair gives birth to theirsecond pair, and the first offspring of the original pair alsomatures.
- Rabbits die after 5 generations.
- At what generation does the number of rabbit pairsreach 100,000?
I tried to start the sequence byhand:
Generations12345678# of Rabbit Pairs1123571116
The sequence is definitely correct through G(6), although I’mnot sure of the rest. My attempt at a formula is: xn =[xn-1 + xn-2] – xn-5 forxn >=6, although I’m not sure if it’s correct.
Could you please check this and provide the work in Excel forwhat generation the population reaches 100,000, along with thepopulation numbers.
Thank you so much!
Expert Answer
Answer to Can you please help me with a sequence problem in Excel. Assumptions: In Generation (1), we start off with one pair of r…
OR