|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/quantitative-risk-analysis-for-projects-on-excel/
课程评论：没有评论
**课程名称：** Excel项目定量风险分析 **课程概述：** 本课程教授如何利用Excel模板进行项目风险的量化分析。课程摒弃了缺乏科学依据的风险热图，转而介绍一种简单、直观且免费的定量风险分析方法。您可以通过dtsimulator.com下载基于宏的软件模板，无需购买昂贵的专业软件即可进行蒙特卡洛模拟。 **学习内容：** * **风险登记表：** 列出项目中的所有风险，并如同定性分析一样，为每个风险添加“频率”和““““““ 严重程度”两个维度。 * **专家意见与分布函数：** 学习如何整合专家意见，并为潜在风险事件的频率和严重程度分配不同的概率分布函数。 * **蒙特卡洛模拟：** 掌握这一Excel上的数学方法，通过遵循设定的分布函数生成随机值，进行数千次重复模拟，创建大量场景。 * **结果分析：** 学会解读模拟结果生成的数据集，并通过直方图、龙卷风图、S曲线和散点图等可视化工具，全面评估定量风险分析的输出。 **立即开始：** 访问dtsimulator.com下载基于宏的风险分析模板，开始对您的项目风险进行量化。
Learning how to quantify risks using a simple template on top of Excel. After having discarded heat maps as a weak and unjustifiable "methodology" for risk analysis, we present quantitative risk analysis for projects. Easy, intuitive and free. It can easily be done on top of Excel with macro-based software to perform Monte Carlo simulation. Simply go to dtsimulator dot com and download a free template that allows you to perform simulation without having to purchase expensive software. List your project risks on a register. As in qualitative risk analysis, you add 2 dimensions to each risk line: frequency and severity. We teach you how to add expert's opinion, adding distribution functions to both frequency and severity of possible risk events. You are ready to perform a Monte Carlo simulation: a mathematical method on top of Excel that generates random values along the distributions of your risks. With thousands of repetitions or scenarios, DTSimulator generates datasets from which graphs summarize the outcomes of your analysis. We will teach you how to analyze histograms, tornado charts, S curves and scatter plots to get the most out of a quantitative project risk analysis. Go to dtsimulator dot com and download macro-based risk templates to start quantifying the risks on your project.
