# MCNORM

## Description

Simulate a matrix of returns using multi-variate Monte-Carlo. 

## Syntax

The following describes the function signature for use in Microsoft Excel's formula bar.

```excel-formula
=MCNORM(mu, sigma, rho, isRhoExact, T, dataPeriodicity)
```

### Input(s)

| Argument            | Description                                                                                                                                                                                                                                                                                     |
| ------------------- | ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| **mu**              | Required. Vector of expected returns.                                                                                                                                                                                                                                                           |
| **sigma**           | Required. Vector of expected risk.                                                                                                                                                                                                                                                              |
| **rho**             | Optional. Correlation matrix. If not specified, the function assumes zero correlation coefficients (identity matrix).                                                                                                                                                                           |
| **isRhoExact**      | Optional. Logical (TRUE or FALSE). If TRUE, the sample mean and covariances will match mu and sigma. The resulting compounded (terminal) prices will be in close agreement, set to FALSE for typical expected value behavior. If the argument is not specified, the function defaults to FALSE. |
| **T**               | Optional. Time horizon (number of observations, in years) to generate. If not specified, defaults to 1.                                                                                                                                                                                         |
| **dataPeriodicity** | <p>Optional. Periodicity of the data, used for annualization. If you do not enter the argument, it defaults to 1. <br><em>e.g. Daily = 255, Monthly = 12,  Yearly = 1, Quarterly = 4.</em></p>                                                                                                  |

### Output(s)

Matrix of multi-variate returns simulated using Monte-Carlo.

## Example

![](/files/-MMuuPPAr_hk3scD2zGh)

{% file src="/files/-MMut5j8QBbI4Mk-30vC" %}
Example Workbook: MCNORM
{% endfile %}


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://excelhelp.windhamlabs.com/functions/simulation/mcnorm.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.