Category Archives: Maths

A not so obvious puzzle

Posted on 26/11/2009 by dougaj4

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

Posted on 09/11/2009 by dougaj4

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

Posted on 03/11/2009 by dougaj4

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

Posted on 30/09/2009 by dougaj4

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

Approximate Solutions of Polynomial Equations

Posted on 14/09/2009 by dougaj4

Following on from the previous post, this post presents a number of methods of solving polynomial equations using approximate iterative methods in Excel.  Similar methods can be used to find solutions to any other equation that can be evaluated numerically. … Continue reading →

Posted in Excel, Maths, Newton, UDFs, VBA | Tagged , , , , , , | 3 Comments