Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Matrix and linear interpolation
Hi guys,
consider the following matrix: A B C D E G H 1 hv/bv g CLF CLx KLF KLx 3 200 2 3 0,250 15,000 0,75 0,43 1,8 1,24 4 50,000 0,77 0,33 1,65 1,16 5 100,000 0,8 0,24 1,59 1,11 6 300,000 0,9 0,07 1,56 1,11 7 0,500 15,000 0,9 0,76 1,08 1,04 8 100,000 0,97 0,68 1,07 1,02 9 300,000 1,1 0,6 1,05 1,02 10 2,000 15,000 0,87 1,3 0,94 1,12 11 100,000 0,81 1,15 0,89 1,07 12 300,000 0,8 1,5 0,79 0,9 13 4,000 15,000 0,68 1,2 0,9 1,24 14 100,000 0,51 1,03 0,81 1,12 15 300,000 0,5 1,33 0,64 0,83 without using VBA is it possible to find an expression that having the G1 (3) value for hv/bv and H1(200) value for g returns the linear interpoleted value of CLF, CLX, KLF and KLX in four cells? For example given 3 for hv/bv and 200 forg should returns 0,665 for CLF (=((0,81+0,8)/2+(0,5+0,51)/2)/2) and so on four the remaining three parameters CLX, KLF and KLX. Regards, Claudio |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Matrix and linear interpolation
Hi Claudio:
You can use the FORECAST() function to do a straight linear interpolation between supplied data points. As its name implies, it is normally used to extrapolate rather than interpolate. -- Gary's Student " wrote: Hi guys, consider the following matrix: A B C D E G H 1 hv/bv g CLF CLx KLF KLx 3 200 2 3 0,250 15,000 0,75 0,43 1,8 1,24 4 50,000 0,77 0,33 1,65 1,16 5 100,000 0,8 0,24 1,59 1,11 6 300,000 0,9 0,07 1,56 1,11 7 0,500 15,000 0,9 0,76 1,08 1,04 8 100,000 0,97 0,68 1,07 1,02 9 300,000 1,1 0,6 1,05 1,02 10 2,000 15,000 0,87 1,3 0,94 1,12 11 100,000 0,81 1,15 0,89 1,07 12 300,000 0,8 1,5 0,79 0,9 13 4,000 15,000 0,68 1,2 0,9 1,24 14 100,000 0,51 1,03 0,81 1,12 15 300,000 0,5 1,33 0,64 0,83 without using VBA is it possible to find an expression that having the G1 (3) value for hv/bv and H1(200) value for g returns the linear interpoleted value of CLF, CLX, KLF and KLX in four cells? For example given 3 for hv/bv and 200 forg should returns 0,665 for CLF (=((0,81+0,8)/2+(0,5+0,51)/2)/2) and so on four the remaining three parameters CLX, KLF and KLX. Regards, Claudio |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Linear Trendline | Charts and Charting in Excel | |||
Gauss elimination / linear algebra. Please help. | Excel Worksheet Functions |