# Examples Using NAG and Excel

Most of the examples here are based on the Mark 24 NAG Library. You will need to update the name of the DLL in the Declare statements to use them with newer Library releases. If you need help with this conversion, please contact us.

Basic examples
• How to compute the matrix exponential, and other matrix functions, of a real matrix using the Schur–Parlett algorithm
• How to compute the Cholesky factorization of a real symmetric positive definite matrix
• How to reduce a real m by n matrix to bidiagonal form by an orthogonal transformation
• How to compute the singular value decomposition of a real upper or lower bidiagonal matrix
• How to compute the maximum likelihood estimates of the parameters of a factor analysis model
• How to calculate multivariate probability
• How to find a zero of a function using a reverse communication interface
• How to compute the option price given by the Black–Scholes–Merton formula together with its Greeks
• How to compute the option price given by Heston's stochastic volatility model together with its Greeks
• How to solve a Markowitz Modern Portfolio optimization problem
• How to compute the two-dimensional discrete wavelet transform
• How to perform quantile linear regression
• How to compute a definite integral over a finite range to a specified relative accuracy using a method described by Patterson
• Miscellaneous examples of and general notes on Using the NAG C Library
• How to use the scaled Wiener increments produced using a Brownian bridge generator to compute numerical solutions to stochastic differential equations (SDEs) driven by (free or non-free) Wiener processes
• How to compute the Nearest Correlation Matrix (NCM), in the Frobenius norm, or weighted Frobenius norm, and optionally with bounds on the eigenvalues, or with k-factor structure, and how to find eigenvalues for both symmetric and asymmetric matrices
• How to compute the Nearest Correlation Matrix (NCM), in the Frobenius norm, or weighted Frobenius norm, or element-wise weightings and optionally with bounds on the eigenvalues, or with k-factor structure, and how to find eigenvalues for both symmetric and asymmetric matrices
• How to find the global optimum of a multivariate function using the multi-level coordinate search algorithm
• How to solve a nonlinear least-squares problem using the sequential quadratic programming (SQP) method
• How to find a minimum of a function, subject to fixed upper and lower bounds (no derivatives required) using the BOBYQA algorithm
• How to obtain Kaplan–Meier estimates for censored data
• How to perform GARCH time series identification, estimation and forecasting
• How to perform ARIMA time series identification, estimation and forecasting
• How to implement Local Volatility model using Dupire formula and a collection of NAG interpolation routines and a PDE solver

The NAG Statistical Add-Ins contain a considerable number of statistical routines grouped together in one spreadsheet. These include functions for:

• Simple statistics
• Regression Analysis
• Time Series Modelling
• GLMs
• PCA
• Factor, Cluster, and Discriminant Analyses
• Nonparametric tests
• And others…

All functions can be called via Excel's function wizard and the spreadsheet is supplied with a NAG menu with utilities for expanding the results and extracting formatted data.

The spreadsheet works with the 32-bit NAG Fortran Library FLDLL244ML with Excel 2003, 2007, and 2010 (32-bit).

The zip file contains the Excel spreadsheet, a README file and Windows help file.

Please note, that in order to be able to read the help file on Windows Vista and later versions of Windows you need to download a Windows Help component from http://support.microsoft.com/kb/917607 free of charge. To avoid any potential problems with the Microsoft Validation Program, you might consider using Internet Explorer to perform this download.

NAG Survival Analysis for Excel

The NAG Survival Analysis spreadsheet contains functions to:

• Compute Kaplan–Meier estimates of survival probabilities (with plots)
• Compute rank statistics for comparing survival curves
• Fit Cox's proportional hazard model

All functions can be called via Excel's function wizard and the spreadsheet is supplied with a NAG menu with utilities for expanding the results and extracting formatted data.

The spreadsheet works with the 32-bit NAG Fortran Library FLDLL244ML with Excel 2003, 2007, and 2010 (32-bit).