JERAJournal of Electronic Research and Application2208-35022208-3510Bio-Byword Scientific Publishing Pty. Ltd.10.26689/jera.v8i3.7226ArticleComparison of R and Excel in the Field of Data Analysishttps://artdesignp.com/journal/JERA/8/3/10.26689/jera.v8i3.7226WangJue2024832024-06-14This research paper compares Excel and R language for data analysis and concludes that R language is more suitable for complex data analysis tasks. R language’s open-source nature makes it accessible to everyone, and its powerful data management and analysis tools make it suitable for handling complex data analysis tasks. It is also highly customizable, allowing users to create custom functions and packages to meet their specific needs. Additionally, R language provides high reproducibility, making it easy to replicate and verify research results, and it has excellent collaboration capabilities, enabling multiple users to work on the same project simultaneously. These advantages make R language a more suitable choice for complex data analysis tasks, particularly in scientific research and business applications. The findings of this study will help people understand that R is not just a language that can handle more data than Excel and demonstrate that r is essential to the field of data analysis. At the same time, it will also help users and organizations make informed decisions regarding their data analysis needs and software preferences.

Meyer DZ, Avery LM, 2008, Excel as a Qualitative Data Analysis Tool. Field Methods, 21(1): 91–112. https://doi.org/10.1177/1525822x08323985

R Core Team, 2018, R: A Language and Environment for Statistical Computing, R Foundation for Statistical Computing, viewed April 26, 2023, https://www.gbif.org/tool/81287/r-a-language-and-environment-for-statistical-computing

Grolemund G, Wickham H, 2016, R for Data Science: Import, Tidy, Transform, Visualize, and Model Data, O'Reilly Media, Newton.

Chambers JM, 2008, Programming with Data: A Guide to the S Language, Springer Science + Business Media, Berlin.

Baier T, Neuwirth E, Meo MD, 2011, Creating and Deploying an Application with (R)Excel and R. The R Journal, 3(2): 5–11. https://doi.org/10.32614/rj-2011-011

Murrell P, 2011, R Graphics, CRC Press, Boca Raton.

Su YS, 2008, It’s Easy to Produce Chartjunk Using Microsoft®Excel 2007 but Hard to Make Good Graphs. Computational Statistics & Data Analysis, 52(10): 4594–4601. https://doi.org/10.1016/j.csda.2008.03.007

Wild CJ, Pfannkuch M, 2012, The Importance of Statistical Thinking in Research. American Psychologist, 67(4): 280.

Altman N, Krzywinski M, 2015, Points of Significance: Reproducibility. Nature Methods, 12(9): 831.

Ripley BD, 2001, The R project in Statistical Computing. MSOR Connections, 1(1): 23–25. https://doi.org/10.11120/msor.2001.01010023

Gentleman R, Carey VJ, Bates DM, et al., 2004, Bioconductor: Open Software Development for Computational Biology and Bioinformatics. Genome Biology, 5(10): R80.

Burns P, 2011, The R inferno, Lulu.com.

Heiberger RM, Neuwirth E, 2009, R Through Excel: A Spreadsheet Interface for Statistics, Data Analysis, and Graphics (1st. Ed), Springer, Berlin.

Robbins D, 2011, Excel 2010 Power Programming with VBA, John Wiley & Sons, Hoboken.

Bivand RS, Pebesma E, Gómez-Rubio V, 2013, Applied Spatial Data Analysis with R, Springer, Berlin.

Guerrero H, 2019, Excel Data Analysis: Modeling and Simulation, Springer, Berlin.

Kuhn M, 2008, Building Predictive Models in R Using the Caret Package. Journal of Statistical Software, 28(5): 1–26.

Chang W, 2019, R Language for Data Science, CRC Press, Boca Raton.

Walther A, 2018, Excel vs. R: The Battle for Data Analysis Supremacy, Medium.