help on getting formula for this

[miaco11]

Hi! I need help to simplify this process.

Is there a shortcut formula to get the average of % difference from one row to the next row in column A without me computing the difference of per row and then taking the average after?

e.g.
A (Amount) B (difference from lower to higher)
8840 1.26%
8730 1.28%
8620 1.29%
8510 1.31%
8400

1.28% Ave difference (i need to get shortcut formula for this)

Thank you very much!

 

[miaco11]

It is not possible to calculate true averages with percentages because each result is weighted depending on the size of the original data. ie What you are trying to achieve will only work if you want to work with the percentages rather than relate them to the original data.

I see. Thank you for this observation.

I'm using it to compare with the other columns to see if what I'm putting in as increments is ok for the structure or not. I'm not a statistician though so I cannot judge if its poor or not.

Again, thank you for this!

 

[miaco11]

Hopefully one will give you what you want :S

Regards
Adam

yes, i got what i want.

thanks again! :D