NMath Stats Tutorial

Calling External .NET Libraries from Excel

There are many circumstances where you may need to access an external library of functions or routines from Excel.  For example, if you need a complex function such as fitting data to a surface, or portfolio optimization, that is not natively available in Excel.  There also may be a need to protect proprietary calculations by using user defined functions to process algorithms in a black box manner...
Read More

Statistical Quality Control Charts

Statistical quality control charts, or Shewart quality control charts, are used across nearly all sectors of industry to maintain and improve product quality. Quality control charts provide a means to detect when a time varying process exceeds its historic process variation and needs analysis and/or intervention to remedy the out-of-control process (known as special cause variation). These proce...
Read More

Cluster Analysis, Part V: Monte Carlo NMF

In this continuing series, we explore the NMath Stats functions for performing cluster analysis. (For previous posts, see Part 1 - PCA , Part 2 - K-Means, Part 3 - Hierarchical, and Part 4 - NMF.) The sample data set we're using classifies 89 single malt scotch whiskies on a five-point scale (0-4) for 12 flavor characteristics. To visualize the data set and clusterings, we make use of the free Mic...
Read More

Cluster Analysis, Part IV: Non-negative Matrix Factorization (NMF)

In this continuing series, we explore the NMath Stats functions for performing cluster analysis. (For previous posts, see Part 1 - PCA , Part 2 - K-Means, and Part 3 - Hierarchical.) The sample data set we're using classifies 89 single malt scotch whiskies on a five-point scale (0-4) for 12 flavor characteristics. To visualize the data set and clusterings, we make use of the free Microsoft Chart C...
Read More

Clustering Analysis, Part III: Hierarchical Cluster Analysis

In this continuing series, we explore the NMath Stats functions for performing cluster analysis. (For previous posts, see Part 1 - PCA and Part 2 - K-Means.) The sample data set we're using classifies 89 single malt scotch whiskies on a five-point scale (0-4) for 12 flavor characteristics. To visualize the data set and clusterings, we make use of the free Microsoft Chart Controls for .NET, which p...
Read More
Top