How to calculate the increasing point if known variables are sum of total increase points and the first point.
For example, I have the first number of 1000, and I have 37 points until the last one. Sum of all points should be 107300.
So I have to calculate what number I need to add to every increasing point.
Example:
1st increasing point: 1000 + 100 = 1100
2nd increasing point: 1100 + 100 = 1200
...
37th increasing point: = 4600 + 100 = 4700
I need to know how to calculate this increasing number (100), as I only know the sum of all points is 107300 and the first point is 1000.
EDIT: I'll explain with my chart example. I have an xy axis in which y represents total bookings and x represents month. So I have set goal that I would like to have 107300 bookings in that 37 months. Currently I have 1000 bookings, and I need to calculate for what number my bookings needs to be increased for every month so I could reach 107300 bookings in 37 months.
editand use MathJax and improve the body of the post instead of commenting. – Lee David Chung Lin Apr 14 '19 at 21:57