Software development for data analysis using multiple-curve graphs through excel spreadsheets

YITIAN YAO, Zhijun Wang, Qing Wang, DAVID J. Klinke


Data analysis plays an essential in research involving large simulation and experimental data. The graphs that generated by data collections can be convenient and helpful for researchers to analyze the trend of samples. However, spending large amount of time on handling and graphing data collections can carry the concentration away from the researchers. This study focuses on programming a software application with simple user interface to handle data and generate graph in Excel Spreadsheets. For instance: transferring 300 data sets from .txt files to Excel workbooks, then pick X% (dynamic percentage according to user input) confidence section points and median value for each group of files to generate three curves with discrete data points. Human can repeat this task 10 times within a short period of time, but the work become tedious when there are hundreds of folders containing thousands of data files. Therefore, generating graphs using programming method can dramatically improve the efficiency of work. In addition, human can easily make some mistakes after working on plenty of repetitive task. The method of developing software can greatly increase the accuracy of data transferring and analysis. This project was supported by NIH Grant P20GM103434 to the West Virginia IDeA Network for Biomedical Research Excellence and the Research Challenge Fund through a Summer Undergraduate Research Experience Grant from the West Virginia Higher Education Policy Commission Division of Science and Research.


Programming; excel spreadsheet; data analysis; C#

Full Text:


Copyright (c) 2018 Proceedings of the West Virginia Academy of Science

Creative Commons License
This work is licensed under a Creative Commons Attribution-NonCommercial 4.0 International License.