Excel Polynomial Trendline Calculation

%3CLINGO-SUB%20id%3D%22lingo-sub-1727104%22%20slang%3D%22en-US%22%3EExcel%20Polynomial%20Trendline%20Calculation%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1727104%22%20slang%3D%22en-US%22%3E%3CP%3EWhat%20is%20the%20underlying%20process%20used%20by%20Excel%20to%20calculate%20the%20polynomial%20trendline%20for%20an%20x-y%20scatter%20plot%3F%20It%20gives%20you%20an%20equation%20y%3D%20ax%5En%20%2B%20....%20but%20I%20need%20to%20know%20the%20process%20Excel%20uses%20to%20get%20that.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1727104%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
New Contributor

What is the underlying process used by Excel to calculate the polynomial trendline for an x-y scatter plot? It gives you an equation y= ax^n + .... but I need to know the process Excel uses to get that.

0 Replies