Hi all
i have a lot of data that i am gathering every week and i want to plot the deviation of it over a set rolling 60 points so we can see step changes. i want to end up been able to plot a chart like the one attached. what i need is a way of calculating the standard deviation every 60 points so ideally P1:P60 show the average deviation of H1 against J1, then P61:P120 show the standard deviation of H61 against J61 so i can chart it like the attached.
Then i can calculate the upper and lower deviation in Q and R
Bookmarks