Linear Regression choose which errors to minimise Y or X

Copper Contributor

Hi,

 

In much older versions of excel there was an option where you could select if you wanted to minimise Y errors or X errors. 

Does this option still exist?

 

swapping variables  (i.e. plot X vals on Y axis and Y vals on X axis) --> fitting a line -->  X=f(X) --> converting it manually into Y=g(x) is a pain.

 

thanks again,

Yannis

 

0 Replies