| 用Excel进行威布尔型产品可靠性数值仿真评估 |
| |
| 引用本文： | 张仕念,张国彬,易当祥,颜诗源,杨艳妮.用Excel进行威布尔型产品可靠性数值仿真评估[J].电子产品可靠性与环境试验,2012(4):43-46. |
| |
| 作者姓名： | 张仕念 张国彬 易当祥 颜诗源 杨艳妮 |
| |
| 作者单位： | 北京市清河大楼子八,北京100085 |
| |
| 摘 要： | 基于最小二乘法,利用Excel的已有函数和单元格的引用,估计威布尔分布的参数m和η,用RAND()函数产生的随机数和逆变法抽取服从分布参数为m和η的威布尔分布抽样样本,计算可靠度的一个抽样值,反复抽样,得到可靠度的分布密度函数,用SMALL()函数返回可靠度置信下限的仿真值。实例表明,仿真结果与计算结果很接近,用Excel进行可靠性数字仿真,可以避免繁杂的编程工作,方便实用。
|
| 关 键 词： | 威布尔分布 可靠性 数字仿真 |
Reliability Numerical Simulation Estimate for Product with a Weibull Failure Distribution by Excel |
| |
| Affiliation: | ZHANG Shi-nian,ZHANG Guo-bin,YI Dang-xiang,YAN Shi-yuan,YANG-Yan-ni(Beijing Qinghe Big Building Zi No.8,Beijing 100085,China) |
| |
| Abstract: | The existing functions and cell citation of Excel were used to estimate the parameter m and η of Weibull distribution based on least squares method.The random sample fitted Weibull distribution with parameter m and η was acquired with the random number produced by RAND() and the inverter method,and the sampling value of reliability was computed.By repeating the sampling in this way,the probability density function of reliability was obtained,and the lower confidence limit of reliability was obtained by SMALL().From the practical example,it is shown that the simulation result is very close to the computed value,and the reliability numerical simulation using Excel is convenient and practical by avoiding complex programming work. |
| |
| Keywords: | Weibull distribution reliability digital simulation |
| 本文献已被 CNKI 维普 等数据库收录！ |
|
