How to generate a function from the given data list(Y and X)

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi every one,
I try to accomplish this, for example,
give the two rows of data, assume one is for X, another is Y, how to get a
function between the two variables?
 
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
 
Hi Johnson,
Thanks, I know this to get a function from the chart fit,
but if we use this method, we must plot a scatter chart first, Am I right? I
need a lot of the 'function', are there any other ways to obtain this?
 
You must log in or register to reply here.

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

Similar Threads

i need to generate a "distance" graph given x and y locations 8
intersection of two lines defined by points 7
How to put same scale on X and Y axis on graph 2
Intercept and Slope of visible rows, please. 0
excel: how do i interpolate in an x-y data series? 3
Custom functions 6
Set non-continuous PrintArea via Function / Name 0
SMALL function to find X smallest number greater than Y 6

Back
Top