Mathpy 0.2.0 Released!

My Python library, mathpy, a collection of mathematical and statistical functions with Excel integration, has a new release! Version 0.2.0 introduces a ton of additional mathematical and statistical functions have been added in this release along with a large effort centered on documentation and testing.

Installing the package is easily accomplished through pip:

pip install mathpy

Added Functions and Methods

Linear Algebra:

  • Cholesky and LU decomposition
  • Additional Vector and Matrix Norms

Numerical Analysis:

  • Polynomial Interpolation
    • Lagrangian Interpolation
    • Neville’s Method
    • Divided Differences Interpolation
    • Taylor Series of Polynomials
  • Numerical Differentation
    • Forward and Backward Differences
    • Function Derivative Approximation
  • Numerical Integration
    • Trapezoidal Rule and Composite Trapezoidal Rule
    • Simpson’s Rule and Composite Simpson’s Rule


Number Theory:

  • Integer Factorization
    • Trial Factorization
    • Fermat Factorization
    • Pollard Rho
  • Factorials
    • Ramanujan’s Method of Approximating Factorials
    • Falling Factorials
    • Rising Factorials (also known as the Pochhammer symbol)
  • Greatest Common Divisors
    • Several implementations of computing the GCD of two integers
    • Extended form of GCD
  • Number Sequences
    • Collatz Conjecture (also known as the 3x + 1 problem)
    • Fibonacci Series
  • Random Sampling from Distributions and Random Number Generators:
    • Linear Congruential Generators
    • Multiple Congruential Generators
  • Combined Linear Congruential Generators
    • Implementations for 32-bit and 16-bit processors.


Set Theory:

  • Extensions to the Python set class including:
    • Cartesian product of two sets
    • Unions and Intersections of n number of sets



  • Factor analysis
  • t test of one and two samples (unpaired)
  • Analysis of Variance (ANOVA and MANOVA)
  • Mann-Whitney U test


Statistical Distributions:

  • Continuous Uniform Distribution
  • Bernoulli Distribution
  • Binomial Distribution

The next release will center on implementing more of these functions as Excel UDFs and updating the Excel integration and documentation in accordance with the more recent versions of xlwings.

The Python module containing the Excel UDFs can be downloaded from the following link or from the project repository on Github.
Excel UDF Python module

Each release will include an accompanying Excel UDF Python module.

For more information on using the mathpy UDFs, please see the xlwings documentation here.

No Comments

Post a Comment