root mean square

nmn · May 20th, 2002, 03:54 PM

I want to find the rms value of a series of numbers, say A1:A10. I can do this by using sqrt(average(B1:B10)), where the B column contains the squares of the values in the A column. What would really help me though, is if there was a way to do this without using a second column. Is this possible in excel 2000?

Al Chara · May 20th, 2002, 03:57 PM

Have you taken a look at SUMSQ, I think it is in the analysis toolpak.

nmn · May 20th, 2002, 04:06 PM

Figured it out:
SQRT(SUMSQ(A1:A10)/COUNTA(A1:A10))
Thanks Al!

May 20th, 2002, 03:57 PM	#2
Al Chara MrExcel MVP Join Date: Feb 2002 Location: Monterrey, Mexico Posts: 1,433	Have you taken a look at SUMSQ, I think it is in the analysis toolpak. __________________ Kind regards, Al Chara

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 20th, 2002, 03:54 PM	#1
nmn New Member Join Date: May 2002 Posts: 2	I want to find the rms value of a series of numbers, say A1:A10. I can do this by using sqrt(average(B1:B10)), where the B column contains the squares of the values in the A column. What would really help me though, is if there was a way to do this without using a second column. Is this possible in excel 2000?

May 20th, 2002, 04:06 PM	#3
nmn New Member Join Date: May 2002 Posts: 2	Figured it out: SQRT(SUMSQ(A1:A10)/COUNTA(A1:A10)) Thanks Al!