Tag Archives: statistics

xlwings – dataframes and statistics

Posted on April 12, 2016 by

Another data conversion option offered by the latest xlwings release is Pandas dataframes and dataseries.  This post will look at how to pass an Excel range as a dataframe or dataseries in a User Defined Function (UDF), and some simple … Continue reading →

Posted in Excel, Link to Python, Maths, Newton, Python Pandas, UDFs, VBA | Tagged , , , , , , , | 1 Comment

1 Million Page Views

Posted on December 5, 2013 by

At some time in the next couple of hours or so the number of page views here will pass the 1 million mark, so congratulations in advance one millionth page viewer. I thought it would be interesting to see where … Continue reading →

Posted in Computing - general | Tagged , | 3 Comments

Daily Download 13: The ALGLIB maths library and Excel

Posted on September 30, 2012 by

Today we move onto maths related downloads, starting with the ALGLIB maths library, which has featured here quite frequently: Original post with link to site: ALGLIB Installing AlgLib with Excel VBA Download files: http://interactiveds.com.au/software/AL-Matrix-xlsb.zip   http://interactiveds.com.au/software/AL-Matrix-xls.zip Linking AlgLib C++ to Excel … Continue reading →

Posted in AlgLib, Arrays, Excel, Maths, Newton, Numerical integration, UDFs, VBA | Tagged , , , , , , , | 7 Comments

2010 in review

Posted on January 2, 2011 by

The stats helper monkeys at WordPress.com mulled over how this blog did in 2010, and here’s a high level summary of its overall blog health: The Blog-Health-o-Meter™ reads Wow. Crunchy numbers The Louvre Museum has 8.5 million visitors per year. … Continue reading →

Posted in Computing - general | Tagged | Leave a comment

ALGLIB Statistics Functions

Posted on August 16, 2010 by

I have recently imported all the ALGLIB statistics functions into VBA, and written interface functions where required, so that all the functions may now be used as User Defined Functions (UDFs) on the spreadsheet.  A spreadsheet including full open source code … Continue reading →

Posted in AlgLib, Excel, Maths, Newton, UDFs, VBA | Tagged , , , , , | 4 Comments

Chart Trend Lines and the Linest Function

Posted on November 3, 2009 by

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