结合实际测量数据,采用Origin8.0软件通过图像斜率法计算的合肥地区的重力加速度,实验计算结果表明利用图像斜率法求加速度非常准确和高效,相对误差仅为0.004%。
At present,the detection of data for many instruments may last months or even years,and there is massive amounts of data for consecutive working.It is slow,labor-intensive and error-prone to manually process such massive amounts of data,and the advantage of the instrument is weakened by manual processing.So,it is necessary to research the methods of automatic and efficient data analysis.Excel is prevalent,and can be applied for numerous statistical projects.This study mainly investigates the application of Excel software on the processing of time series experimental data.Based on the time response data of experimental detection,the tested data are processed for the specified criteria using Excel software,and the calculation results of the average,the standard deviation,the median and percentile of laboratory data are obtained.Results show that this method can make data processing easier,and this analytical method can be widely used in data analysis.