广州化工
廣州化工
엄주화공
GUANGZHOU CHEMICAL INDUSTRY AND TECHNOLOGY
2014年
11期
12-14,41
,共4页
秦国正%余正芝%张明芮%柳春燕
秦國正%餘正芝%張明芮%柳春燕
진국정%여정지%장명예%류춘연
Excel 2003%L9 (34 )正交试验%方差分析
Excel 2003%L9 (34 )正交試驗%方差分析
Excel 2003%L9 (34 )정교시험%방차분석
Excell2003%orthogonal experiment of L 9 (34 )%analysis of variance
根据L9(34)正交试验数据的统计学分析原理和计算方法,充分运用Excel 2003的公式、函数和引用功能,建立L9(34)正交试验的数据分析表。并通过实例,检验了数据分析表的通用性与数据分析结果的准确性。建立的L9(34)正交试验数据分析表适合所有四因素三水平和三因素三水平的正交试验数据的快速分析。
根據L9(34)正交試驗數據的統計學分析原理和計算方法,充分運用Excel 2003的公式、函數和引用功能,建立L9(34)正交試驗的數據分析錶。併通過實例,檢驗瞭數據分析錶的通用性與數據分析結果的準確性。建立的L9(34)正交試驗數據分析錶適閤所有四因素三水平和三因素三水平的正交試驗數據的快速分析。
근거L9(34)정교시험수거적통계학분석원리화계산방법,충분운용Excel 2003적공식、함수화인용공능,건립L9(34)정교시험적수거분석표。병통과실례,검험료수거분석표적통용성여수거분석결과적준학성。건립적L9(34)정교시험수거분석표괄합소유사인소삼수평화삼인소삼수평적정교시험수거적쾌속분석。
According to principle of statistics and numerical methods , thoroughly made use of formulas , functions and citations to construct an analytical table that was used to analyze those data.The versatility of the table and accuracy of analytic results was tested with examples.This table fitted the orthogonal experiment of 4 factors and 3 levels as well as 3 factors and 3 levels.The results of analysis were reliable.Using this table , the objective of rapid analysis in orthogonal experiment of L9 (34 ) was accomplished.