利用Excel优化水性木器漆配方设计

Formulation Design of Waterborne Wood Coatings Optimized by Excel Function

用正交试验优化水性木器漆配方设计。以L_9(3~4)正交表为例,创建一个极差和方差分析的正交设计数据处理Excel模板,能简单、准确、快速的处理繁琐的正交实验数据。

A waterborne wood coating was designed and optimized by using and orthogonal experiment method. Taking the L9（34） orthogonal table as an example, an Microsoft Excel template for orthogonal data processing of range analysis and variance analysis was created, with which ortahogonal data can be processed simply, accurately and quickly.