Tag Archives: Scipy stats

Scipy-statistics with all distributions

Posted on 17/05/2026 by dougaj4

Following the previous post the Scipy statistics functions have been updated to include all the distributions, including the discrete distributions. The input to the distribution functions has also been updated to allow arrays to be transferred either as Excel ranges … Continue reading →

Posted in Arrays, Excel, Link to Python, Maths, Newton, NumPy and SciPy, PyXLL, UDFs | Tagged , , , , , , , , , , , | Leave a comment

Transferring different data types to/from Python with pyxll

Posted on 12/05/2026 by dougaj4

When a user defined function (UDF) is created in Excel with Python and pyxll the data type of each argument can be specified, either in the @xl_func decorator, or with a separate @xl_arg decorator for each argument. I prefer the … Continue reading →

Posted in Arrays, Excel, Link to Python, Newton, NumPy and SciPy, PyXLL, UDFs | Tagged , , , , , , , , , | 1 Comment

Using Python optional arguments from Excel with pyxll

Posted on 14/01/2021 by dougaj4

Python functions allow optional arguments to be specified by allocating a default value to each optional argument. The pyxll add-in allows Python functions called from Excel to work in the same way, so any argument with a default value may … Continue reading →

Posted in Excel, Link to Python, PyXLL, UDFs | Tagged , , , , , , | 1 Comment

Scipy Statistics Functions – coding and getting help

Posted on 10/07/2018 by dougaj4

The Python Scipy library currently has 84 statistics functions.  I have now updated the xlwSciPy3 spreadsheet to access all of them directly from Excel.  The new version can be downloaded from: xlwSciPy3.zip As usual, the download includes full open-source code.  … Continue reading →

Posted in Excel, Link to Python, Maths, Newton, NumPy and SciPy, UDFs, VBA, xlwings | Tagged , , , , , , , | Leave a comment