Forum Discussion
Usage average should have returned zero
Hi Folks, I am a bit puzzled why when using Average the result did not return (0) There is two examples: Example A: starts and ends with a value of 1000 and returns 0.027% Example B: ...
Don't know the application of this but you seem to be comparing two very different things.
Example A starts and ends with a value of 1000 but there are changes in between. The average that is computed in Example A is the average of the % change there is between each observation.
Example B always has 1000 as values in each observation and therefore, there is no % change between them. Consequently, when calculating the average % change amongst all observation it will be 0.
- You are probably right, it's just how I have been looking at it.
Thanks for viewpoint.
