联合均匀设计法和Microsoft Excel优化沙棘籽原花色素提取工艺(英文)  

Optimization of Extraction Program of Sea Buckthorn Seeds Proanthocyanidins by Combining Uniform Design and Microsoft Excel

作　　者：田亚新[1] 韩晓云[1] 王运来[1] 康传红[2] 

机构地区：[1]黑龙江大学生命科学学院,黑龙江哈尔滨150080 [2]黑龙江大学化学化工与材料学院,黑龙江哈尔滨150080

出　　处：《食品科学》2012年第16期91-95,共5页Food Science

基　　金：黑龙江省教育厅科学技术研究项目(11551376);黑龙江大学青年科学基金项目(QL200908)

摘　　要：提出一个基于均匀设计方法和Microsoft Excel的LINEST函数进行试验设计优化的方法。本实验通过均匀设计方法设计沙棘籽原花色素提取工艺,然后通过LINEST函数计算多元回归方程,该方法可避免因为使用其他专业数据处理软件的花费和固定算法限制。验证实验表明:沙棘籽原花色素的提取率提高了16.43%,该方法可应用到其他实验方面。A novel optimization method based on uniform design and function LINEST of Microsoft Excel was proposed to explore the extraction of proanthocyanidins from sea buckthorn seeds. The proposed multiple regression equation was calcu- lated with the function LINEST. This method was not only a flexible method, but also could avoid high expenditure and fixed algorithm while using other professional software for data processing. The validation experiments showed that the extraction rate of proanthocyanidins from sea buckthorn seeds revealed an increase by 16.43%. This method is easy to extend and may hold promise for other scientific applications.

关 键 词：优化 均匀设计 LINEST 回归方程 原花色素 

分 类 号：O212.6[理学—概率论与数理统计] S788.1[理学—数学]