Excel在化工计算中的若干应用  

Several Applications of Excel to Chemical Engineering Computation

作　　者：刘松晖[1] Liu Songhui(Linjiang institute, Hangzhou Vocational & Technical College, Hangzhou 310018, China)

机构地区：[1]杭州职业技术学院临江学院,浙江杭州310018

出　　处：《广东化工》2019年第7期266-267,256,共3页Guangdong Chemical Industry

摘　　要：在化工问题研究和化工教学中,经常涉及两方面的复杂计算问题:一是把实验数据整理为方程式,以定量描述过程自变量与因变量之间的关系,即回归分析问题,其中主要包括一元线性回归、多元线性回归;二是非线性方程求解问题,包括一元非线性方程和多元非线性方程的求解。本文以几个典型的化工计算问题为例介绍如何采用Excel 2010的回归分析、单变量求解和规划求解功能解决上述计算问题,从中可以看出相对采用Matlab、Fortran等语言编程计算方法,Excel具有快捷、高效的特点。Two types of complex computation problems are common in chemical engineering research and education. One is the regression analysis problems that make experiment dat a to math equations to descript quantitatively relationship between the independent variable and dependent variable, this includes univariate linear regression and multivariate linear regression;The other is the solving problems of nonlinear equations which includes univariate nonlinear equations and multivariate nonlinear equations. Some typical chemical engineering computation problems are taken for example in this paper to demonstrate how to solve those problems with regression analysis function, goal seeking function and programming solver function of Excel 2010. As this paper shows, Excel is more efficient and quicker than Matlab or Fortran programming computation.

关 键 词：EXCEL 一元线性回归 多元线性回归 单变量求解 规划求解 

分 类 号：TQ011[化学工程]