中国科学软件网-首页
Simetar ——模拟与经济学分析风险软件
在Excel仿真模拟编程中可以使用Simetar.可用于开发执行所有的步骤,模拟,和应用的随机模型,即:估计参数的随机变量,模拟随机变量,测试的随机变量的有效性. 通过模拟的随机模型在Excel中绘制的随机值的随机变量,让Excel的计算模型的方程,并保存,供日后分析结果的关键输出变量( KOV ) 。

Simulation models programmed in Excel can be simulated using Simetar©. Simetar©, an acronym for Simulation & Econometrics to Analyze Risk is an Excel add-in. Simetar© requires little additional memory and operates efficiently on most PCs running Excel 2000 or higher. Instructions for installing Simetar© are provided in the next section.

Simetar© consists of both Menu Driven Functions and User Defined Functions that run in Excel. A common theme with Simetar©, is that all functions are dynamic; so if changes are made to the original data most all parameters, hypothesis tests, regression models, and risk ranking strategies are automatically updated. This feature of having Excel dynamically recalculate parameters offers significant efficiencies during the development, validation and verification steps for developing stochastic simulation models.

The more than 250 User Defined functions in Simetar© can be categorized into six groups: (1) simulating random variables, (2) statistical analyses and tests, (3) graphical analysis, (4) ranking risky alternatives, (5) data manipulation and analysis, (6) econometric modeling, and (7) forecasting. Simetar© can be used to perform all of the steps for developing, simulating, and applying a stochastic model, namely: estimate parameters for random variables, simulate stochastic variables, test the validity of the random variables, present the results graphically, and rank risky alternatives.