generate y value

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

Guest

I have two arrays (x and y values). Is there a method for estimate the y
value for any x value that are not at the array. Actually I want to make
arithmetical operations(add/divide) in two graphs whose x values are not same.
 
There are two good ways:

1. Insure that you have the Analysis ToolPak added-in. The use LINEST() to
generate a formula that you can use for any x-value.

2. The FORECAST() function does a fine job of estimating the value of y for
some x between two known points.
 

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

operating over a range in an array 1
How to separate x y data in 1 column to 2 colums of x and y data? 6
if statement with vlookup 1
MS Excel - changing reference column value based on another column 2
Excel - changing column reference based on value of other column 4
Excel 2003: Mapping rows (x-axis) vs multiple columns (y-axis) 1
how to generate data from graph in excel 2
Graphs 1

Back
Top