I have seen a coupl posts regarding predictive formulas, usually using TREND or FORECAST. They are based on trying to find a single future value based on historical info. I have a different ciscumstance, and have tried approaches using the above functions, as well as LINEST and others. Here is the issue:
Example data:
1/1 1/8 1/15 1/22 1/29
12.3 12.2 12.0 11.7 11.5
The actual data would likely be over a 6-12 month period based on weekly results.
WHAT I NEED os to figure the likely future date at which the figure is <=11.0. The result could be either a Gregorian date or delta time (preferable).
Any ideas on how to formulate this?
Gene Marsh
Example data:
1/1 1/8 1/15 1/22 1/29
12.3 12.2 12.0 11.7 11.5
The actual data would likely be over a 6-12 month period based on weekly results.
WHAT I NEED os to figure the likely future date at which the figure is <=11.0. The result could be either a Gregorian date or delta time (preferable).
Any ideas on how to formulate this?
Gene Marsh
