NMath Tutorial

Calling External .NET Libraries from Excel

Posted on by CenterSpace
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

Slices and Ranges in NMath Matrices

Posted on by Ken Baldwin
NMath employs the data-view design pattern by distinguishing between data, and the different ways mathematical objects such as vectors and matrices view the data. For example, a contiguous array of numbers in memory might be viewed by one object as the elements of a vector, while another object might view the same data as the elements of a matrix, laid out row by row. Many different objects might ...
Read More

Searching for Roots in Univariate Functions

Posted on by Paul Shirkey
Finding the roots of a univariate function is a basic numerical procedure that nearly all engineers and scientists encounters at some point, because the root finding question addresses the basic equation, where, x can be a real or complex variable. Or more generally, we can solve, by finding the roots to, Algorithms I will demonstrate three well known univariate root findin...
Read More

Excel Trendlines

Posted on by Ken Baldwin
We are sometimes asked how to reproduce the various Excel Trendline types in NMath, including printing out the form of the equation and the R2 value (coefficient of determination). Excel offers these trend types: Linear Trendline Logarithmic Trendline Exponential Trendline Power Trendline Polynomial Trendline Moving Average Trendline These can all be easily computed using NMath. Let'...
Read More

Power Spectral Density with NMath

Posted on by Paul Shirkey
Application Note Computing the Power Spectrum in C# We've had several customers ask about computing the PSD in C# with NMath, so I thought it was time for a post on the subject. The power spectral density provides an estimate of the power present within each slice of spectrum, and is presented as graph of the signal power versus frequency. It's a common signal processing calculation across many fi...
Read More
Top