+ Reply to Thread
Results 1 to 3 of 3

calculate monthly average percentage of change

  1. #1
    vikgarden
    Guest

    calculate monthly average percentage of change

    Not sure how to do this, If I have a range of numbers, (50, 55, 75, 100)
    Percentage of increase is (10%, 36%, 33%)
    Average monthly increase is 26%

    How do I get excel to calculate the above?




  2. #2
    CarlosAntenna
    Guest

    Re: calculate monthly average percentage of change


    If you have your data in column A

    50
    55
    75
    100

    In b2 enter =a2/a1-1
    fill down the column
    In b5 enter =average(b2:b5)
    format column B as percentage

    -- Carlos


    "vikgarden" <vikgarden@discussions.microsoft.com> wrote in message
    news:0E4A1F83-B7A5-41BB-A16A-DA2E7C455BFD@microsoft.com...
    > Not sure how to do this, If I have a range of numbers, (50, 55, 75, 100)
    > Percentage of increase is (10%, 36%, 33%)
    > Average monthly increase is 26%
    >
    > How do I get excel to calculate the above?
    >
    >
    >




  3. #3
    JE McGimpsey
    Guest

    Re: calculate monthly average percentage of change

    Assuming you data is in A1:A4, one way:

    B2: =A2/A1-1 ====> 10%
    B3: =A3/A2-1 ====> 36.36%
    B4: =A4/A3-1 ====> 33.33%

    If by "average monthly increase" you mean the average of the individual
    monthly increases, that's just

    =AVERAGE(B2:B4) ===> 26.57%

    OTOH, if by "average monthly increase" you mean the constant monthly
    increase that, when applied to 50, yields 100 after 3 months, then use

    =(A4/A1)^(1/3) - 1 ==> 25.99%



    In article <0E4A1F83-B7A5-41BB-A16A-DA2E7C455BFD@microsoft.com>,
    vikgarden <vikgarden@discussions.microsoft.com> wrote:

    > Not sure how to do this, If I have a range of numbers, (50, 55, 75, 100)
    > Percentage of increase is (10%, 36%, 33%)
    > Average monthly increase is 26%
    >
    > How do I get excel to calculate the above?


+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1