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

Calculating normalized standard deviation in rolling window [Closed]

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

1 reply

Answer 1 / 1

Subtract the population mean from the individual score, then dividing the Difference by the population standard deviation.
2
Thank you
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2942 users have said thank you to us this month

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?
Ask a question

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!