Software development for data analysis using multiple-curve graphs through excel spreadsheets
DOI:
https://doi.org/10.55632/pwvas.v90i1.425Keywords:
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
How to Cite
Issue
Section
License
Proceedings of the West Virginia Academy of Science applies the Creative Commons Attribution-NonCommercial (CC BY-NC) license to works we publish. By virtue of their appearance in this open access journal, articles are free to use, with proper attribution, in educational and other non-commercial settings.