Home

Linear Regression choose which errors to minimise Y or X

%3CLINGO-SUB%20id%3D%22lingo-sub-679643%22%20slang%3D%22en-US%22%3ELinear%20Regression%20choose%20which%20errors%20to%20minimise%20Y%20or%20X%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-679643%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIn%20much%20older%20versions%20of%20excel%20there%20was%20an%20option%20where%20you%20could%20select%20if%20you%20wanted%20to%20minimise%20Y%20errors%20or%20X%20errors.%26nbsp%3B%3C%2FP%3E%3CP%3EDoes%20this%20option%20still%20exist%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eswapping%20variables%26nbsp%3B%20(i.e.%20plot%20X%20vals%20on%20Y%20axis%20and%20Y%20vals%20on%20X%20axis)%20--%26gt%3B%20fitting%20a%20line%20--%26gt%3B%26nbsp%3B%20X%3Df(X)%20--%26gt%3B%20converting%20it%20manually%20into%20Y%3Dg(x)%20is%20a%20pain.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ethanks%20again%2C%3C%2FP%3E%3CP%3EYannis%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-679643%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
yannis_rr
Occasional Visitor

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

 

Related Conversations
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
2 Replies
Early preview of Microsoft Edge group policies
Sean Lyndersay in Discussions on
65 Replies
*Updated 9/3* Syncing in Microsoft Edge Preview Channels
Elliot Kirk in Articles on
202 Replies