analytics_sensitivity_analysis
Analyze how changing variables affects financial outcomes in Excel to assess risk and optimize decisions.
Instructions
Perform sensitivity analysis to understand variable impact on outcomes
Input Schema
TableJSON Schema
| Name | Required | Description | Default |
|---|---|---|---|
| scenarioName | Yes | ||
| description | No | ||
| formula | Yes | ||
| variables | Yes | ||
| sensitivityRange | No | Range for sensitivity analysis (+/- percentage, e.g., 0.2 for ±20%) | |
| worksheetName | No | Sensitivity Analysis |