Results 1 to 3 of 3
  1. #1
    3 Star Lounger
    Join Date
    Sep 2002
    Posts
    210
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Weighted moving averages formula (2k/SR 1)

    If anyone could translate the attached formula for Excel, I would really appreciate it. I am not quite up to this level yet in creating them.

    A weighted moving average is calculated by defining weight factors, W1, W2,... Wn, for each day in the n day moving average. The weighted moving average for day d is then: ATTACHED JPG FILE

    Thanks.
    Pooja

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Weighted moving averages formula (2k/SR 1)

    I have attached a simple example. Column A contains dates, and column B corresponding sales data. The first row contains column headings.
    We want to calculate a 5-day weighted moving average. Cells G2 to G6 contain the weights.
    In cell C2, enter this formula: =SUMPRODUCT($G$2:$G$6,B2:B6)/SUM($G$2:$G$6)
    The $ signs in $G$2:$G$6 mean that this is an absolute reference, it won't change if you copy the formula down, while B2:B6 is relative; if you copy it down, it will change to B3:B7, then B4:B8 etc.

  3. #3
    3 Star Lounger
    Join Date
    Sep 2002
    Posts
    210
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Weighted moving averages formula (2k/SR 1)

    Wow, that totally works! Thank you so much.

    Pooja

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •