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

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

作　　者：刘子娟 郑学斌 郭小军 LIU Zijuan;ZHENG Xuebin;GUO Xiaojun(China Hunan Aviation Power Machinery Research Institute,Zhuzhou 412002,China;Changsha Shenghua Microelectronics Materials Co.,Ltd.,Changsha 410000,China)

机构地区：[1]中国湖南航空动力机械研究所,湖南株洲412002 [2]长沙升华微电子材料有限公司,长沙410000

出　　处：《机械工程师》2020年第2期117-119,124,共4页Mechanical Engineer

摘　　要：从理论上根据相关系数法所得的边界条件,运用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.

关 键 词：MS Excel 三参数威布尔分布 参数估计 可靠度 

分 类 号：TP391.7[自动化与计算机技术—计算机应用技术]