应用Excel表格建立正交试验自动数据处理系统
The establishment of data-autocalculator system for orthogonal experiment by Microsoft Excel
-
摘要: 目的 建立方便快捷的正交试验数据自动处理系统.方法 分析正交试验原始数据与最终结果之间内在的函数关系,应用Office的组件之一Excel中强大的函数功能建立自动数据处理系统.结果 建成了一套系统的正交试验数据自动处理表格,只需输入试验的原始数据,便可立即得到所需的正交试验结果.结论 应用Excel强大的计算功能处理烦琐的正交试验数据准确、方便、快捷.Abstract: Objective To establish a convenient and speedy data-autocalculator system for orthogonal experiment.Methods After the function relations of orthogonal experiment data were analysed, data-autocalculator tables were established by the powerful function capabilities of Microsoft Excel.Results A series of data-autocalculator tables for orthogonal experiment were established.Only inputting data will bring all the results of orthogonal experiment immediately.Conclusion It is veracious, simple and rapid to calculate the boring data of orthogonal experiment by Microsoft Excel.
-
Key words:
- orthogonal experiment /
- Excel /
- data-autocalculator
计量
- 文章访问数: 4099
- HTML全文浏览量: 395
- PDF下载量: 558
- 被引次数: 0