基于Excel的海量有序实验数据处理方法研究

主要介绍Excel在处理连续测量的时间有序实验数据中的应用。根据测量得到的海量时间响应数据,实现利用excel处理指定条件下的数据,求取平均值、标准偏差、中间值以及百分位数等。

The Study on the Processing Method of Massive Amounts of Orderly Experimental Data Based on Excel Software

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.