Is Microsoft Excel 2003 ready for the statistics classroom?

被引:0
作者
Apigian, CH [1 ]
Gambill, SE [1 ]
机构
[1] Middle Tennessee State Univ, Murfreesboro, TN 37132 USA
关键词
Excel; 2003; statistics; business statistics courses; Minitab; SPSS;
D O I
暂无
中图分类号
TP [自动化技术、计算机技术];
学科分类号
0812 ;
摘要
The primary question addressed by this article is whether or not Excel 2003 statistical capabilities have been upgraded to a level of functionality that allows its use as the primary statistical software package in statistics courses for business majors. Testing of Excel XP and earlier versions have found that results had flaws with multiple regression that included high collinearity, standard deviations that are based on large samples with little variation, normal distributions, and random number generation. This research utilized Statistical Reference Datasets from the National Institute of Standards and Technology to compare results generated from Microsoft Excel 2003, Microsoft Excel XP, Minitab Release 14, and SPSS 11.5. Results show that many of the past problems with Excel have been corrected and that Excel generates results comparable to Minitab Release 14 and SPSS 11.5.
引用
收藏
页码:27 / 35
页数:9
相关论文
共 50 条
[31]   Simulation of Acid-Base Titration Curve by Using Table-Function in Microsoft Excel [J].
Yoshimura, Norio .
JOURNAL OF COMPUTER CHEMISTRY-JAPAN, 2006, 5 (01) :29-37
[32]   Creating Multiple-Baseline Graphs With Phase Change Lines in Microsoft Excel for Windows and macOS [J].
Watts, Zoey B. ;
Stenhoff, Donald M. .
BEHAVIOR ANALYSIS IN PRACTICE, 2021, 14 (04) :996-1009
[33]   A quasi-experimental comparison of spreadsheet- and classroom-based statistics tutorials [J].
King, Warren ;
Malcolm-Smith, Susan ;
Jaftha, Jacob ;
Louw, Johann ;
Tredoux, Colin .
SOUTH AFRICAN JOURNAL OF PSYCHOLOGY, 2013, 43 (01) :34-45
[34]   A format for a plagiarism-proof online examination for calculus and linear algebra using Microsoft Excel [J].
Hoseana, Jonathan ;
Stepanus, Oriza ;
Octora, Elvina .
INTERNATIONAL JOURNAL OF MATHEMATICAL EDUCATION IN SCIENCE AND TECHNOLOGY, 2023, 54 (05) :943-961
[35]   The software development for calculating the closing energy of automotive side swing door based on Microsoft excel [J].
Li Y. ;
Ma G. ;
Gao Y. ;
Wang S. .
International Journal of Vehicle Performance, 2018, 4 (01) :15-35
[36]   Introducing a Flipped Classroom for a Statistics Course: a Case Study [J].
Triantafyllou, Evangelia ;
Tinicenko, Olga .
2014 25TH ANNUAL CONFERENCE EAEEIE (EAEEIE), 2014, :5-8
[37]   Statistics for Classroom Language Assessment: Using Numbers Meaningfully [J].
Giraldo, Frank .
HOW-A COLOMBIAN JOURNAL FOR TEACHERS OF ENGLISH, 2020, 27 (02) :135-155
[38]   Handling of computational in vitro/in vivo correlation problems by Microsoft Excel: V. Predictive absorbability models [J].
Langenbucher, Frieder .
EUROPEAN JOURNAL OF PHARMACEUTICS AND BIOPHARMACEUTICS, 2007, 67 (01) :293-299
[39]   Simulations of the cardiac action potential based on the Hodgkin-Huxley kinetics with the use of Microsoft Excel spreadsheets [J].
Wu, SN .
CHINESE JOURNAL OF PHYSIOLOGY, 2004, 47 (01) :15-22
[40]   Handling of computational in vitro/in vivo correlation problems by Microsoft Excel II. Distribution functions and moments [J].
Langenbucher, F .
EUROPEAN JOURNAL OF PHARMACEUTICS AND BIOPHARMACEUTICS, 2003, 55 (01) :77-84