Full-Text Search：
《Physical Experiment of College》 2003-04

## STUDY ON HOW TO USE THE LEAST SQUARE METHOD IN THE ANALYSIS OF EXPERIMENTAL DATA

Tang Shu-guang (Nanjing Institute of Technology,Nanjing,Jiangsu,210013)
The least square method is one of the most important methods that can be used to analyze experimental data.But owing to its complicated calculation,the method is difficult to use in our teaching practice.This paper has made comparision between three calculation methods in Excel to find out the easiest way in calculation by the least square method.
【CateGory Index】： O4-33
CAJViewer7.0 supports all the CNKI file formats; AdobeReader only supports the PDF format.
 【References】
 Chinese Journal Full-text Database 6 Hits
 1 ZHENG Huifan1,2,FAN Xiaowei2,LI Angui1,ZHANG Dingcai2(1.School of Environmental & Municipal Engineering,Xi'an Univ.of Arch.& Tech.,Xi'an 710055,China;2.Energy and Environmental Engineering Dept.,Zhongyuan Institute of Technology,Zhengzhou 450007,China);Experimental data processing about air condition energy saving exchanger based on Excel[J];Sichuan Building Science;2007-05 2 Chen Yulin Ding Liuguan Zhang Lei(Nanjing University of Information Science & Technology, Nanjing, 210044);DATA PROCESS OF PHYSICS EXPERIMENT BASED ON EXCEL[J];Physical Experiment of College;2007-02 3 Liu Yuan Ding Jianhua Wang Maoren(Dalian University of Technology,Dalian,116024);HOW TO GET ACCURATE LINE BY USING EXCEL SOFTWARE IN MLS LINEAR FITTING[J];Physical Experiment of College;2008-03 4 Chai Chang Wang Cunlian(Shanxi Datong University,Datong,037003);USING THE LEAST SQUARE METHOD TO ANALYZE EXPERIMENTAL DATA IN MEASURING COPPER RESISTANCE[J];Physical Experiment of College;2008-03 5 WANG Chun-hong LIU Jia WANG Jin-can WANG Xiao-li SHI Hao-li GAN Quan (The Institute of High Energy Physics,the Chinese Academy of Sdences P.O.Box 918,100049,Beijing,China);A Linear Calibration Method In the BEPCⅡPower Supply Control[J];Nuclear Electronics & Detection Technology;2007-06 6 CHEN Yu-lin,DING Liu-guan,ZHANG Lei(Teaching Center of Physics Experiment,Nanjing Univ.of Information Science & Technology,Nanjing 210044,China);Application of Excel to Data Processing of Physics Experiment[J];Research and Exploration in Laboratory;2007-10
 【Co-citations】
 Chinese Journal Full-text Database 5 Hits
 1 CUI Yun-kang~1 ,DI Yun-song~2,WANG Tie-ping~1,JIANG Yao-mei~1(1. Department of Basic Courses,Nanjing Institute of Technology ,Nanjing 210013,China;2. College of Physical Science and Technology,Nanjing Normal University,Nanjing 210097,China);The improvement of electrostatic field simulator[J];College Physics;2005-07 2 Quan Xiaohang Lu Shoulin (The affiliated High School of South China Normal University) (Harbin Normal Unviersity);STUDY OF ECHO THRESHOLD FOR DIFFERENT KINDS OF SOUND SIGNALS[J];Natural Science Journal of Harbin Normal University;2004-02 3 SUN Hong (Dept. of Basic Courses, Nanjing Institute of Technology, Nanjing 211100, China);Reform of Examinations in Physical Experimental Course[J];Journal of Nanjing Institute of Technology;2004-02 4 QIAN Yang-de (The Center of Physics Laboratory,Nanjing Institute of Technology,Nanjing 210013,China);Development and application of 3-dimension magnetic field intellectual measurer[J];Physics Experimentation;2004-03 5 Li Ping,Zhang Mingxuan1 Hebei Normal University,Shijiazhuang,050016 2 Shijiazhuang University,Shijiazhuang,050035;LED、LD with Lamp-house of Physics Experimentation[J];China Educational Technique & Equipment;2009-06
 【Co-references】
 Chinese Journal Full-text Database 10 Hits
 1 HUANG Ping1,ZHAO Xian-qiong2,LIU Yi-lun2,HE Yu-hui2,ZHANG Ying2(1.CHINALCO-SWA Co.Ltd.Chongqing 401236;2.College of Mechanical and Electrical Engineering,Central South University,Changsha 410083,China);3-D SIMULATION AND STUDY ON ALUMINIUM STRIP'S RUNNING DEVIATION IN HOT ROLLING PROCESS[J];Journal of Beijing Technology and Business University(Natural Science Edition);2007-03 2 HU Xian-lei, ZHAO Zhong, QIU Hong-lei, LIU Xiang-hua enyang 110004, China. );Application of Crown-Flatness Vector Method in Plate Draft Schedule[J];JOURNAL OF NORTHEASTERN UNIVERSITY;2004-04 3 Yin Teng XU Cheng SUN Jiajun (Anshan Institute of Iron And Steel Technology,Anshan 114002);THE APPLICATION OF EXCEL IN THE PHYSICAL EXPERIMENT TEACHING[J];College Physical Experiment;2002-03 4 Dai Xiaoli Zhao Xianming (Northeastern University);ANALYSIS OF MECHANISM AND CAUSES FOR HOT STRIP ROLLING SIDE-CAMBER FORMATION[J];Reseach On Iron and Steel;2002-06 5 DAI Xiao-li 1,ZHAO Xian-ming 2 (1.The Institute of Technology Research,Shoudu Iron and Steel Co.,Beijing 100041,China 2.The Stake Key Lab of Rolling Technology and Automation,Northeastern University, Shenyang 110004,China);DYNAMIC SIMULATION OF MEANDER IN HOT STRIP ROLLING[J];Research On Iron and Steel;2004-04 6 MA Zheng-gui (Nanjing Iron & Steel Co. Ltd.,Nanjing 210035,China);Strip Shape Control of Medium Plate Rolling Mill[J];Journal of Anhui University of Technology(Natural Science);2008-03 7 DAI Xiao li,ZHAO Xian ming,WANG Guo dong (The State Key Laboratory of Rolling and Automation, Northeastern University,Shenyang 110004,China);Simulation of camber control for rough mill of hot strip rolling[J];Journal of Materials and Metallurgy;2003-01 8 YAN Qing~1,PENG Xiao-ping~2 (1.Department of Mathematics and Computer,Shangrao Teachers' College,Shangrao334001,China; 2.Department of Chemistry,Shangrao Teachers' College,Shangrao334001,China);Application of Excel in Dealing with Data of Chemistry and Chemical Industry[J];Computer and Modernization;2004-04 9 WANG Hongrui, SU Fei, WANG Shouyu and SONG Weigong (Institute of Electrical Engineering,Yanshan University·Qinhuangdao,066004,P.R.China);The Application of Model Reference Adaptive Control to Keeping Identical Pressing Character of Both Sides of Rolling Mill[J];CONTROL THEORY & APPLICATIONS;1999-01 10 LIN Gao YANG Lu(Southwest Aluminum (Group) Co. Ltd, 401326, Chongqing);Alignment Controlling Process of Edge Trimming for 3104 Hot Finished Coils[J];Aluminum Fabrication;2003-04
 【Secondary References】
 Chinese Journal Full-text Database 2 Hits
 1 TIAN Hongmei,QIN Haoquan,TENG Jian(Industrial Training Centre,Shenzhen Polytechnic,Shenzhen,Guangdong 518055,China);Data Processing in Experiment with Resistance Strain Sensor Based on Excel[J];Journal of Shenzhen Polytechnic;2008-03 2 TIAN Hong-mei(Physics Laboratory,Shenzhen Polytechnic,Shenzhen 518055,China);Data processing of "magnetic field distribution in cross section of ferromagnet" based on Excel[J];Journal of Xi'an University of Post and Telecommunications;2008-05
Similar Journals
 > China Science and Technology Information > Popular Science & Technology > Journal of Hanshan Normal University > Journal of Guangxi Academy of Sciences > Journal of Shanghai Lixin University of Commerce > Science in 24 Hours > Physical Experiment of College > Knowledge is Power > Hunan Education Review > Statistics and Forecasting