Polynomial function

Hi guys,

Someone please help.

I have plotted a graph which compares the miles done with the petrol used.

I'm trying find a formula which allows me to apply the petrol and would give me the miles covered.

From excel I have applied the tread line of polynomial and obtained the following formula...

y = 1E-06x5 - 0.0002x4 + 0.0161x3 - 0.4893x2 + 7.5295x - 20.87

Rē = 0.9989

When is it applied to excel with the value of petrol it does not give me the miles.
I'm working out the formula in a incorrect manner??

I have attached the excel file.

Thanks

Thanks

How to I put the formula into a cell?

y = 1E-06x5 - 0.0002x4 + 0.0161x3 - 0.4893x2 + 7.5295x - 20.87
Rē = 0.9989


What do I replace the "E" with?

From the file I would like to fine the miles for petrol 25.1883984 the formula should return the value 15... how would I go by putting it into excel?

Thanks

I can't seems to manage to get the code which you wrote in grey.

After I paste the formula and hold down ctrl and alt then press enter while holding nothing happeds.

Thanks it worked.... I had to selected cells G2:M2.

Could you please explain on how you got the formula for:

"=LINEST(D6:D15, E6:E15^{1,2,3,4,5})" Is this based from the formula "y = 1E-06x5 - 0.0002x4 + 0.0161x3 - 0.4893x2 + 7.5295x - 20.87
Rē = 0.9989". If it is could you please explain how?

and

"=SERIESSUM(E7,5,-1,$G$2:$K$2) + $L$2"

i.e. how did you know what data to select (both formulas).

Sorry for the questions, but I really appreciate your help.

Thank You!

I've had a look at the help in excel...

But I cannot seems to find on how the calculation is done, I need to implement this in a programming language.

Anybody know where I could find a step by step walk through?

Thank You!

anyone?

Please