Hi all!
i would like to calculate the RMS of a sine wave, which i found can be done by this
my problem is: to calculate the rms-values for one period T = (lets say 1-10 rows and move T/2 =5rows), a half period down and calculate the rms again for 4095 values.
like this:
B1 =SQRT(SUMSQ(A1:A10)/COUNTA(A1:A10))
B2 =SQRT(SUMSQ(A1+5:A10+5)/COUNTA(A1+5:A10+5)) i want this
B3 =SQRT(SUMSQ((A1+5)+5:(A10+5)+5)/COUNTA((A1+5)+5:(A10+5)+5)) and this and so on...
COUNTA() can be set to a constant number i guess.
like a moving/sliding window with the size of 10 rows, moving down 5 rows each time (half it's size). (i can get it to move down one line/row at the time, "moving average")
hope you understand me ;)
thanks!
Bookmarks