create_aggregate_mc
Build a Monte Carlo aggregate loss model in Excel by referencing a frequency object cell and a severity object cell to simulate the sum of random severity draws.
Instructions
ModelRisk: Build a VoseAggregateMC(n, distribution, ...) formula that simulates the aggregate of a (possibly random) number n of i.i.d. severity draws. n and distribution are cell references — n points at a frequency cell, distribution at a severity object cell (built with a VoseObject function).
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| sheet | Yes | ||
| dry_run | No | ||
| workbook | Yes | ||
| max_limit | No | ||
| min_limit | No | ||
| target_cell | Yes | ||
| distribution_shift | No | ||
| severity_object_cell | Yes | ||
| frequency_object_cell | Yes |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| cell | Yes | ||
| formula | Yes | ||
| written | Yes | ||
| previous_formula | No |