Menu
  1. Accueil
  2. Tech Forum
  3. Office Software
  4. Excel

Calculating normalized standard deviation in rolling window

Report
-
 LamoIdiot5 -
Hello,

Please how do I calculate normalized standard deviation in a rolling window for positive and negative values?

System Configuration: Windows / Chrome 78.0.3904.108
See more

1 reply

Answer 1 / 1

Subtract the population mean from the individual score, then dividing the Difference by the population standard deviation.
Report

Thank you.
Please is there any code I can use because the data is a large sample size.
Report

Which part of subtract and divide do you have issues with?
Report

I want to calculate it within a given interval. I want to calculate for three years rolling window, because I am using three years to calculate for one standard deviation point at the same normalizing it so that the value will be between 0 to 100.
Report

Ok. Find the mean of all values.
Subtract that number from your data point. You should have a measurement for each MOMENT IN TIME. Do you understand so far?

Now, take those .new measurements, and square each one. Find the mean of the new squared values. Take that new mean, and find the square root. That is the deviation.
Report
> LamoIdiot5
Hello where did you go?
Reply Ask a question

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!