Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- 3DFrame Ver 1.03 and Frame4 Ver 3.07
- Using LINEST for non-linear curve fitting
- XLDennis, the MSDN Library, and VBA rant
- Filling Blanks with Go To-Special (and local help rant)
- About Newton Excel Bach
- Cubic Splines
- Writing Arrays to the worksheet - VBA function
- Downloads
- Daily Download 5: Frame Analysis
- Worksheetfunction.Transpose - changed behaviour in Excel 2013 and 2016
Recent Comments
Tag Archives: numerical integration
Faster Integration with the Tanh-Sinh Method
In my previous post about numerical integration I mentioned that I would be writing about another lesser known method providing better speed and/or accuracy in many cases. The method is known as Tanh-Sinh quadrature, and has been implemented in Excel by a reader … Continue reading
Posted in Excel, Maths, Numerical integration, UDFs, VBA
Tagged Excel, Gauss-Kronrod, numerical integration, Quadrature, Romberg, Tanh-Sinh, UDF, VBA
3 Comments
Evaluate integrals to a specified tolerance
A previous post presented a user defined function (UDF) to perform a numerical integration of a function specified as a text string. The UDF allowed the number of subdivisions of the integration range to be specified, but the number of subdivisions required to … Continue reading
Posted in Excel, Maths, Newton, UDFs
Tagged Evaluate, Excel, numerical integration, Simpson's Rule, UDF, VBA
2 Comments
Evaluate Function – update
Previous post The evaluate function described in the previous post has been used in writing a UDF that will evaluate the integral of any suitable function over a specified range. The revised worksheet can be downloaded from: Eval.zip