Teaching statistics with Excel and R
Matteo Dell'Omodarme, Giada Valle
Abstract
Despite several deficiencies, the use of spreadsheets in statistics courses is increasingly common. In this paper we discuss many shortcomings resulting from this approach. We suggest a technique integrating a spreadsheet and a dedicated software package (R), that takes advantage of the characteristics of both programs. We also present a simple protocol of transferring data from the spreadsheet to R that can be safely used even in introductory courses.
Create a lesson
Related papers
Multi-fidelity Monte Carlo estimation of floor response spectra under combined seismic and structural parameter uncertainties
Nils Baillie, Baptiste Kerleguer, Cyril Feau et al.
Parameter inference from a non-stationary unknown process using statistical feature-based slow feature analysis
Kieran S. Owens, Masako Tamaki, Ben D. Fulcher
A Probability Model for Pentagonal Prism Dice Rolls
Paul R. Hurst, J. Naleo Hyde
Geometry-native machine learning reconstruction of DSMC moment fields with support monitoring
Ehsan Roohi
Multivariate amplitude analysis of the cascade particle decays based on the Nearest Neighbors fitting
I. V. Yeletskikh, A. O. Vasyukov
The geometry of uncertainty decomposition in profile-likelihood fits
Rafael Coelho Lopes de Sá