应用MS Excel求解三参数威布尔分布函数的参数估计

Parameter Estimation of Three-Parameter Weibull Distribution Function Using MS Excel

从理论上根据相关系数法所得的边界条件,运用MS Excel对三参数威布尔分布进行参数估计,以举例一组数据的方式来说明如何使用Excel中的数学运算函数、规划求解功能,快速、高效地求解三参数威布尔分布的参数估计,从而避免复杂的编程求解。

Based on the boundary conditions obtained by the correlation coefficient method, the powerful mathematical operations and statistical analysis functions of MS Excel are used to estimate the parameters of the three-parameter Weibull distribution theoretically. A set of data is used to illustrate how to use the mathematical operation function and the solution solving function in Excel to solve the parameter estimation of the three-parameter Weibull distribution quickly and efficiently, thus avoiding complicated programming.