I've got two time series (growth rates: what was the forecast for any particular year and what was actual growth rate for that year). I need to compare them to flag those most different. Actually I want to check the accuracy of the forecast. What would be the best function to do it?
Compare Time Series
-
-
-
Re: Compare Time Series
Without seeing how you have your data laid out & what bits you wish to compare it's difficult to offer a solution....
-
-
Re: Compare Time Series
Your file isn't of any help, since it doen't clarify what exactly you wish to accomplish. Are the figures given growth in % or absolute figures? What happened to REAL03 ?
-
Re: Compare Time Series
No idea either, expect to say use a PivotTable or Conditional Formatting.
You need to stop assuming we are all looking over you shoulder and familar with your needs.
-
-
Re: Compare Time Series
Sounds like you are looking for advice on how you would display "accuracy" of forecast v actual. It's not really an Excel Question, unless you need to know how to perfom such a statistical comparison in Excel.
With my background in Finance, I'd usually perform some form of correlation analysis on the data, i.e. the degree to which there is a 'linear relationship' between the two variables you are comparing. Displaying the results is usually pretty effective with scatter charts....
This article might help
Participate now!
Don’t have an account yet? Register yourself now and be a part of our community!