statistics formula for daily goal to reach end of month goal.

[budzique]

[solved]statistics formula for daily goal to reach end of month goal.

d=daily amount to reach goal

t=total days
r=remaining days
m=Month to date average
g=month goal

Solve for d!

I need to calculate the daily stats to reach a goal, consider the month goal of 18, so far mtd average is 21, and there are 5 remaining days, and 17 total days in the month. So:
t=17
r=5
m=21
g=18

what formula do I use to calculate d?

 

[Deleted member 4993]

d=daily amount to reach goal

t=total days
r=remaining days
m=Month to date average
g=month goal

Solve for d!

I need to calculate the daily stats to reach a goal, consider the month goal of 18, so far mtd average is 21, and there are 5 remaining days, and 17 total days in the month. So:
t=17
r=5
m=21
g=18

what formula do I use to calculate d?

If your g = 18 and the month has 21 days - what is the total amount for whole month? (Mg = 18*21)

If r = remaining days → how many days of the month has already been accounted for? (Da = 17 - r)

If m=Month to date average → how much of the monthly goal you have already accomplished? (Ac = m * Da)

What is the amount left to reach the monthly goal? (L = Mg - Ac)

d = L/r

 

[budzique]

If your g = 18 and the month has 21 days - what is the total amount for whole month? (Mg = 18*21)

If r = remaining days → how many days of the month has already been accounted for? (Da = 17 - r)

If m=Month to date average → how much of the monthly goal you have already accomplished? (Ac = m * Da)

What is the amount left to reach the monthly goal? (L = Mg - Ac)

d = L/r

This is what I came up with:

((g*t)-(m*(t-r)))/r

Which is basically the exact same is what you said. Great minds. Thanks!