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