# how do i find polynomial coefficients

I have created a graph, working in calc

First time here? Check out the FAQ!

how do i find polynomial coefficients

I have created a graph, working in calc

2

Hello,

- Select the data series within your chart by clicking one of the data points
`Right click -> Insert Trend Line ... -> Tab: Type`

- Select option
`[o] Polynomial`

and specify the*Degree* - Select option
`[x] Show Equation`

- Click
`OK`

(after some formatting of trend line and trend line equation for degree=2 polynomial)

You may use function `LINEST()`

to calculate the polynomial coefficients. To see how this works, check the following sample file:

C:\fakepath\PolynomialRegression.ods

Hope that helps

0

An `X-Y (Scatter) Chart`

[what comes next to what often is called a "graph" in mathematics or a "diagram" in many contexts] may show values (ordinates) belonging to a sample of abscissae. In this case we may assume the values to be approximately the values of a mathematical scalar function of one scalar (real) variable. Expecting this function to be polynomial of a given degree, we can order the software working behind the Chart, to estimate coefficients for the supposed function, or, in different words, to calculate such coefficients minimizing the result of a specific evaluating function concerning the aberrations.

In fact this is what must be done if a polynomial `Trend Line`

shall be inserted.

For the purpose the Chart software will use a widely applied mathematical method, and offer to also show the calculated coefficients in an additional object added to the chart.

The exactly same method is implemented by the function LINEST(). You can therefore get the coefficients without writing them off the mentioned object. However, you don't only need the abscissae themselves, but also their powers up to the chosen degree as the exponent.

If you urgently need coefficients for polynomial approximations often, I can provide (raw) **user code** (in Basic) calculating them without relying on helper columns or charts.

Asked: ** 2020-11-06 19:05:28 +0100 **

Seen: **108 times**

Last updated: **Nov 07 '20**

How do I export a chart in an image format from LibreOffice Calc? [closed]

Are there plans for a "papercut" project for libreoffice [closed]

Is it normal for Calc goal seek to take very long? [closed]

Please refine "Search" in Calc - implement functions in Gnumeric [closed]

LibreOffice Calc will not link to external data via internet [closed]

Is there a LibreOffice .odt, .ods viewer for Android? [closed]

Why is Calc so much slower at opening/saving files than MS-Office? (win7 x64) [closed]

Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.

Edityour question to explain your goal. A graph is not a mathematical object.What do you want? A polynomial which minimises some distance between the polynomial and your data at the sample points (e.g. minimising the sum of squares)? In this case which is the degree of the polynomial?

What is your skill in maths?