Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Using LINEST for non-linear curve fitting
- Retrieving unique values from a range or array ...
- Downloads
- Weighted Least Squares Regression, using Excel, VBA, Alglib and Python
- Latex Maths Text in Excel
- Automatic download of csv files
- Cubic Splines
- 3D Matplotlib Plots in Excel
- About Newton Excel Bach
- Contour plots with Excel and Matplotlib
Recent Comments
Tag Archives: Data Analysis Tools
Text from pictures in Excel
Excel recently added the ability to extract text from an image, either on the clipboard or from a selected file. To try this out I used a screenshot of a table with vertically aligned text, from a pdf copy of … Continue reading
Posted in Charts, Excel
Tagged Data Analysis Tools, Data from pictures, Excel, IrfanView
Leave a comment
Using Linest for non-linear curve fitting, examples, hints and warnings
Since I wrote Using LINEST for non-linear curve fitting in 2011 it has been by far the most popular post on this blog. This post (in response to a recent question) provides some more detailed guidance on how to apply the function … Continue reading
Posted in Curve fitting, Excel
Tagged Data Analysis Tools, Excel, Linest, non-linear fitting, non-linear regression, over-fitting, Trend
3 Comments