Polynomial Eq Parameters

J

Jay

I have an x and y data set for which I want to identify the parameters
(a,b,c) in the following second order polynomial equation. What Excel
functions can do this? I can chart the data and use the trendline function,
but I want to automatically calculate the parameters in individual cells that
I can reference in another formula. Thanks, J

y = ax^2 + bx + c
 
J

Jay

I would also like to be able to calculate the R-squared value for polynomial
equation as well. Same as the chart trendline feature produces, but with the
outcome in a cell rather than displayed on a chart.
 
J

Jay

I would also like to be able to calculate the R-squared value for the
polynomial
equation. The chart trendline feature gives an R-squared, but displayed on
a chart rather than in a cell .
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top