Utilities

NumXL also features a number of functions that do not fit into our main function categories. These "orphan" functions, including interpolation, extrapolation, excess kurtosis of a GEDi/Student’s t distribution, are grouped together in the "utilities" category

• NUMXL_INFO - Installation Information
• INTERPOLATE - Interpolation and Extrapolation Function
• HASNA - Check input for observations with missing Value
• MV_OBS - Number of observations with non-missing values
• MV_VARS - Effective Number of Variables
• NxMatch - Regular Expression (regex) Match Function
• NxRegress - Simple Linear Regression Function
• NxReplace - Regular Expression (regex) Replace Function
• NxTokenize - Separate a string by a delimiter into an array of substrings
• NxSort - Sort input array
• NxTranspose - Convert row to column (and vice versa)