应用Excel表格建立正交试验自动数据处理系统

The establishment of data-autocalculator system for orthogonal experiment by Microsoft Excel

目的:建立方便快捷的正交试验数据自动处理系统。方法:分析正交试验原始数据与最终结果之间内在的函数关系,应用Office的组件之一Excel中强大的函数功能建立自动数据处理系统。结果:建成了一套系统的正交试验数据自动处理表格,只需输入试验的原始数据,便可立即得到所需的正交试验结果。结论:应用Excel强大的计算功能处理烦琐的正交试验数据准确、方便、快捷。

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.