期刊文献+

Excel 5电子表格在纤维单丝强度分析中的应用 被引量:3

APPLICATION OF EXCEl 5 IN STATISTICAL ANALYSIS OF THE STRENGTH DISTRIBUTION OF SINGLE FIBERS
原文传递
导出
摘要 利用Excel5电子表格对纤维单丝强度分布分别按正态分布与韦伯分布模型进行了统计分析,并对三种确定韦伯参数的方法进行了比较,所提出的第三种数值计算方法具有简单快速的特点。绘制了有关强度测定影响因素分析图,采用人-机对话形式,通过宏控制,实现了整个分析过程及结果输出的自动化。以自制粘胶碳纤维为例展示了部分分析结果。 The statistical analysis of strength distribution of carbon fibrils was studied using Excel 5 by Normalized and Weibull distributions models. The Weibull parameters were evaluated by three different approaches, where the fitting equation s/σ= 0.9894β-0.912 was disposed for this purpose. Avaries of factors that affect the tensile strength determination were considered and the results were displayed in figures. Using man-machine dialog, the whole process for the calculation and the output of the results were run automatically by computer. As an example, the results of the strength analysis for the rayon-based carbon fiber were demonstrated.
作者 彭平 李效东
出处 《计算机与应用化学》 CAS CSCD 1998年第2期114-118,共5页 Computers and Applied Chemistry
基金 国防科技预研基金!95J12.12 KG0143
关键词 电子表格 单丝 强度分析 纤维增强 复合材料 Excel 5 spreadsheet, Tensile strength of single fiber,Automatically statistical analysis
  • 相关文献

参考文献2

  • 1Fang Zhong(译),Microsoft Excel 5 Worksheet Function Reference(in Chinese),1995年,212页
  • 2Song Qing,Estimate of Error and Data in Quantitative Analysis (in Chinese),1982年

同被引文献22

引证文献3

二级引证文献14

相关作者

内容加载中请稍等...

相关机构

内容加载中请稍等...

相关主题

内容加载中请稍等...

浏览历史

内容加载中请稍等...
;
使用帮助 返回顶部