+ Reply to Thread
Results 1 to 7 of 7

Calculate Monthly Numbers from Monthly Averages

  1. #1
    Registered User
    Join Date
    08-05-2010
    Location
    Orlando, FL
    MS-Off Ver
    Excel 2003
    Posts
    3

    Calculate Monthly Numbers from Monthly Averages

    I have a series of trailing 3 month averages. I want to calculate the actual number for each of the months. Is this possible?

  2. #2
    Forum Expert sweep's Avatar
    Join Date
    04-03-2007
    Location
    Great Sankey, Warrington, UK
    MS-Off Ver
    2003 / 2007 / 2010 / 2016 / 365
    Posts
    3,411

    Re: Calculate Monthly Numbers from Monthly Averages

    Almost certainly.

    Is it possible to get a little more information about the worksheet and data you're using?
    Rule 1: Never merge cells
    Rule 2: See rule 1

    "Tomorrow I'm going to be famous. All I need is a tennis racket and a hat".

  3. #3
    Forum Contributor meyero90's Avatar
    Join Date
    03-24-2010
    Location
    New York
    MS-Off Ver
    Excel 2007
    Posts
    202

    Re: Calculate Monthly Numbers from Monthly Averages

    No, I think there's no way you could possibly do that. Do you mean you have 3 month average reported to you without knowing what are the data points used for the calculation? If yes, you can't possibly determine the data points that will return this average. Why do you want to know that?
    If I helped, Don't forget to add to my reputation (click on the little scale)
    Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)

  4. #4
    Registered User
    Join Date
    08-05-2010
    Location
    Orlando, FL
    MS-Off Ver
    Excel 2003
    Posts
    3

    Re: Calculate Monthly Numbers from Monthly Averages

    Quote Originally Posted by meyero90 View Post
    No, I think there's no way you could possibly do that. Do you mean you have 3 month average reported to you without knowing what are the data points used for the calculation? If yes, you can't possibly determine the data points that will return this average. Why do you want to know that?
    That is correct. I'm being provided with 3 month averages each month and I need to determine what the actual number is for any given month. Sounds like it's not possible. Below is an example.

    3 month average:

    January - 15

    February - 18

    March - 19

    April - 16

    May - 15

    Is there a way to determine the actual number for each of the months?

  5. #5
    Forum Contributor meyero90's Avatar
    Join Date
    03-24-2010
    Location
    New York
    MS-Off Ver
    Excel 2007
    Posts
    202

    Re: Calculate Monthly Numbers from Monthly Averages

    What are the averages numbers you have for these dates. I think with a system of equations we can obtain your data points for the desired dates.....when you wrote
    May - 15
    did you mean May = 15 ?
    Last edited by meyero90; 08-05-2010 at 11:30 AM.

  6. #6
    Registered User
    Join Date
    08-05-2010
    Location
    Orlando, FL
    MS-Off Ver
    Excel 2003
    Posts
    3

    Re: Calculate Monthly Numbers from Monthly Averages

    Quote Originally Posted by meyero90 View Post
    What are the averages numbers you have for these dates. I think with a system of equations we can obtain your data points for the desired dates.....when you wrote did you mean May = 15 ?
    Yes, 15 was the three month average of March, April and May. Each of these numbers represents the trailing 3-month average for that month.

  7. #7
    Forum Contributor meyero90's Avatar
    Join Date
    03-24-2010
    Location
    New York
    MS-Off Ver
    Excel 2007
    Posts
    202

    Re: Calculate Monthly Numbers from Monthly Averages

    you know I think it's not possible unless we make some assumptions...like how many data points are calculated for each month averages... like May average could be the result of 4 data points divided by 4 or x data points divided by x....you see what I mean....so I think we can't do it.

+ 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