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:
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:
Newton Excel Bach, not (just) an Excel Blog 