Recent Comments
Author Archives: dougaj4
New and updated links
I have just updated my Blogroll, with 9 new links, and a couple of updates: Colin Caprani’s site is now back on-line I have updated the link to Jon Peltier’s blog dataprose.org was the source of many of the new links, … Continue reading
Google, artificial intelligence and the Daily Mail
The New Scientist tells me that the people at Google Labs are training their bots in natural language processing by feeding them text from the Daily Mail. This raises two puzzling questions: How is it that those behind the Internet’s … Continue reading
Section Properties – Lunes and Groups
Following a discussion at Eng-Tips and resulting comments I have updated my Section Properties spreadsheet to include calculation of the area and centroid of a “Lune” (the shape of a crescent moon). I have also added a “Re-draw Shape” button because … Continue reading
Posted in Drawing, Excel, Maths, Newton, VBA
Tagged Excel, group properties, Lune, section properties, VBA
2 Comments
Using Linest for non-linear curve fitting, examples, hints and warnings
Since I wrote Using LINEST for non-linear curve fitting in 2011 it has been by far the most popular post on this blog. This post (in response to a recent question) provides some more detailed guidance on how to apply the function … Continue reading
Posted in Curve fitting, Excel
Tagged Data Analysis Tools, Excel, Linest, non-linear fitting, non-linear regression, over-fitting, Trend
3 Comments
Sheila Chandra; This
Sentence Is True From: “This Sentence Is True” (The Previous Sentence Is False)
Newton Excel Bach, not (just) an Excel Blog 