In the early hours of this morning, when I was having difficulty sleeping, I decided to have a go a seeing if I could do this (nothing on TV!) A few Google searches later and I found some good links of polynomial equation calculation and Microsoft Excel.
So this is my first attempt at working out polynomial equations, in orders from linear to 4th order – I am very proud! (Although please let me know if it is a load of rubbish!!)
Download Polynomial Calculator Spreadsheet:
Screenshot of 3rd order polynomial calculation version of above spreadsheet, compared to Dr Elliott’s linear calulation spreadsheet for same data: