I have a series of trailing 3 month averages. I want to calculate the actual number for each of the months. Is this possible?
I have a series of trailing 3 month averages. I want to calculate the actual number for each of the months. Is this possible?
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".
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)
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?
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 wrotedid you mean May = 15 ?May - 15
Last edited by meyero90; 08-05-2010 at 11:30 AM.
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)
Bookmarks