Full-Text Search:
Home|Journal Papers|About CNKI|User Service|FAQ|Contact Us|中文
《Computers and Applied Chemistry》 2004-04
Add to Favorite Get Latest Update

To acquire the regression equation for chemical experiment data with Excel

ZHAO YanLing WEN XiaoGuang and FAN FuHai (The Chemistry Industry Institute of Lanzhou Jiaotong University,Lanzhou,730070,Gansu,China)  
It's often necessary to put the experimental data into equation in the research of chemical issues so as to describe the relationbetween independent variable and dependent variable in the procedure or phenomenon quantitatively.Regression analysis is one of themajor mathematical statistics to acquire such relation equation.Several methods to acquire the regression equations by means of Excelare listed in this paper.By way of examples the paper gives a brief introduction to the methods of trend line forecast method,multivari-ate linear regression and nonlinear regression,showing that by Excel the fit of most experimental data can be realized,so that the timespent on experimental data procession can be economized and the precision of the regression equations can be improved.
【CateGory Index】: TQ015.9
Download(CAJ format) Download(PDF format)
CAJViewer7.0 supports all the CNKI file formats; AdobeReader only supports the PDF format.
【References】
Chinese Journal Full-text Database 6 Hits
1 SHENG Yuanyuan;ZHANG Guibin;ZHANG Guangpeng;SUN Peicong;LIU Hailin;College of Resources and Environmental Engineering, Shandong University of Science and Technology;;Analysis on Water Level Variation of Quaternary Loose Aquifer in Shallow Region in Baodian Coal Mine[J];矿业安全与环保;2013-05
2 Wu Shaogui~*,Liu Guojun,Xu Chenggang,Liao Jie and Lin Dunmin (College of Chemistry and Materials Sciences,Sichuan Normal University,Chengdu,610068,Sichuan,China);Application of C language on chemical engineering experiment"Characteristic Curve Measurement of Centrifugal Pump"[J];计算机与应用化学;2011-05
3 Chen Guoqiang,Huang Junjie He’nan polytechnic university,Jiaozuo,454003,China;Application of data processing software in error theory teaching[J];中国现代教育装备;2010-07
4 Li Benxiang Dong Xinrong Zeng Kui (College of Science Hunan Agricultural University,Changsha,410128,Hunan,China);Application of Matlab in chemical experiment data and model parameters fitting function[J];计算机与应用化学;2007-09
5 KONG Xiang-zhong,WANG Feng-qi,WANG Wen-cai,DU Yu-ming,GUO Wei(School of Mechanical Engineering,Tianjin University,Tianjin 300072,China);Structural design and parametric optimization of extra-large typed roller support[J];机械设计;2006-02
6 LIU Huan, LE GuoWei, SHI YongHui and LI GuanHong (School of Food Science and Technology, Southern Yangtze University, Wuxi, 214036, Jiangsu, China);Structural parameterization and QSAR of two dipeptide inhibitor of ACE[J];计算机与应用化学;2005-08
【Co-references】
Chinese Journal Full-text Database 10 Hits
1 WANG Xiaozhen1,2,XU Jialin1,2,ZHU Weibing1,2,HAO Xianjie1,2(1.State Key Laboratory of Coal Resources and Safety Mining,China University of Mining and Technology,Xuzhou,Jiangsu 221008,China;2.School of Mines,China University of Mining and Technology,Xuzhou,Jiangsu 221116,China);RESEARCH ON CONNECTED EFFECT BETWEEN WATER LEVEL VARIATION OF UNCONSOLIDATED CONFINED AQUIFER AND ROOF WEIGHTING AND ITS APPLICATION[J];岩石力学与工程学报;2011-09
2 WANG Min1,SUN Min1,ZENG Rui2(1.Research Institute of Exploration and Development,SINOPEC Southwest Oil and Gas Company,Chengdu,Sichuan 610081,China;2.Faculty of Information Engineering and Automation,Kunming University of Science and Technology,Kunming,Yunnan 650051,China);Application of America Surfer8.0 on Evaluation of Groundwater Quality[J];环境监控与预警;2011-04
3 Liu Yulan,Qi Mingzhai;Application of Excel on Teaching and Learning Principles of Chemical Engineering[J];化工高等教育;2009-06
4 Peng Xiaoping~1 Yan Qing~2(1.Department of Chemistry,Shangrao Normal University,Shangrao,334001,Jiangxi,China;2.Department of Mathematics and Computer,Shangrao Normal University,Shangrao,334001,Jiangxi,China);Extracted calculation of the Excel VBA diagrammatic method[J];计算机与应用化学;2008-11
5 Guo Xiangkun~1 Jiang Linhua~1 Xu Deping~1 Xiong Chu'an~(1,2) Zhao Xin~1(1.School of Chemical & Environmental Engineering,China University of Mining and Technology,Beijing,100083,China;2.Resource and Environment Engineering Depertment.Heilongjiang Institute of Science and Technology,Haerbin,150027,Heilongjiang,China);MATLAB application in internal chemistry and chemical engineering[J];计算机与应用化学;2008-11
6 CHENGuo-qiang,SHANGXian-guang,ZHAOJun-wei(School of Mechanical and Power Engineering,Henan Polytechnic University,Jiaozuo 454003,China);Principle and realization for generating data sequence with errors[J];河南理工大学学报(自然科学版);2008-05
7 TANG Jia-de (Department of Mathematics,Chuxiong Normal University,Chuxiong 675000,China);Nonlinear Curve Fitting Based on MATLAB[J];计算机与现代化;2008-06
8 Wang Shujie Tian Wende~* Li Chuankun (College of Chemical Technology,Qingdao University of Science & Technology,Qingdao,266042,Shandong,China);Computer-aided calculation of heat transfer in unit operations[J];计算机与应用化学;2008-02
9 HE Xu-wen1,YANG Jing1,SHAO Li-nan1,LI Fu-qin2,WANG Xin1(School of Chemical and Environment Engineering,China University of Mining and Technology(Beijing),Beijing 100083,China;2.College of Urban Construction,Hebei University of Engineering,Handan 056038,China);Problem and countermeasure of mine water resource regeneration in China[J];煤炭学报;2008-01
10 Huang Guojun1 Dong Shouhua2 Li Donghui2(1 Geological Survey Bureau,Pingdingshan Coal Co.,Ltd.;2 School of Resources and Geoscience,China University of Mining and Technology);Treating Methods and Comprehensive Utilization Technique of Coal Mine Water[J];矿业快报;2007-04
【Secondary References】
Chinese Journal Full-text Database 8 Hits
1 DONG Xue-yao;ZHENG Chun-xiang;;Research and Application of Research Learning in High School Mathematics Based on MATLAB[J];信息技术与信息化;2016-09
2 GAO Xuetong;North China Nonferrous Engineering Survey Institute Co.,Ltd.;;Experiment Study of Pore Water Pressure Fluctuation and Influence Mechanism in Bottom Aquifer during Mining[J];矿业安全与环保;2016-02
3 Zeng Weijun;Zhang Yunwei;Chen Ling;Wang Dalong;Dong Xiaowei;Wang Yanjun;Faculty of Modern Agricultural Engineering, Kunming University of Science and Technology;Faculty of Information Engineering and Automation, Kunming University of Science and Technology;;Dynamic measured system for hillslope runoff rate and sediment concentration based on time method and illumination method[J];农业工程学报;2014-24
4 LI Qing-bo;DIAO Jing-jing;JING Xue-lian;LI Yu-nan;CAO Long-kui;College of Food Science,Heilongjiang Bayi Agricultural University;National Coarse Cereals Engineering Research Center;;Purification,Structure Identification and Structure-activity Relationship of Mung Bean Dregs ACE Inhibition Peptides[J];农产品加工(学刊);2014-21
5 Geng Qingguang;Li Bu;SINOPEC Luoyang Company;;CALCULATION OF REACTION EQUILIBRIUM TEMPERATURE IN ACID GAS COMBUSTION FURNACE OF SULFUR RECOVERY UNIT USING MATLAB[J];石油化工设计;2014-02
6 WANG Qiang1,WANG Chun-yan1,2,HU Hui1,LIU Hong-zhi1,LIU Li1(1.Key Laboratory of Agro-products Processing,Ministry of Agriculture,Institute of Agro-products Processing Science and Technology,Chinese Academy of Agricultural Sciences,Beijing 100193,China;2.College of Food Science,Shenyang Agricultural University,Shenyang 110866,China);Structural Characterization and Structure-activity Relationship of ACE Inhibitory Peptides from Peanut[J];食品科学;2013-09
7 LIU Jing1,PENG Jian-qiu2,GUAN Xiao2(1.College of Information Engineering,Shanghai Maritime University,Shanghai 201306;2.School of Medical Instrument and Food Engineering,University of Shanghai for Science and Technology,Shanghai 200093);Modeling the QSAR of ACE Inhibitory Peptides Based on MLR[J];分析科学学报;2012-01
8 HUANG De-chun,DAI Lin,SHI Yi-qiang,WANG Zhi-xiang(School of Pharmacy,China Pharmaceutical University,Nanjing 210009,China);Model Calculation and Data Process of Solution Crystallization Based on MATLAB[J];南京理工大学学报;2011-04
©2006 Tsinghua Tongfang Knowledge Network Technology Co., Ltd.(Beijing)(TTKN) All rights reserved