Saturday, December 8, 2012

yogi_Compute Average Of Differences Between Successive Entries (D2-C2) (E2-D2) For Unspecified Number Of Columns

                                          Google Spreadsheet   Post  #918
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI    Dec 8, 2012
user Chris Chalhoub said:(!category-topic/docs/spreadsheets/67AgtCq68H8)
Average increase of a series of numbers
Hey guys, I am on chrome on windows ad I am trying to do something and it seems impossible to do it simple. I am trying to find out the average increase between a string of numbers that ether is static (easy enough... 0) or that ONLY increases.

For example I have a row that has the following numbers in columns from left to right (A2:H2) 137,155,174,192,210,228,247,274

I would like to find a simpler way than going =((b2-a2)+(c2-b2)+(d2-c2)....)/8

is this my only option or is there a shorter way to do this or should I prepare to write this for each row I will have in my sheet (many...)

following is a solution to a bit more generalized problem