Results 1 to 2 of 2

How to Determine Averages of Increments

Threaded View

  1. #1
    Registered User
    Join Date
    09-09-2009
    Location
    USA
    MS-Off Ver
    Excel 2003
    Posts
    3

    How to Determine Averages of Increments

    Alright, here's the situation. I have 24 months of sales information in which most of the time the month in question increased sales over the month prior. So 24 numbers in a line with most numbers higher than the one before it.

    I need to find the average monthly incrimental value for those 24 months.

    What would be a faster way to do it through excel than manually find the difference for each of the 23 pairs of months, add those up, and divide by 23? Is there any way to make a function or a couple of functions to speed up the process?
    Last edited by MrDeath; 09-09-2009 at 10:45 PM.

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