回归正交设计响应面图的Excel绘制法  

Drawing Method of Response Surface Graph in Regression Orthogonal Design with Excel Software

作　　者：刘子媛[1] LIU Zi-yuan(College of Chemistry and Chemical Engineering,China University of Petroleum(East China),Shandong Qingdao 266580,China)

机构地区：[1]中国石油大学(华东)化学化工学院,山东青岛266580

出　　处：《广州化工》2024年第17期175-177,180,共4页GuangZhou Chemical Industry

摘　　要：回归正交设计是非常实用的实验设计方法,但数据处理步骤比较繁琐,因此采用Excel软件处理数据及绘图对结果进行可视化呈现,能使学生更好地理解和应用该方法。本文简洁介绍了利用Excel 2019软件处理二次回归正交设计数据的方法,详细给出了响应面图和等高线图的绘制过程,图形规范,清晰美观。该方法简便快速,学生易于掌握。Regression orthogonal design is a very practical experimental design method,but the data processing steps are relatively cumbersome.Therefore,using Excel software to process data and visualize the results through drawing can help students better understand and apply this method.The method of using Excel 2019 software to process the data of quadratic regression orthogonal design was briefly introduced,and the drawing process of response surface diagram and contour diagram was detailed.This method is simple and easy for students to master.

关 键 词：回归正交设计 响应面图 EXCEL软件 绘图 

分 类 号：O6-39[理学—化学]