Excel Templates: A Helpful Tool for Teaching Statistics
| Autor: | Alejandro Quintela-del-Río, Mario Francisco-Fernández |
|---|---|
| Rok vydání: | 2017 |
| Předmět: |
Statistics and Probability
Descriptive statistics Exploit business.industry Computer science General Mathematics Carry (arithmetic) 05 social sciences 01 natural sciences 010104 statistics & probability Software Template 0502 economics and business Statistics Web page 050207 economics 0101 mathematics Statistics Probability and Uncertainty business Complement (set theory) Statistical hypothesis testing |
| Zdroj: | The American Statistician. 71:317-325 |
| ISSN: | 1537-2731 0003-1305 |
| DOI: | 10.1080/00031305.2016.1186115 |
| Popis: | This article describes a free, open-source collection of templates for the popular Excel (2013, and later versions) spreadsheet program. These templates are spreadsheet files that allow easy and intuitive learning and the implementation of practical examples concerning descriptive statistics, random variables, confidence intervals, and hypothesis testing. Although they are designed to be used with Excel, they can also be employed with other free spreadsheet programs (changing some particular formulas). Moreover, we exploit some possibilities of the ActiveX controls of the Excel Developer Menu to perform interactive Gaussian density charts. Finally, it is important to note that they can be often embedded in a web page, so it is not necessary to employ Excel software for their use. These templates have been designed as a useful tool to teach basic statistics and to carry out data analysis even when the students are not familiar with Excel. Additionally, they can be used as a complement to other anal... |
| Databáze: | OpenAIRE |
| Externí odkaz: |
|