"Ben" wrote in message
oups.com...
Jerry, i do not understand the usage of average(Y-X).
As Y-X is just a value, taking the average of it does nothing.

Assuming that you have more than one data point, then you presumably have
more than one value for Y-X to average?

That is why Jerry said:
"If you want to force a regression to have a slope of 1 (as your subject
implies), then use AVERAGE(yData-xData) for the intercept. This is an array
formula that must be array entered (Ctrl-Shift-Enter)."
--
David Biddulph