Discussion Linear Regression choose which errors to minimise Y or X in Excel
https://techcommunity.microsoft.com/t5/excel/linear-regression-choose-which-errors-to-minimise-y-or-x/m-p/679643#M32519
<P>Hi,</P><P> </P><P>In much older versions of excel there was an option where you could select if you wanted to minimise Y errors or X errors. </P><P>Does this option still exist?</P><P> </P><P>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.</P><P> </P><P>thanks again,</P><P>Yannis</P><P> </P>Sun, 09 Jun 2019 18:08:15 GMTyannis_rr2019-06-09T18:08:15ZLinear Regression choose which errors to minimise Y or X
https://techcommunity.microsoft.com/t5/excel/linear-regression-choose-which-errors-to-minimise-y-or-x/m-p/679643#M32519
<P>Hi,</P><P> </P><P>In much older versions of excel there was an option where you could select if you wanted to minimise Y errors or X errors. </P><P>Does this option still exist?</P><P> </P><P>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.</P><P> </P><P>thanks again,</P><P>Yannis</P><P> </P>Sun, 09 Jun 2019 18:08:15 GMThttps://techcommunity.microsoft.com/t5/excel/linear-regression-choose-which-errors-to-minimise-y-or-x/m-p/679643#M32519yannis_rr2019-06-09T18:08:15Z