Good at math? Help me!

pnwlover12 · August 2014

Okay, I hope this isn't too annoying to ask, but someone please help me. I have a project to complete dealing with exponential growth and rabbits multiplying (so it's sort of baby relevant!). I tried emailing the instructor for some direction, but haven't heard back and I need to finish this.

If anyone can offer me some sort of insight, I will love you forever - this is complete jibberish to me.

Project 3 (section 4)

Exponential growth assignment:

We discussed earlier with exponential growth that doubling can’t continue forever. Something will happen to cause the growth to stop. Consider the following scenario:

A rabbit matures at 6 months, has a gestation period of 31 days—call it one month (with a 4 week time lapse after birth to become fertile again), and has a litter of 10 rabbits (assume that half are female). Assuming perfect conditions exist and continue, how many rabbits are there in 2.5 years (30 months)? What is happening with the population of the rabbits?

Here is what you need to do. For a 30 month period:

1. Track the number of baby bunnies the first pair have.

2. Track the number of baby bunnies the original bunnies babies have.

3. Track the number of baby bunnies the baby bunnies babies have.

4. You get the idea…

As part of your project…

· Do a month by month graph of the population

· Use an excel spreadsheet to total number of baby bunnies over the 30 months…

· Use the “Quadreg” function on your calculator to find a regression line. Show the table (include data in your table for only the first 24 months) that you use to determine the equation. Your table will need two lists (time and population) to be used for the regression function.

Make sure that you include:

· Both names on your project and that you include the percent of contribution for each member

· A graphic tracking of the growth (visual display of growth and numeric--with bi-monthly tracking)

· An approximation of the population over the 30 month period

· Regression formula along with table of data (include data only up to 24 months)

· Use the regression line to predict the population at 30 months (and compare with what you find) at 60 month

· A brief narrative discussing the different aspects as to why this growth can’t continue to grow in this manner and discuss what will happen to the growth

MrMrsandBaby · August 2014

Drop the class...drop it now.

Sorry, I'm pretty good at math but that is just too much for my brain. Where are our scientists?

pnwlover12 · August 2014

MrMrsandBaby said:

Drop the class...drop it now.

Sorry, I'm pretty good at math but that is just too much for my brain. Where are our scientists?

IKR?! I'm good at the basics and can deal with %'s and all that, but this shit is just too much for me. By the time I read the last step, I have forgotten the first step.

golfingdarwinfish · August 2014

I don't think my approach is the most efficient approach, so I'm going to ask DH - he loves things like this.

pnwlover12 · August 2014

golfingdarwinfish said:
I don't think my approach is the most efficient approach, so I'm going to ask DH - he loves things like this.

Thank you thank you thank you.

CrisDee · August 2014

Love it. To get info organize an excel chart to get all the info. I did it using the months on the left and the bunnies born in a specific week across the top. Then model their babies.

Assuming the initial pair are pregnant in month 1 and first babies are born month 2 it worked well.

So just looking at the first column it went p, 10, w, p, 10, ... Where p is pregnant and w is waiting. The first pair has 100 babies.

Week 2 babies = 10
The column would be , b (born), m (maturing), m, m, m, m, p, 50, w, p 50, w, p, 50, .... There are 400 babies

Week 3 and 4 no babies
Week 5 you have 10 babies from the first pair.

You should quickly see the pattern.

In total there are 35652 bunnies including the original 2.

pnwlover12 · August 2014

CrisDee said:
Love it. To get info organize an excel chart to get all the info. I did it using the months on the left and the bunnies born in a specific week across the top. Then model their babies.

Assuming the initial pair are pregnant in month 1 and first babies are born month 2 it worked well.

So just looking at the first column it went p, 10, w, p, 10, ... Where p is pregnant and w is waiting. The first pair has 100 babies.

Week 2 babies = 10
The column would be , b (born), m (maturing), m, m, m, m, p, 50, w, p 50, w, p, 50, .... There are 400 babies

Week 3 and 4 no babies
Week 5 you have 10 babies from the first pair.

You should quickly see the pattern.

In total there are 35652 bunnies including the original 2.

I'm mobile bumping at the moment so it doesn't make a ton of sense but as soon as I get to a desktop I'm going to try working with your #s and examples. Thank you for your input, I really appreciate it!

P.S.
I can't believe you like this kind of stuff!

CrisDee · August 2014

This assumes 4 week wait = 1month,
Babies are pregnant on the 1st day they are mature, first bunnies get pregnant first day of the study

BreandMikewedding · August 2014

What class are you taking? I have to do stuff like this for my marine biology class (only with sea animals). You know the marine biology class I have to take for my marketing degree. Ya! That makes sense.

Also remember, eventually their environment won't be able to support them and they will start dying off. They will run out of space and food. If that happens to.be a question you have to answer.

pinkshades05 · August 2014

Ooo, that is fun! I'm sure @CrisDee is correct but hard to visualize without an excel sheet.

golfingdarwinfish · August 2014

DH is building a spreadsheet lol

pnwlover12 · August 2014

golfingdarwinfish said:
DH is building a spreadsheet lol

Yes!!!! Can I buy him some golf tees or something?

nightowl1989 · August 2014

I wish I was on a computer right now...I love to play with this stuff. After Differential Equations, this stuff is like addition. Looks like PP have you covered though!

golfingdarwinfish · August 2014

pnwlover12 said:

DH is building a spreadsheet lol
Yes!!!! Can I buy him some golf tees or something?

We are arguing about it because I think we should set up the function/equation, but the assignments wants you to end with that rather than start with it.

CrisDee · August 2014

I think modelling it out in excel then doing the regression is what is being asked. Also, due to the restrictions it isn't a perfect equation. In my spreadsheet I used some simple formulae so that I could copy and paste the columns...plus a few sums here and there....

pnwlover12 · August 2014

CrisDee said:

I think modelling it out in excel then doing the regression is what is being asked. Also, due to the restrictions it isn't a perfect equation. In my spreadsheet I used some simple formulae so that I could copy and paste the columns...plus a few sums here and there....

( I'm horrible at excel! This is terrible news.

golfingdarwinfish · August 2014

CrisDee said:

I think modelling it out in excel then doing the regression is what is being asked. Also, due to the restrictions it isn't a perfect equation. In my spreadsheet I used some simple formulae so that I could copy and paste the columns...plus a few sums here and there....

Yes, it is what is being asked.

golfingdarwinfish · August 2014

pnwlover12 said:

CrisDee said:

I think modelling it out in excel then doing the regression is what is being asked. Also, due to the restrictions it isn't a perfect equation. In my spreadsheet I used some simple formulae so that I could copy and paste the columns...plus a few sums here and there....

( I'm horrible at excel! This is terrible news.

Ugh, he got frustrated in excel and went to python, which isn't going to help you. I'll try to get him back there.

My spreadsheet is a mess.

pnwlover12 · August 2014

golfingdarwinfish said:

pnwlover12 said:

DH is building a spreadsheet lol
Yes!!!! Can I buy him some golf tees or something?

We are arguing about it because I think we should set up the function/equation, but the assignments wants you to end with that rather than start with it.

Can I just say, I love that I have two scientist extraordinaires arguing over my lame math project?

Saragoeswest · August 2014

Glad y'all got a handle on things! I was over here doing the exponential growth equation. I am bad with spreadsheets. Y'all got it.

golfingdarwinfish · August 2014

CrisDee said:

Love it. To get info organize an excel chart to get all the info. I did it using the months on the left and the bunnies born in a specific week across the top. Then model their babies. Assuming the initial pair are pregnant in month 1 and first babies are born month 2 it worked well. So just looking at the first column it went p, 10, w, p, 10, ... Where p is pregnant and w is waiting. The first pair has 100 babies. Week 2 babies = 10 The column would be , b (born), m (maturing), m, m, m, m, p, 50, w, p 50, w, p, 50, .... There are 400 babies Week 3 and 4 no babies Week 5 you have 10 babies from the first pair. You should quickly see the pattern. In total there are 35652 bunnies including the original 2.

Did you assume that each female of each litter had 10 offspring, 5 of which are female, ad infinitum?

pnwlover12 · August 2014

golfingdarwinfish said:

CrisDee said:

Love it. To get info organize an excel chart to get all the info. I did it using the months on the left and the bunnies born in a specific week across the top. Then model their babies. Assuming the initial pair are pregnant in month 1 and first babies are born month 2 it worked well. So just looking at the first column it went p, 10, w, p, 10, ... Where p is pregnant and w is waiting. The first pair has 100 babies. Week 2 babies = 10 The column would be , b (born), m (maturing), m, m, m, m, p, 50, w, p 50, w, p, 50, .... There are 400 babies Week 3 and 4 no babies Week 5 you have 10 babies from the first pair. You should quickly see the pattern. In total there are 35652 bunnies including the original 2.

Did you assume that each female of each litter had 10 offspring, 5 of which are female, ad infinitum?

This is me
:-?

golfingdarwinfish · August 2014

pnwlover12 said:

golfingdarwinfish said:

CrisDee said:

Love it. To get info organize an excel chart to get all the info. I did it using the months on the left and the bunnies born in a specific week across the top. Then model their babies. Assuming the initial pair are pregnant in month 1 and first babies are born month 2 it worked well. So just looking at the first column it went p, 10, w, p, 10, ... Where p is pregnant and w is waiting. The first pair has 100 babies. Week 2 babies = 10 The column would be , b (born), m (maturing), m, m, m, m, p, 50, w, p 50, w, p, 50, .... There are 400 babies Week 3 and 4 no babies Week 5 you have 10 babies from the first pair. You should quickly see the pattern. In total there are 35652 bunnies including the original 2.

Did you assume that each female of each litter had 10 offspring, 5 of which are female, ad infinitum?

This is me
:-?

Basically that the sex ratio and # of offspring holds constant through the 30 months... Ad infinitum was a poor word choice on my part.

DH's s/s is out of control, so he's not doing it efficiently either. I'm not sure we are going to be of any help

You may want to build per Criss' suggestion.

pnwlover12 · August 2014

MrsCunningham22 said:

I don't have excel at home, I am missing all the fun :-<

Fun?! What is wrong with you people?!

I so appreciate all of you coming in and reading this mind-numbing post. The teammate I have for the project is just as clueless as I am.

golfingdarwinfish · August 2014

We got a smooth quadratic, but a lower final # than Criss.

golfingdarwinfish · August 2014

If you want to PM an e-mail address I can send you his file

pnwlover12 · August 2014

golfingdarwinfish said:

We got a smooth quadratic, but a lower final # than Criss.

I have no idea where to even begin. I'm listening to my instructor's collaborate session on this and he is rambling on and on and it has nothing to do with figuring out how to do the project. RAAAR.

pnwlover12 · August 2014

golfingdarwinfish said:

If you want to PM an e-mail address I can send you his file

Yes!! I'm doing so now, thank you!
:x

CrisDee · August 2014

I did it at work so can't see my spreadsheet. In excel, label monthss in the rows...(1-30) the columns will be birth week of bunnies (1-24). Above the label for the week you can have a sum of the bunnies born in appropriate week. (For ease I put the starting bunnies in w1 as nothing is born then.

pnwlover12 · August 2014

CrisDee said:

I did it at work so can't see my spreadsheet. In excel, label monthss in the rows...(1-30) the columns will be birth week of bunnies (1-24). Above the label for the week you can have a sum of the bunnies born in appropriate week. (For ease I put the starting bunnies in w1 as nothing is born then.

:x to you too!

CrisDee · August 2014

On my ipad...so not perfect...

Want a personalized experience?

Good at math? Help me!

Re: Good at math? Help me!

Choose Another Board

Search Boards