Abstract:Using regression analysis to process college physical experimental data may reduce tedious and complex manual calculations by data processing software and improve the accuracy of the experimental data processing results. The application of linear and nonlinear regression analysis, especially piecewise regression analysis was discussed in college physical experiment of data processing using Excel and Origin software through some examples in this paper. The detail procedure for college physical experiment of data processing using the regression analysis was given and the processing results were demonstrated by figures with a more direct and visual way. The advantages and disadvantages of regression analysis using different software for physical experimental data processing were also discussed. Applying regression analysis to process college physical experimental data through using computer application software can deepen the student to master physical experiment of college, boost the teaching quality for physical experiment of college and enhance the efficiency of student in learning.

Application of Excel Trend Line in Data Processing of Physical Experiment of College

Application of Regression Analysis in Data Processing of Physical Experiment of College

The practice into the Application of ORIGIN Software in the senior high school's Physical experiment

Computer-aided calculating in data analysis of pharmaceutics with Microsoft Excel

The Application of Excel in Curve Fitting

Application of Microsoft Excel: A simple and convenient tool for data analysis in medical research

Design and Application of Programs in Physical Chemistry Experimental Data Processing

Practical Skills for Statistical Analysis of Medical Quality Control Data with the Software EXCEL

Several Simple Methods of Data Processing Based on Excel

APPLYING AND COMPARING TO ORIGIN AND EXCEL IN TREATING DATA OF THE PHYSICS EXPERIMENT

Processing Biology and Chemistry Experiment Data with Java

The Application on Data Processing of the Regression Analysis Function of Excel

The Application of Excel in Probability and Statistics of Middle School Mathematics

INVESTIGATION OF SOFTWARE ON COLLEGE PHYSICAL EXPERIMENT DATA PROCESSING

Application of EXCEL in Theoretical Teaching

The Application of Excel Software in the Teaching Course of Probability and Mathematical Statistics

Implementation in P. R. China of Computer Aided SPC Using MS EXCEL 2000

Accomplishing and Applying the Excel Program on Meta-Analysis for Medical Data of P, U, T, F and Χ~2-Values

The Application of EXCEL and ORIGIN in Data Processing of “HPGe Detector Efficiency Calibration”

Application of Excel in Evaluating the Teaching Workload of Teachers