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 条
  • [2] Error messages when calculating chi-square statistics with Microsoft EXCEL®
    Cabaleiro, DR
    Stöckl, D
    Thienpont, LM
    CLINICAL CHEMISTRY AND LABORATORY MEDICINE, 2004, 42 (02) : 243 - 243
  • [3] Microsoft Excel: a tool for research
    Perez Gonzalez, Luis Orlando
    MEDISUR-REVISTA DE CIENCIAS MEDICAS DE CIENFUEGOS, 2006, 4 (03): : 68 - 71
  • [4] Mapping Injury Prevention With Microsoft Excel
    Sharrah, Mark L.
    Bechtel, Kaitlin E.
    JOURNAL OF TRAUMA NURSING, 2022, 29 (02) : 92 - 96
  • [5] Integrating BOINC with microsoft excel: A case study
    Zhang, Jingri
    Mustafee, Navonil
    Saville, Jon
    Taylor, Simon J. E.
    PROCEEDINGS OF THE ITI 2007 29TH INTERNATIONAL CONFERENCE ON INFORMATION TECHNOLOGY INTERFACES, 2007, : 733 - +
  • [6] Find the maximum flow in a graph using Microsoft Excel and macros
    Sobolu, Rodica
    Sobolu, G.
    Bulletin of the University of Agricultural Science and Veterinary Medicine, Vol 62, 2005: HORTICULTURE, 2005, 62 : 327 - 332
  • [7] Targeting the Water-using Network based on Microsoft EXCEL
    Jia, Xiao-Ping
    Liu, Cai-Hong
    2011 INTERNATIONAL CONFERENCE ON MACHINE INTELLIGENCE (ICMI 2011), PT 2, 2011, 4 : 255 - 259
  • [8] An add-in implementation of the RESAMPLING syntax under Microsoft EXCEL
    Meineke, I
    COMPUTER METHODS AND PROGRAMS IN BIOMEDICINE, 2000, 63 (02) : 99 - 104
  • [9] A scaffolded learning approach to increasing student comfort with Microsoft Excel
    Weathers, Danny
    Swain, Scott D.
    JOURNAL OF MARKETING ANALYTICS, 2024, 12 (02) : 198 - 208
  • [10] PetroPlot: A plotting and data management tool set for Microsoft Excel
    Su, YJ
    Langmuir, CH
    Asimow, PD
    GEOCHEMISTRY GEOPHYSICS GEOSYSTEMS, 2003, 4