You are here:

Advanced Math/Excel Equation


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

All Answers

Answers by Expert:

Ask Experts


Sombra Shadow


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.

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

©2017 All rights reserved.