Sub Ex_Fitlag()
Const N As Long = 4
Dim X(N - 1) As Double, Y(N - 1) As Double, Xe As Double, Ye As Double, Info As Long
'-- Data
X(0) = 0.1: Y(0) = -2.3026
X(1) = 0.11: Y(1) = -2.2073
X(2) = 0.12: Y(2) = -2.1203
X(3) = 0.13: Y(3) = -2.0402
'-- Compute ln(0.115) and ln(0.125)
Xe = 0.115
Ye =
Fitlag(Xe, N, X(), Y(), Info, , 0.0001)
Debug.Print "ln(" + CStr(Xe) + ") = " + Str(Ye) + " (Info =" + Str(Info) + ")"
Xe = 0.125
Ye =
Fitlag(Xe, N, X(), Y(), Info, , 0.0001)
Debug.Print "ln(" + CStr(Xe) + ") = " + Str(Ye) + " (Info =" + Str(Info) + ")"
End Sub
Function Fitlag(X As Double, N As Long, A() As Double, F() As Double, Optional Info As Long, Optional M As Long=5, Optional Eps As Double=1.0e-8) As Double
Iterative Lagrange interpolation