Hi, I have a dataset of score and score percentile. I would like to get score top 10 percent, top 20 percent, top 30 percent etc.'s standard deviation (top 10 percent of scores means 100% - 90% score percentile, top 20 percent of scores means 100% - 80% score percentile etc.).
Calculated function StDev can only give me the standard deviation of score percentile 100% - 90%, score percentile 90% - 80%, score percentile 80% - 70% etc. but not the cumulative percentile standard deviation that I need.
Is there a way to get the running standard deviation?
Hi Alex, my question is to calculate running standard deviation calculation but not percentile. I have score percentile column in my dataset. Will send over my sample dataset. Thank you.