首页 | 本学科首页   官方微博 | 高级检索  
     

联合均匀设计法和Microsoft Excel优化沙棘籽原花色素提取工艺(英文)
引用本文:田亚新,韩晓云,王运来,康传红.联合均匀设计法和Microsoft Excel优化沙棘籽原花色素提取工艺(英文)[J].食品科学,2012,33(16):91-95.
作者姓名:田亚新  韩晓云  王运来  康传红
作者单位:黑龙江大学生命科学学院;黑龙江大学化学化工与材料学院
基金项目:黑龙江省教育厅科学技术研究项目(11551376);黑龙江大学青年科学基金项目(QL200908)
摘    要:提出一个基于均匀设计方法和Microsoft Excel的LINEST函数进行试验设计优化的方法。本实验通过均匀设计方法设计沙棘籽原花色素提取工艺,然后通过LINEST函数计算多元回归方程,该方法可避免因为使用其他专业数据处理软件的花费和固定算法限制。验证实验表明:沙棘籽原花色素的提取率提高了16.43%,该方法可应用到其他实验方面。

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

Optimization of Extraction Program of Sea Buckthorn Seeds Proanthocyanidins by Combining Uniform Design and Microsoft Excel
TIAN Ya-xin,HAN Xiao-yun,WANG Yun-lai,KANG Chuan-hong.Optimization of Extraction Program of Sea Buckthorn Seeds Proanthocyanidins by Combining Uniform Design and Microsoft Excel[J].Food Science,2012,33(16):91-95.
Authors:TIAN Ya-xin  HAN Xiao-yun  WANG Yun-lai  KANG Chuan-hong
Affiliation:1.College of Life Science,Heilongjiang University,Harbin 150080,China;2.College of Chemistry and Materials Science,Heilongjiang University,Harbin 150080,China)
Abstract: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 calculated 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.
Keywords:optimization  uniform design  LINEST  regression equation  proanthocyanidins
本文献已被 CNKI 等数据库收录!
点击此处可从《食品科学》浏览原始摘要信息
点击此处可从《食品科学》下载全文
设为首页 | 免责声明 | 关于勤云 | 加入收藏

Copyright©北京勤云科技发展有限公司  京ICP备09084417号