STATISTICAL HYPOTHESIS TESTING IN EXCEL

被引：0
作者：
Hic, Pavel [1 ]
Pokorny, Milan [1 ]
机构：
[1] Trnavska Univ, Katedra Matemat & Informat, Trnava 91843, Slovakia
来源：
APLIMAT 2009: 8TH INTERNATIONAL CONFERENCE, PROCEEDINGS | 2009年
关键词：
Statistical hypothesis testing; Excel; ICT; e-learning;
D O I：
暂无
中图分类号：
O29 [应用数学];
学科分类号：
070104 ;
摘要：
The paper deals with statistical hypothesis testing in Excel. At the Faculty of Education at Trnava University a huge amount of students needs the basic knowledge of mathematical statistics to test hypothesis in their seminar or bachelor works and dissertations. The authors describe easily operated excel sheets which enable students to test their hypothesis. An e-learning course which the authors designed to integrate the sheets and videos presenting how to operate them is characterized, too.
引用
收藏
页码：663 / 666
页数：4
相关论文
共 50 条
[41]   Statistical Power Analysis with Microsoft Excel: Normal Tests for One or Two Means as a Prelude to Using Non-Central Distributions to Calculate Power [J].
Teixeira, Antonio ;
Rosa, Alvaro ;
Calapez, Teresa .
JOURNAL OF STATISTICS EDUCATION, 2009, 17 (01) :1-21
[42]   CAN MS EXCEL HELP FINANCE STUDENTS TO EXCEL? A STUDY IN STUDENT WORK READINESS [J].
Kirsten, E. ;
van Hoepen, R. ;
du Toit, E. .
SOUTH AFRICAN JOURNAL OF HIGHER EDUCATION, 2025, 39 (03) :155-172
[43]   Excel-SBOL Converter: Creating SBOL from Excel Templates and Vice Versa [J].
Mante, Jeanet ;
Abam, Julian ;
Samineni, Sai P. ;
Potzsch, Isabel M. ;
Beal, Jacob ;
Myers, Chris J. .
ACS SYNTHETIC BIOLOGY, 2023, :340-346
[44]   Fighting Fire with Fire: Using Excel Macros to Combat Academic Dishonesty in Excel Projects [J].
Lux, Don ;
Knight, Margaret E. .
ISSUES IN ACCOUNTING EDUCATION, 2021, 36 (01) :23-34
[45]   Testing statistical hypotheses concerning error characteristics of measuring devices irrespective of the distribution law form [J].
Solopchenko, GN .
MEASUREMENT TECHNIQUES, 1997, 40 (11) :1029-1037
[46]   Testing statistical hypotheses concerning error characteristics of measuring devices irrespective of the distribution law form [J].
G. N. Solopchenko .
Measurement Techniques, 1997, 40 :1029-1037
[47]   Simple Image Processing in Excel [J].
Ali, Akbar ;
Ali, Haider ;
Yousuf, Muhammad Ali .
2019 9TH IEEE INTEGRATED STEM EDUCATION CONFERENCE (ISEC), 2019, :46-47
[48]   Outsourcing Encrypted Excel Files [J].
Li, Ya-Nan ;
Wu, Qianhong ;
Tang, Wenyi ;
Qin, Bo ;
Wang, Qin ;
Miao, Meixia .
INFORMATION SECURITY PRACTICE AND EXPERIENCE, ISPEC 2017, 2017, 10701 :506-524
[49]   Solving DEA via Excel [J].
Zhu, J .
MULTI-OBJECTIVE PROGRAMMING AND GOAL PROGRAMMING, 2003, :301-306
[50]   Forecasting with Excel: Suggestions for Managers [J].
Nadler, Scott ;
Kros, John F. .
SPREADSHEETS IN EDUCATION, 2007, 2 (02)
12345