Hello,

I need an equation that matches the attached graph. Please help. Data is below the graph.

Thanks,

Printable View

- Aug 13th 2011, 07:59 PMpieman91Find an equation from this graph.
Hello,

I need an equation that matches the attached graph. Please help. Data is below the graph.

Thanks, - Aug 13th 2011, 08:04 PMProve ItRe: Find an equation from this graph.
Since there are 40 points, it would fit a polynomial of order 39 exactly.

Let .

When you substitute each point, you'll get 40 equations in 40 unknowns which you can solve using technology or MUCH difficulty by hand. - Aug 13th 2011, 11:50 PMpieman91Re: Find an equation from this graph.
- Aug 14th 2011, 01:00 AMCaptainBlackRe: Find an equation from this graph.
- Aug 14th 2011, 02:56 AMpieman91Re: Find an equation from this graph.
Thanks for that. I don't want to seem nit-picky or ungrateful but y=16.467+0.004939x+0.00002781x^2 is just a bit too high for it to match the trendline and therefore I can't use it. I have attached a new graph that shows y=16.467+0.004939x+0.00002781x^2, the trendline and the actual tax percentage. And if that last data becomes an extreme outlier just get rid of it.

I really appreciate everyone's help with this and Captain Black, if you don't want to do it (fair enough), you can show me how to do it and then I can do it. - Aug 14th 2011, 06:43 AMCaptainBlackRe: Find an equation from this graph.
Well if it does not match there is probably a typo in my typing since it passed straight through the data when I was doing the fitting, unfortunately I am not on the machine with the file at present so I cannot check.

However the red curve in your document is not a plot of the quadratic (which is smooth)

Checking my notes, the typo is a wrong sign, it should be:

Also since you already have the equation of the trend line why are you continuing with this thread?

CB - Aug 14th 2011, 06:48 AMzzzoakRe: Find an equation from this graph.
You could use

**interpolation polynomial in the Lagrange form**:

Lagrange polynomial - Wikipedia, the free encyclopedia.

For example:

For k=2:

.

For p(x) you don't need to find k coefficients but you have k+1 terms of order k.

You could write a little program for p(x). - Aug 14th 2011, 03:36 PMpieman91Re: Find an equation from this graph.
The trendline is from excel but

**the polynomial of the trendline that excel gives me does not fit the data**. The trendline fits but its the wrong polynomial. The polynomial is the same shape but it does not fit the data. I would use it if it was the actual equation but its not. - Aug 14th 2011, 03:41 PMpieman91Re: Find an equation from this graph.