利用Excel进行敏感分析

With Excel for Sensitive Analysis

敏感分析作为一种有广泛用途的分析方法,常因参数多、关系复杂等问题,导致手工计算工作量太大。利用Excel的相关功能,采取分区设置的方法可使复杂问题简单化。

Sensitive analysis as a widely used methods of analysis,often because of lots of parameters,such as the complex relationship,leading to manual computing workload is too big.Using relevant function,adopt the Excel division setting method can make the complex problem is simplified.