Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I calculate the Root Mean Square (RMS)
|
#2
|
|||
|
|||
=SQRT(AVERAGE(A1:A5^2))
array entered (ctrl+shift+enter) where A1:a5 is the range where the number range exists "aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa" <aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa@discussi ons.microsoft.com wrote in message ... |
#3
|
|||
|
|||
aaaaaaaaaaaaaaaaaaaaaaaaaa,
You need to know the values you're wanting the RMS of. If this is electronics, where RMS is virtually completely misunderstood, you need to say what the waveform is (sine, square, program material, or what), and what you know about it (peak value, average value, etc.). -- Earl Kiosterud www.smokeylake.com/ ------------------------------------------- "aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa" <aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa@discussi ons.microsoft.com wrote in message ... |
#4
|
|||
|
|||
Thank you for providing an informative subject line, but it usually
helps to elaborate in the body of the post. As Earl noted, the most obvious elaboration would be RMS of what? If this is a regression question, you would use =INDEX(LINEST(yData,xData,const,TRUE),3,2) Jerry |
#5
|
|||
|
|||
Jerry,
thank you for your response. You have right, it is a regression question but I need the RMS for the line of equality and not for the trend line. Is the function you proposed the proper one for my case? "Jerry W. Lewis" wrote: Thank you for providing an informative subject line, but it usually helps to elaborate in the body of the post. As Earl noted, the most obvious elaboration would be RMS of what? If this is a regression question, you would use =INDEX(LINEST(yData,xData,const,TRUE),3,2) Jerry |
#6
|
|||
|
|||
What do you mean by "line of equality"?
Jerry aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa wrote: Jerry, thank you for your response. You have right, it is a regression question but I need the RMS for the line of equality and not for the trend line. Is the function you proposed the proper one for my case? "Jerry W. Lewis" wrote: Thank you for providing an informative subject line, but it usually helps to elaborate in the body of the post. As Earl noted, the most obvious elaboration would be RMS of what? If this is a regression question, you would use =INDEX(LINEST(yData,xData,const,TRUE),3,2) Jerry |
#7
|
|||
|
|||
by "Line of equality" I mean the line x=y. I have the regression set (x, y)
and I want the RMS considering that the fit line is the line of equality. Is it possible? "Jerry W. Lewis" wrote: What do you mean by "line of equality"? Jerry aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa wrote: Jerry, thank you for your response. You have right, it is a regression question but I need the RMS for the line of equality and not for the trend line. Is the function you proposed the proper one for my case? "Jerry W. Lewis" wrote: Thank you for providing an informative subject line, but it usually helps to elaborate in the body of the post. As Earl noted, the most obvious elaboration would be RMS of what? If this is a regression question, you would use =INDEX(LINEST(yData,xData,const,TRUE),3,2) Jerry |
#8
|
|||
|
|||
If by RMS you mean RMSE, the estimated standard deviation about the
regression line, the sum of squares for error would be =SUMSQ(y-x) with n-1 degrees of freedom for an assumed model of of y=x. This is an array formula, that must be array entered (Ctrl-Shift-Enter). Thus the RMSE would be =SQRT(SUMSQ(y-x)/(COUNT(y)-1)) which also must be array entered. Jerry aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa wrote: by "Line of equality" I mean the line x=y. I have the regression set (x, y) and I want the RMS considering that the fit line is the line of equality. Is it possible? "Jerry W. Lewis" wrote: What do you mean by "line of equality"? Jerry aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa wrote: Jerry, thank you for your response. You have right, it is a regression question but I need the RMS for the line of equality and not for the trend line. Is the function you proposed the proper one for my case? "Jerry W. Lewis" wrote: Thank you for providing an informative subject line, but it usually helps to elaborate in the body of the post. As Earl noted, the most obvious elaboration would be RMS of what? If this is a regression question, you would use =INDEX(LINEST(yData,xData,const,TRUE),3,2) Jerry |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Does excel have a 'cubed root' function? How can it work it out? | Excel Worksheet Functions | |||
square root function in excel (roots greater than 12) | Excel Discussion (Misc queries) | |||
Root mean square (RMS) error formula | Excel Worksheet Functions | |||
Not able to calculate. | Excel Worksheet Functions | |||
How do you calculate the nth root of a number in Excel 2003? | Excel Worksheet Functions |