| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
generate y value
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. |
|
#2
|
|||
|
|||
|
generate y value
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. -- Gary''s Student "AhmtDY" wrote: 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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Generate a graphical formula from a column of data | Excel Discussion (Misc queries) | |||
| How to generate a random list of weekDAYS between two dates? | Excel Worksheet Functions | |||
| can i use excel to generate web links | Excel Discussion (Misc queries) | |||
| GENERATE RANDOM NUMBERS BUT EXCLUDE A NUMBER IN THE SEQUENCE | Excel Discussion (Misc queries) | |||
| generate report thru pracle to excell | Excel Discussion (Misc queries) | |||
Linear Mode
