View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jay Jay is offline
external usenet poster
 
Posts: 671
Default Polynomial Eq Parameters

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

--
Jay