•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Standard derivation of the last three data in a column
I have an excel sheet tracking the results in points of our hobby group and Id like to measure every members "consistency", so to speak, over i.e. the last three weeks with the use of the standard derivation.
I figured STDEV.P is the way to go, but havent had much luck with any concrete formulas.
I tried it with Index and counta, ultimately ending up with this:
=STDEV.P(INDEX([LA]; COUNTA([LA])-2; [LA]) ; [INDEX([LA]; COUNTA([LA]); [LA]]))
(with [LA] being the column Ive used as an example here), as well as a few other variations, but I couldnt get any of them to work.
Excel Version Student and Home 2019
Does anyone have any idea how I might be able to do this?
Many thanks!
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#standard derivation
#STDEV.P
#Excel
#INDEX
#COUNTA
#formula
#consistency
#data
#column
#hobby group
#points
#weeks
#Student and Home 2019
#sheet
#results
#variation
#member
#LA
#measure
#spreadsheet