View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ken Johnson
 
Posts: n/a
Default How to generate a function from the given data list(Y and X)

Hi Kerry,

One way is to do an X-Y Scatter chart then insert a Trendline.
If you've a rough idea of the type of function that links the X and Y
data then choose that function from the ones available. There is an
option available for the trendline's equation to be displayed on the
chart.

Ken Johnson