polynomials

Hi all, I hope someone may be able to point me in the right direction. I have plotted data points from a pdf and created a spreadsheet, from this spreadsheet i have created an scatter graph of the pdf. The torque values are determined by the speed of an electric brake and the current output...

Hi, I'm currently working on a UDF (user-defined function) in MS excel, which enables the user to determine what values of x satisfy an equation. I've seen code like this previously on websites such as https://newtonexcelbach.wordpress.com/2011/01/13/solving-higher-order-polynomials/ but the...

Hello, I have a spreadsheet where I input values and then these values are graphed into a 3rd degree polynomial. The equation of the polynomial is displayed on the graph. I'd like to make it to where the values of the constants are transcribed into separate cells. I've put the spreadsheet...

Hi all, Apologies if this question seams disjointed but I am having trouble organising my thoughts. I've decided just to put what I can into words a hope someone can help. I have a cumulative data set as follows. I have graphed this data and created a 3rd order polynomial regression equation...

I am trying to create a trendline for multiple series. Is there a way to "create trendline for all series"? I have also tried to use the linest function to get the trendlines but it does not work because I have gaps in my data. Below is an example of my data which I would like to create a...

I have produced a simple line chart, put in a trend line and asked for the equation. The R2 is > 0,99. However, when I try to guess the values of Y, using the coefficients and a specific X, the result is incorrect. I have tried fitting a very specific curve, with 5 polynomial terms, and am...