Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Using LINEST for non-linear curve fitting
- Retrieving unique values from a range or array ...
- Latex Maths Text in Excel
- Downloads
- Weighted Least Squares Regression, using Excel, VBA, Alglib and Python
- Automatic download of csv files
- Cubic Splines
- 3D Matplotlib Plots in Excel
- Contour plots with Excel and Matplotlib
- Downloads by category
Recent Comments
Tag Archives: NPV
Linest, NPV, IRR and solving polynomials
In a comment on Using LINEST for non-linear curve fitting Lori Miller posted a formula that found the coefficients fitting a cubic polynomial curve to a set of data, then solved the resulting equation to find the X value for a given … Continue reading
Posted in Excel, Maths, Newton, UDFs, VBA
Tagged Excel, IRR, Jenkins-Traub, NPV, polynomial solution, UDF, VBA
3 Comments