# Calculate Monthly Numbers from Monthly Averages

1. ## 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. ## Re: Calculate Monthly Numbers from Monthly Averages

Almost certainly.

3. ## 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?

4. ## Re: Calculate Monthly Numbers from Monthly Averages

Originally Posted by meyero90
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. ## 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 ?

6. ## Re: Calculate Monthly Numbers from Monthly Averages

Originally Posted by meyero90
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. ## 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.

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

#### 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