Forum Discussion

yannis_rr's avatar
yannis_rr
Copper Contributor
Jun 09, 2019

Linear Regression choose which errors to minimise Y or X

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

 

No RepliesBe the first to reply