1. ## Statistics formula

Hi Group,
I am writing seeking help with a math problem. I am math ignorant. I volunteer at spay/neuter clinics to try and cut down on the puppy/kitten population. I would like to get a math formula to show our efforts as we move forward.
Given the following information can anyone create a spread sheet with formulas so if we enter 48 cats* or 71 dogs it would calculate the totals births prevented. It does not have to precise but maybe with in 10% +/- even 50% survival rate.
Given the following info.

Why is spaying and neutering important? Did you know that:
In 7 years, 1 unspayed female dog and her offspring can produce over 4,000 dogs?
In 9 years, 1 unspayed female cat, her unneutered mate, and all their offspring can produce over 11,606,077 cats?
To put it simply, spaying and neutering reduces the population of unwanted and homeless animals in the world.
Source of data
It's My Life . Family . Pets . Spaying and Neutering | PBS Kids GO!

Thank You so much if you can assist us.
Alice Johnston

2. Originally Posted by Alicehelps
Hi Group,
I am writing seeking help with a math problem. I am math ignorant. I volunteer at spay/neuter clinics to try and cut down on the puppy/kitten population. I would like to get a math formula to show our efforts as we move forward.
Given the following information can anyone create a spread sheet with formulas so if we enter 48 cats* or 71 dogs it would calculate the totals births prevented. It does not have to precise but maybe with in 10% +/- even 50% survival rate.
Given the following info.

Why is spaying and neutering important? Did you know that:
In 7 years, 1 unspayed female dog and her offspring can produce over 4,000 dogs?
In 9 years, 1 unspayed female cat, her unneutered mate, and all their offspring can produce over 11,606,077 cats?
To put it simply, spaying and neutering reduces the population of unwanted and homeless animals in the world.
Source of data
It's My Life . Family . Pets . Spaying and Neutering | PBS Kids GO!

Thank You so much if you can assist us.
Alice Johnston
Did I ask the wrong question in the wrong forum? No one offered help.
Thanks
Alice

3. Originally Posted by Alicehelps
Did I ask the wrong question in the wrong forum? No one offered help.
Thanks
Alice
To date, it's not the sort of question that someone with the appropriate expertise has either:

1. seen, or

4. Originally Posted by mr fantastic
To date, it's not the sort of question that someone with the appropriate expertise has either:

1. seen, or

Thank you for replying. I will look else where for help. I am sure someone with greater math skills than I can write a formula.
Alicehelps

5. It is impossible to derive a formula for this without more information given. We need to know how they based those first numbers you gave.

Imagine me saying this:

In the year 2000, the most popular ice cream was chocolate.
In 2010, it was strawberry.

Make a formula/spreadsheet that will allow me input the year and output what the favorite ice cream flavor will be.

As ridiculous as this example sounds, it's not too far off from what you are asking.

6. Originally Posted by Alicehelps
Hi Group,
I am writing seeking help with a math problem. I am math ignorant. I volunteer at spay/neuter clinics to try and cut down on the puppy/kitten population. I would like to get a math formula to show our efforts as we move forward.
Given the following information can anyone create a spread sheet with formulas so if we enter 48 cats* or 71 dogs it would calculate the totals births prevented. It does not have to precise but maybe with in 10% +/- even 50% survival rate.
Given the following info.

Why is spaying and neutering important? Did you know that:
In 7 years, 1 unspayed female dog and her offspring can produce over 4,000 dogs?
In 9 years, 1 unspayed female cat, her unneutered mate, and all their offspring can produce over 11,606,077 cats?
To put it simply, spaying and neutering reduces the population of unwanted and homeless animals in the world.
Source of data
It's My Life . Family . Pets . Spaying and Neutering | PBS Kids GO!

Thank You so much if you can assist us.
Alice Johnston
Another reason that you may have had no useful responses is the the question is vague. Exactly what do you want to show on this spreadsheet?

The number of birth prevented by a single spaying of neutering is infinite (under the model assumed by your sources). So you need to specify at what time in the future you want the data.

Now if you told us exactly what you want this spreadsheet to show it is quite likely that we could give you the required formulae to generate it.

CB

7. Originally Posted by CaptainBlack
Another reason that you may have had no useful responses is the the question is vague. Exactly what do you want to show on this spreadsheet?

The number of birth prevented by a single spaying of neutering is infinite (under the model assumed by your sources). So you need to specify at what time in the future you want the data.

Now if you told us exactly what you want this spreadsheet to show it is quite likely that we could give you the required formulae to generate it.

CB
Thanks,
I guess I thought if the births of one unfixed pair of dogs or cats offspring could be figured in 7 or 9 years if we could enter 99 or 400 it would give a ballpark figure of the births prevented in the same time frame.
Sorry I could not be more specific in asking for help and thought the data they used would work for me.
Thanks
Alice