Max value extrapolation

[jlnewbie]

I have an Access query that calculates data points for plotting a curve that is Moisture Content vs Dry Density. The curve is a polymonial and I'm interested in automatically extrapolating the values at the tangent or max value in excel. Is this possible? I don't know excel capabilites that well. Generating these values will help me automate a correction factor that is also needed on these values. Thank you



JLopez
Lopez31@ATC-Enviro.com
Environmental Services @ Your Service

 

[mintjulep]

Calculus.

The derivitive of your function will equal zero at any inflection points. The inflection points will be at either the minimum or maximum (either local or global).