Category Archives: Maths

Cubic Spline Update

The previous post in this series presented a User Defined Function (UDF) to fit  a cubic spline to a series of points defined by XY coordinates.  Each segment of the resulting spline is defined by a separate cubic curve, which may be … Continue reading

Posted in Coordinate Geometry, Excel, Maths, Newton, UDFs, VBA | Tagged , , , , | 1 Comment

A not so obvious puzzle

A nice puzzle from Tanya Khovanova’s Math Blog Which of the shapes below is the odd one out?

Posted in Maths, Newton | Tagged | 3 Comments

Some New Links

A couple of return links to sites that have been sending traffic my way, and are well worth a look: AJP Excel Information (Andy Pope’s site): “The intention of this site is to be a useful resource of alternative solutions … Continue reading

Posted in Excel, Maths | Tagged , , | Leave a comment

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

Posted in Excel, Maths | Tagged , , , , | 1 Comment

Geometric Tools

I was recently sent a link to: Geometric Tools Documentation Which has a host of pdf files with detailed instructions on all manner of geometric calculations.  The focus of the site is animation for games programs, but there is plenty … Continue reading

Posted in Coordinate Geometry, Maths, Newton | Tagged , | Leave a comment