Need excel formula translated to access

[freud52]

I have a formula from an excel trendline that will calculate a percentile score. I would like to be able to use it in access, perhaps in a query. Can anyone help me??

 

[chergh]

Essentially all you would do is replace 'x' with the name of the field that contains the 'x' value.

So with your polynomial I guess it would be something like this:

SELECT tblName.field1, (-8*10^-7)*(tblName.field2^6)+(9*10^-5)*(tblName.field2^5)-(0.0037*(tblName.field2^4)+0.0656*(tblname.field2^3)-0.41*(tblName.field2^2)+2.5709*tblname.field2+31.173 AS Percentile_Score
FROM tblName