Statistical tools of Excel
The result's identifiers
Result code in IS VaVaI
<a href="https://www.isvavai.cz/riv?ss=detail&h=RIV%2F60460709%3A41110%2F17%3A77066" target="_blank" >RIV/60460709:41110/17:77066 - isvavai.cz</a>
Result on the web
—
DOI - Digital Object Identifier
—
Alternative languages
Result language
čeština
Original language name
Statistical tools of Excel
Original language description
Use of computer technologies has become an integral part of statistics education at all levels of schools. This paper shows how the widespread program MS Excel can be used for teaching/learning of statistics. Statistical calculations in Excel are enabled through following three main options - statistical functions, add-in Analysis ToolPak and graphical tools. In one example relating to correlation it is shown that Excel can also be used for calculating of multiple and partial correlation and regression. Excel remains a good tool not only for scientific work but also for teaching statistics in schools and universities. It can substitute statistical programs even in relatively advanced topics.
Czech name
Statistical tools of Excel
Czech description
Use of computer technologies has become an integral part of statistics education at all levels of schools. This paper shows how the widespread program MS Excel can be used for teaching/learning of statistics. Statistical calculations in Excel are enabled through following three main options - statistical functions, add-in Analysis ToolPak and graphical tools. In one example relating to correlation it is shown that Excel can also be used for calculating of multiple and partial correlation and regression. Excel remains a good tool not only for scientific work but also for teaching statistics in schools and universities. It can substitute statistical programs even in relatively advanced topics.
Classification
Type
D - Article in proceedings
CEP classification
—
OECD FORD branch
10103 - Statistics and probability
Result continuities
Project
—
Continuities
S - Specificky vyzkum na vysokych skolach
Others
Publication year
2017
Confidentiality
S - Úplné a pravdivé údaje o projektu nepodléhají ochraně podle zvláštních právních předpisů
Data specific for result type
Article name in the collection
16th Conference on Applied Mathematics APLIMAT 2017 - Proceedings
ISBN
978-80-227-4649-6
ISSN
—
e-ISSN
—
Number of pages
6
Pages from-to
1101-1106
Publisher name
Slovenská Technická Univerzita
Place of publication
Bratislava
Event location
Bratislava
Event date
Jan 31, 2017
Type of event by nationality
WRD - Celosvětová akce
UT code for WoS article
—