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
    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
    Becker, Louis T.
    SERIALS REVIEW, 2019, 45 (03) : 184 - 188
  • [23] PKSolver: An add-in program for pharmacokinetic and pharmacodynamic data analysis in Microsoft Excel
    Zhang, Yong
    Huo, Meirong
    Zhou, Jianping
    Xie, Shaofei
    COMPUTER METHODS AND PROGRAMS IN BIOMEDICINE, 2010, 99 (03) : 306 - 314
  • [24] Bringing Social Justice into the Statistics Classroom
    Garlington, Tamera
    Ryan, Valerie M.
    Nolty, Catherine
    Ilagan, Hannah
    Kunicki, Zachary J.
    TEACHING OF PSYCHOLOGY, 2021, 48 (03) : 269 - 274
  • [25] Applying of excel software in the teaching of probability and mathematical statistics
    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
    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
    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
    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
    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
    Langenbucher, F
    EUROPEAN JOURNAL OF PHARMACEUTICS AND BIOPHARMACEUTICS, 2003, 56 (03) : 429 - 437