Links to the Scipy statistics functions were last presented here. The functions have since had extensive updates:

• The functions previously listed as “not yet implemented” have now been added.
• Each function now links to the Scipy on-line help page, and has brief descriptions for each argument in the Excel function wizard.
• The examples in the spreadsheet have been extended to cover every included function.
• Some examples previously retuning errors have been updated.

The py_Stats spreadsheet, with associated Python code in PythonStatsFuncs3.py and pyScipy3.py, are included in the download file:

py_SciPy.zip

Details of the required pyxll package (including download, free trial, and full documentation) can be found at: pyxll

For those installing a new copy of pyxll, a 10% discount on the first year’s fees is available using the coupon code “NEWTONEXCELBACH10”.

The py_Stats function can be used to call any function in the Scipy.stats module. Alternatively the functions can be called with specific py_ functions. The screenshot below shows the describe function called with py_Stats and py_describe.

The examples of each function have now been extended to cover every available function:

Help on any function can be displayed as text on the spreadsheet, using the get_docs function:

The Scipy on-line help for any function can now be displayed by clicking on “Help on this function” at the bottom left of the function wizard:

The function wizard now displays a brief description of the function purpose, and the data required for each argument, as for the built-in Excel functions:

The spreadsheet also has functions to return the arguments for each function (get_args and get_argtab, and to list every available function in any Python module (get_funcs):

Finally there is a list of every Scipy.ststs function that can be called from Excel with a py_ function. This list now also includes the row number where the function example can be found: