Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Intersections, interpolations, and rotations
- Using LINEST for non-linear curve fitting
- Biaxial bending update
- Cubic Splines
- Retrieving unique values from a range or array ...
- A catenary function
- The history of the theory of beam bending - Part 3
- Writing Arrays to the worksheet - VBA function
- Converting from global to local coordinates (and vice versa)
- Linestgap with data in rows
Recent Comments
Tag Archives: regression
Chart Trend Lines and the Linest Function
At the Mr Excel discussion forum the output of the worksheet function Linest(), compared with chart trend lines raised a question, where it is said that in Excel 2007 the trend line gives different (and incorrect) coefficients for a polynomial curve … Continue reading