I don't know if this question belongs in this section, so sorry if it doesn't. This is about a number series.
I need to be able to take a number (R) and spread it out over a number of points (X) such that the final value is a multiple (Y) of the first value, and find the percentage change (Z) from value to value to make this possible.
Example: I want to spread the number 1000 out over 100 points. The last point needs to be 3.3x the first point. What is the percentage increase from point to point to create this distribution?
Any tips about software that can do this easily would be most appreciated. I'd love to have all the values displayed too so I can input them without stopping to calculate. This is for my job.
Thanks!
I need to be able to take a number (R) and spread it out over a number of points (X) such that the final value is a multiple (Y) of the first value, and find the percentage change (Z) from value to value to make this possible.
Example: I want to spread the number 1000 out over 100 points. The last point needs to be 3.3x the first point. What is the percentage increase from point to point to create this distribution?
Any tips about software that can do this easily would be most appreciated. I'd love to have all the values displayed too so I can input them without stopping to calculate. This is for my job.
Thanks!