Previous Topic Next Topic

Calculating normalized standard deviation in rolling window

Closed
kurugfrancis - Dec 10, 2019 at 06:13 PM
 LamoIdiot5 - Dec 12, 2019 at 01:08 PM
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
Related:

1 response

Answer 1 / 1
LamoIdiot5
Dec 11, 2019 at 07:51 AM
Subtract the population mean from the individual score, then dividing the Difference by the population standard deviation.
2
kurugfrancis
Dec 11, 2019 at 07:54 AM
Thank you.
Please is there any code I can use because the data is a large sample size.
0
LamoIdiot5
Dec 11, 2019 at 04:54 PM
Which part of subtract and divide do you have issues with?
0
kurugfrancis
Dec 11, 2019 at 05:05 PM
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.
0
LamoIdiot5
Updated on Dec 11, 2019 at 05:31 PM
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.
0
LamoIdiot5 > LamoIdiot5
Dec 12, 2019 at 01:08 PM
Hello where did you go?
0

Similar discussions

How to calculate positions (1st,2nd,3rd...) in Excel
hardy -
TrowaD -

6 responses
Date formatting in dd/mm/yyyy
nisha -
appu -

11 responses
How to calculate position (1st,2nd,3rd) in excel....?
abdulwajid -
TrowaD -

1 response