You are here:

- Home
- Science
- Mathematics
- Advanced Math
- Excel Equation

Advertisement

I am trying to figure out the correct format for this equation for an excel spreadsheet that is also going to be a graph.

I need to figure out how fast the population would decline if we were to start eating people.

people would be converted into wafers which would cause a 95% loss of calories.

one person is 350000 calories, and 5% of that is 17500 calories. Which means one wafer contains 17500 calories, which can feed 8.75 people pertaining to a 2000 calorie diet.

I need to put all of this in an equation and im just lost at how to format it

Hi, I am going to answer this question from a purely mathematical approach and I hope it helps. If you still need help with the excel spreadsheet I highly recommend Scott for that.

Let n = the number of days the population can exist under the conditions given, then y (n) - (y (n)/8.75) = y (n-1) where y (n) is read y sub n and y sub n is the initial population on day 1 and hence y (n-1) is the new population on the 2nd day. You will count down n days because that is when you can no longer feed the population to itself.

y (n-1) - (y (n-1)/8.75)=y (n-2) the new population on day 3

y (n-2) - (y (n-2)/8.75)=y (n-3) the new population on day 4

.

.

.

y (1)-(y (1)/8.75)=y (0) the population on the day when the population can no longer feed itself

I hope this makes sense to you.

Math Prof

Advanced Math

Answers by Expert:

I can answer most questions up through Calculus and some in Number Theory and Abstract Algebra.

I have had my Bachelor's Degree since 1987 and have been a teacher since 1988. I earned my Masters Degree in Mathematics May 2010. I have been teaching at the same community college since 2002.**Education/Credentials**

I have taught 12 years at the community college level, medical college, and technical college as well as a high school instructor and alternative education instructor and charter school instructor.**Awards and Honors**

Master's GPA 3.56
Bachelor's GPA 3.34
Post grad work not degree related GPA 4.0