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 条
[21]   OPTIMIZATION OF THE COMPLEX MULTI-FACILITY LOCATION PROBLEM USING MICROSOFT EXCEL [J].
Nemec, Petr ;
Smerek, Michal ;
Pekar, Ondrej ;
Pecina, Miroslav .
AD ALTA-JOURNAL OF INTERDISCIPLINARY RESEARCH, 2023, 13 (01) :332-344
[22]   Microsoft Power BI: Extending Excel to Manipulate, Analyze, and Visualize Diverse Data [J].
Becker, Louis T. .
SERIALS REVIEW, 2019, 45 (03) :184-188
[23]   Bringing Social Justice into the Statistics Classroom [J].
Garlington, Tamera ;
Ryan, Valerie M. ;
Nolty, Catherine ;
Ilagan, Hannah ;
Kunicki, Zachary J. .
TEACHING OF PSYCHOLOGY, 2021, 48 (03) :269-274
[24]   PKSolver: An add-in program for pharmacokinetic and pharmacodynamic data analysis in Microsoft Excel [J].
Zhang, Yong ;
Huo, Meirong ;
Zhou, Jianping ;
Xie, Shaofei .
COMPUTER METHODS AND PROGRAMS IN BIOMEDICINE, 2010, 99 (03) :306-314
[25]   Applying of excel software in the teaching of probability and mathematical statistics [J].
Lu, Jingli .
2010 INTERNATIONAL CONFERENCE ON EDUCATION AND SPORTS EDUCATION, VOL 1, 2010, :109-112
[26]   Computer-assisted audit tools in verification tasks Implementation in Microsoft Excel and in CaseWare IDEA [J].
Laureano, Raul M. S. ;
Pedrosa, Isabel .
2016 11TH IBERIAN CONFERENCE ON INFORMATION SYSTEMS AND TECHNOLOGIES (CISTI), 2016,
[27]   Unfolding the Drivers of Student Success in Answering Multiple-Choice Questions About Microsoft Excel [J].
Moro, Sergio ;
Martins, Antonio ;
Ramos, Pedro ;
Esmerado, Joaquim ;
Costa, Joana Martinho ;
Almeida, Daniela .
COMPUTERS IN THE SCHOOLS, 2020, 37 (02) :55-73
[28]   The Use of Microsoft Excel to Illustrate Wave Motion and Fraunhofer Diffraction in First Year Physics Courses [J].
Robinson, Garry ;
Jovanoski, Zlatko .
SPREADSHEETS IN EDUCATION, 2011, 4 (03)
[29]   Creating Multiple-Baseline Graphs With Phase Change Lines in Microsoft Excel for Windows and macOS [J].
Zoey B. Watts ;
Donald M. Stenhoff .
Behavior Analysis in Practice, 2021, 14 :996-1009
[30]   Handling of computational in vitro/in vivo correlation problems by Microsoft Excel: III. Convolution and deconvolution [J].
Langenbucher, F .
EUROPEAN JOURNAL OF PHARMACEUTICS AND BIOPHARMACEUTICS, 2003, 56 (03) :429-437