Share via

Excel - Reduce an Average

Anonymous
2016-08-17T00:10:10+00:00

If I have a weekly running average and I have a target goal, is there a way to figure by how much I need to reduce the weekly average over a period of time to hit my target goal?

For example, I have a target goal of 500, but my last four week's numbers are:

Week 1: 505

Week 2: 516

Week 3: 523

Week 4: 532

By week 10, I need to hit 500. If my rolling average is currently 523, how much do I need to reduce by week to hit this target in six weeks?

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

9 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2016-08-17T15:43:12+00:00

    Thanks Jim!

    Was this answer helpful?

    0 comments
  2. Anonymous
    2016-08-17T07:31:28+00:00

    Suppose you have 5 weeks. average for 4 weeks is 519. now you want to set week 5 somehow that the average for 5 weeks becomes 500.

    Go to data/solver and follow as the attached image.

    In set objective, select the average and set  "value of" to 500. in"By changing variable celss" select the 5th week.

    It will calculate the value of 5th week to get average to the value you want.

    Was this answer helpful?

    0 comments
  3. Deleted

    This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.

    Comments have been turned off. Learn more

  4. Anonymous
    2016-08-17T01:50:07+00:00

    Re: target average

    Column D must have a formula in all ten cells.

    Fill in a number in C9 and see what you get.

    '---

    Jim Cone

    Portland, Oregon USA

    https://goo.gl/IUQUN2 (Dropbox)

    Was this answer helpful?

    0 comments
  5. Anonymous
    2016-08-17T01:22:10+00:00

    Hello,

    By your target goal is 500 which you need to achieve in 10 weeks. So per week you need to achieve 500/10 = 50. But your current average is 523. So need to reduce 523 - 50 = 473 at least from per week.

    I think you should set your target by a contribution of previously average weekly achieving score.

    Was this answer helpful?

    0 comments