English
Related papers

Related papers: Teaching statistics with Excel and R

200 papers

The growing influence of data science in statistics education requires tools that make key concepts accessible through real-world applications. We introduce "Data Science Looks At Discrimination" (dsld), an R package that provides a…

The frequency with which spreadsheets are used and the associated risk is well known. Many tools and techniques have been developed which help reduce risks associate with creating and maintaining spreadsheet. However, little consideration…

Human-Computer Interaction · Computer Science 2009-08-13 Mel Glass , David Ford , Sebastian Dewhurst

Recent research has highlighted the high incidence of errors in spreadsheet models used in industry. In an attempt to reduce the incidence of such errors, a teaching approach has been devised which aids students to reduce their likelihood…

Computers and Society · Computer Science 2024-12-31 David Chadwick , Rodney E. Sue

This paper presents the findings of a case study of spreadsheet use in a higher education institution in the UK. The paper considers the use of spreadsheets in two units of the organisation, academic registry and finance. Spreadsheet use is…

Computers and Society · Computer Science 2019-09-18 Simon Thorne , Jamie Hancock

Modern spreadsheet systems can be used to implement complex spreadsheet applications including data sheets, customized user forms and executable procedures written in a scripting language. These applications are often developed by…

Software Engineering · Computer Science 2015-03-12 Domenico Amalfitano , Nicola Amatucci , Vincenzo De Simone , Anna Rita Fasolino , Porfirio Tramontana

As the demand for jobs in data science increases, so does the demand for universities to develop and facilitate modernized data science curricula to train students for these positions. Yet, the development of these courses remains…

Other Statistics · Statistics 2025-08-07 Elijah Meyer , Mine Çetinkaya-Rundel

The capability of R to do symbolic mathematics is enhanced by the caracas package. This package uses the Python computer algebra library SymPy as a back-end but caracas is tightly integrated in the R environment. This enables the R user…

Applications · Statistics 2023-08-22 Mikkel Meyer Andersen , Søren Højsgaard

Spreadsheets are among the most commonly used applications for data management and analysis. Perhaps they are even among the most widely used computer applications of all kinds. They combine in a natural and intuitive way data processing…

Databases · Computer Science 2016-05-04 Jacek Sroka , Adrian Panasiuk , Krzysztof Stencel , Jerzy Tyszkiewicz

This paper presents an R package to handle and represent measurements with errors in a very simple way. We briefly introduce the main concepts of metrology and propagation of uncertainty, and discuss related R packages. Building upon this,…

Computation · Statistics 2019-08-02 Iñaki Ucar , Edzer Pebesma , Arturo Azcorra

The paper presents two complementary strategies for identifying errors in spreadsheet programs. The strategies presented are grounded on the assumption that spreadsheets are software, albeit of a different nature than conventional…

Software Engineering · Computer Science 2011-02-19 Yirsaw Ayalew , Markus Clermont , Roland T. Mittermeir

Nolan and Temple Lang (2010) argued for the fundamental role of computing in the statistics curriculum. In the intervening decade the statistics education community has acknowledged that computational skills are as important to statistics…

Other Statistics · Statistics 2022-10-11 Nicholas J. Horton , Johanna S. Hardin

Selecting a subset of cells is a common task in data engineering, for example, to remove errors or select only specific parts of a table. Multiple approaches to express this selection exist. One option is numeric indexing, commonly found in…

Programming Languages · Computer Science 2025-05-30 Philip Heltweg , Dirk Riehle , Georg-Daniel Schwarz

Algebraic methods have a long history in statistics. The most prominent manifestation of modern algebra in statistics can be seen in the field of algebraic statistics, which brings tools from commutative algebra and algebraic geometry to…

Computation · Statistics 2017-06-27 David Kahle , Christopher O'Neill , Jeff Sommars

Probabilistic forecasts in the form of probability distributions over future events have become popular in several fields including meteorology, hydrology, economics, and demography. In typical applications, many alternative statistical…

Computation · Statistics 2018-07-31 Alexander Jordan , Fabian Krüger , Sebastian Lerch

Data visualization is a core part of statistical practice and is ubiquitous in many fields. Although there are numerous books on data visualization, instructors in statistics and data science may be unsure how to teach data visualization,…

Other Statistics · Statistics 2025-07-31 Zach Branson , Monica Paz Parra , Ronald Yurko

R is a robust open-source programming language mainly used for statistical computing . Many areas of statistical research are experiencing rapid growth in the size of data sets. Methodological advances drive increased use of simulations. A…

Programming Languages · Computer Science 2019-04-10 Rahim K. Charania

The history and current status of the cross-disciplinary fields of astrostatistics and astroinformatics are reviewed. Astronomers need a wide range of statistical methods for both data reduction and science analysis. With the proliferation…

Instrumentation and Methods for Astrophysics · Physics 2017-06-14 Eric D. Feigelson

The R software has become popular among researchers due to its flexibility and open-source nature. However, researchers in the fields of public health and epidemiological studies are more customary to commercial statistical softwares such…

Working with complex data is one of the important updates to the 2014 ASA Curriculum Guidelines for Undergraduate Programs in Statistical Science. Infusing 'authentic data experiences' within courses allow students opportunities to learn…

Other Statistics · Statistics 2015-08-03 Scott D. Grimshaw

Developing an error-free spreadsheet has been a problem since the beginning of end-user computing. In this paper, we present a methodology that separates the modeling from the implementation. Using proven techniques from Information Systems…

Software Engineering · Computer Science 2015-06-09 Paul Mireault