Array Statistics

[SDruley]

Ladies and Gentlemen,
I've never done this before but I need to find the standard deviation, mean, and slope of the last 5 points of a flat array. Code example is as follows:

Please Login or Register  to view this content.

There must be an easy way to do this. Any help appreciated

[venkat1926]

suppose the data is from A1 to A24

in A25(that is one cell after the last cell) type or copy this formula

=AVERAGE(INDIRECT("a"&ROW()-1):INDIRECT("a"&ROW()-5))

in A26 type or copy this formula

=STDEV(INDIRECT("a"&ROW()-2):INDIRECT("a"&ROW()-6))


I am attaching the file also.(I have also checked manually

sorry after completion I am wondering you are thinking of two columns dependent and independent series.

[SDruley]

venkat1926,

Well done