However, you can easily make more digits visible. By default, the numbers in the trendline equation are rounded to 2 - 4 decimal places. If the Excel trendline equation delivers inaccurate results when you supply x values to it manually, most likely its because of rounding. If you need more assistance, please attach an example Excel file with representative data that demonstrates the problem that you perceive. How to create a custom trendline When none of the trendline options (exponential, linear, logarithm, polynomial, power) fit well, can a different formula be used If not, can the same be achieved by plotting a custom formula with coefficients adjusted to minimise R-squared View best response Labels: Charting Excel 44. Show more digits in the trendline equation.

for X values outside the original range), often the trendline formula 'blows up', taking wildly unexpected turns (literally). However, also note that most polynomial trendlines are useful only for interpolating estimated Y values. A1:G1), and array-enter (press ctrl+shift+Enter instead of just Enter) a formula of the form: I am an intermidate EXCEL (version 15. For example, select 7 consecutive horizontal cells (e.g. The m-values are coefficients corresponding to each x-value, and b is a constant value. But if all of the coefficients are 'close' in magnitude, you might use Number with sufficient decimal places.Įven better: Use LINEST to generate the coefficients. if there are multiple ranges of x-values, where the dependent y-values are a function of the independent x-values. That works regardless of the magnitude of the coefficients.

I prefer Scientific with 14 decimal places. Hans Vogelaar I finally took a good look at the trendline & formula and got to use the polynomial formula y index (linest (. If you copying the coefficient from the trendline label, be sure to format the TL to display 15 significant digits. You can use TREND for polynomial curve fitting by regressing against the same variable raised to different powers. Re: ``I am using the polynomial given to me in the trendline, 6th order but it does not compute properly`` TREND (knowny's, knownx's, newx's, const) The TREND function syntax has the following arguments: Remarks For information about how Microsoft Excel fits a line to data, see LINEST.

Power trendline equation in excel