| Excel在微生物培养条件优化中的应用 |
| |
| 引用本文： | 刘霞,张凯,兰宏博,周白平. Excel在微生物培养条件优化中的应用[J]. 工业微生物, 2009, 39(4): 51-54. DOI: 10.3969/j.issn.1001-6678.2009.04.0011 |
| |
| 作者姓名： | 刘霞 张凯 兰宏博 周白平 |
| |
| 作者单位： | 延安大学生命科学学院,陕西,延安,716000;陕西延安市农业监测站,陕西,延安,716000;陕西省延长县植保植检站,陕西,延安,717100;陕西省富县植保植检站,陕西,延安,727500 |
| |
| 基金项目： | 陕西省教育厅专项科研计划项目,延安大学科研基金资助项目 |
| |
| 摘 要： | 根据正交试验设计的原理,采用Microsoft Excel软件编制优化微生物培养条件的程序,并以实例说明了该程序的使用方法。结果表明,用户只需输入试验的原始数据,即可快速、准确地进行直观分析和方差分析,并可根据极差值得出最佳工艺条件,从而大大提高微生物发酵的效率。
|
| 关 键 词： | Excel 正交试验 微生物培养条件 优化 |
Application of Excel in optimization of culture conditions |
| |
| LIU Xia,ZHANG Kai,LAN Hong-bo,ZHOU Bai-ping. Application of Excel in optimization of culture conditions[J]. Industrial Microbiology, 2009, 39(4): 51-54. DOI: 10.3969/j.issn.1001-6678.2009.04.0011 |
| |
| Authors: | LIU Xia ZHANG Kai LAN Hong-bo ZHOU Bai-ping |
| |
| Affiliation: | LIU Xia , ZHANG Kai, LAN Hong-bo, ZHOU Bai-ping (1. College of Life Sciences ,Yan＇an University, Yan＇an shaanxi 716000; 2. Resources Agricultural Monitoring Station of Yan＇an , Yan＇an shaanxi 716000; 3. Station of Plant Protection and Quarantine in Yanchang County, Yanchang Shaanxi 717100; 4. Station of Plant Protection and Quarantine in Fuxian County, Fuxian Shaanxi 727500) |
| |
| Abstract: | Based on the principle of orthogonal test design, Microsoft Excel data proceeding for fermentation condition optimization were established, and then the usage of it was illustrated with an example. The results showed that the procedure could calculate visual analysis , analysis of variance and obtain the optimum culturing conditions according to the R value quickly and accurately after the user input raw data of test. Therefore, it could obviously improve the fermentation efficiency of microbe. |
| |
| Keywords: | Excel Excel orthogonal experiment culture condition of microorganism optimization |
| 本文献已被 维普 万方数据 等数据库收录！ |
|
