Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Using LINEST for non-linear curve fitting
- 3DFrame Ver 1.03 and Frame4 Ver 3.07
- Cubic Splines
- About Newton Excel Bach
- XLDennis, the MSDN Library, and VBA rant
- Downloads
- Automatic download of csv files
- Writing Arrays to the worksheet - VBA function
- Retrieving unique values from a range or array ...
- Weighted Least Squares Regression, using Excel, VBA, Alglib and Python
Recent Comments
Tag Archives: blank values
Using LinEst() on data with gaps
A comment on Using LINEST for non-linear curve fitting asked if it was possible to use the function on data with gaps. There are several options: Copy and sort the data to remove the gaps. Use the chart trendline function Use … Continue reading