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

Authors

  • YITIAN YAO Shepherd University
  • Zhijun Wang Shepherd University
  • Qing Wang Shepherd University
  • DAVID J. Klinke West Virginia University

DOI:

https://doi.org/10.55632/pwvas.v90i1.425

Keywords:

Programming, excel spreadsheet, data analysis, C#

Abstract

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.

Downloads

Published

2018-04-02

How to Cite

YAO, Y., Wang, Z., Wang, Q., & Klinke, D. J. (2018). Software development for data analysis using multiple-curve graphs through excel spreadsheets. Proceedings of the West Virginia Academy of Science, 90(1). https://doi.org/10.55632/pwvas.v90i1.425

Issue

Section

Meeting Abstracts-Poster