Calculating savings rate

If 5000 patients=3.9% savings and 5999=3.6%savings, what is the savings rate for 5456 patients, etc.? How to calculate the numbers in between?

Question

Calculating savings rate

If 5000 patients=3.9% savings and 5999=3.6%savings, what is the savings rate for 5456 patients, etc.? How to calculate the numbers in between?

amistre64 · Answer

this is just a linear function since it gives 2 points of reference

amistre64 · Answer

find the slope between the given "points" and determine the linear equation

amistre64 · Answer

x   :  y
---------
5999 : 3.6
5000 : 3.9  <- subtract
---------
  999 : -.3

slope = y/x = -.3/999

amistre64 · Answer

your equation becomes:

3.9 = 5000(-.3/999) + b

3.9 + (1500/999) = b

amistre64 · Answer

y = (-.1/333)x + 500/333 + 39/10

when x = 5456;  y = 3.76%

anonymous · Answer

Thanks a ton! Any advice on how to repeat this multiple times in excel?