Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Using Forecast Dynamically
I am trying to use Forecast dynamically by limiting the knownx and knowny range based on the value of a given X.
=FORECAST(X,knownY,knownX) If the X value falls within the knownX's (or on a knownX directly) it is not returning the corresponding knownY that seems appropriate since it appears to be factoring in the surrounding values. X Y 18.00 0.000 10.00 -0.001 2.00 -0.002 1.50 -0.024 1.20 -0.085 As an example if X is 2.00 then it does not return -0.002 but rather -0.034.. And if X is 1.60 then it returns -0.036. What I would like to do (if it makes sense) is to use FORECAST but to limit the knownX and knownY to the the adjacent values above and below the X value then it will limit the FORECAST to interpolate between the 2 values. If X is less than 1.20 (the lowest X known value) then use the last 2 values or perhaps the complete range?? I hope that makes sense. Or maybe there is a better function or approach to use? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Using Forecast Dynamically
On Friday, 4 June 2021 at 14:32:49 UTC-6, David Cuthill wrote:
I am trying to use Forecast dynamically by limiting the knownx and knowny range based on the value of a given X. =FORECAST(X,knownY,knownX) If the X value falls within the knownX's (or on a knownX directly) it is not returning the corresponding knownY that seems appropriate since it appears to be factoring in the surrounding values. X Y 18.00 0.000 10.00 -0.001 2.00 -0.002 1.50 -0.024 1.20 -0.085 As an example if X is 2.00 then it does not return -0.002 but rather -0.034. And if X is 1.60 then it returns -0.036. What I would like to do (if it makes sense) is to use FORECAST but to limit the knownX and knownY to the the adjacent values above and below the X value then it will limit the FORECAST to interpolate between the 2 values. If X is less than 1.20 (the lowest X known value) then use the last 2 values or perhaps the complete range?? I hope that makes sense. Or maybe there is a better function or approach to use? Looks like the function referenced here will do the trick after flipping the ordering of the X's https://berndplumhoff.gitbook.io/sul...tions/sbinterp |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Forecast Formula | Excel Worksheet Functions | |||
Forecast Formula Help | Excel Discussion (Misc queries) | |||
Forecast | Excel Discussion (Misc queries) | |||
Forecast | Excel Worksheet Functions | |||
forecast | Excel Discussion (Misc queries) |