Microsoft Excel™ as a tool for teaching basic statistics

被引:24
|
作者
Warner, CB [1 ]
Meehan, AM [1 ]
机构
[1] Kutztown State Univ, Dept Psychol, Kutztown, PA 19530 USA
关键词
D O I
10.1207/S15328023TOP2804_11
中图分类号
G40 [教育学];
学科分类号
040101 ; 120403 ;
摘要
Many instructors use specialized statistics packages, such as SPSS or SAS/STAT in teaching quantitative and research methods courses. As an alternative to the specialized packages, Microsoft Excel (TM) offers charting capabilities and the Analysis ToolPak, which provides a set of data analysis tools beyond those normally found in spreadsheets. With Analysis ToolPak, Excel resembles what one would expect from a specialized low-level statistics Program. We have successfully integrated Excel into our introductory statistics courses and developed a tutorial manual to guide students through various statistical procedures in Excel. We present student ratings of an intermediate form of the manual and its exercises and discuss the advantages and disadvantages of using Excel rather than a specialized statistical package for teaching basic statistics.
引用
收藏
页码:295 / 298
页数:4
相关论文
共 50 条
  • [41] The production of a Microsoft Excel tool to assist in the teaching of the use of venturi tubes to calculate mass fl ow rates and their associated uncertainties
    Cooke A.
    Regan N.
    International Journal of Mechanical Engineering Education, 2010, 38 (01) : 56 - 72
  • [42] ADVANCING MICROSOFT EXCEL'S POTENTIAL FOR TEACHING DIGITAL IMAGE PROCESSING AND ANALYSIS
    Larbi, P. A.
    APPLIED ENGINEERING IN AGRICULTURE, 2018, 34 (02) : 263 - 276
  • [43] TRANSFORMING THE TEACHING OF BASIC MATHEMATICS: AN INNOVATIVE APPROACH WITH EXCEL
    Morales, Luis German Castro
    Gudino, Carlos Wilman Maldonado
    Vargas, Wendy Carolyn Morocho
    REVISTA CONRADO, 2023, 19 (93): : 177 - 185
  • [44] MELTS_Excel: A Microsoft Excel-based MELTS interface for research and teaching of magma properties and evolution
    Gualda, Guilherme A. R.
    Ghiorso, Mark S.
    GEOCHEMISTRY GEOPHYSICS GEOSYSTEMS, 2015, 16 (01): : 315 - 324
  • [45] Implementation of CTR Dairy Model Using the Visual Basic for Application Language of Microsoft Excel
    Ahmadi, A.
    Robinson, P. H.
    Elizondo, F.
    Chilibroste, P.
    INTERNATIONAL JOURNAL OF AGRICULTURAL AND ENVIRONMENTAL INFORMATION SYSTEMS, 2018, 9 (03) : 74 - 86
  • [46] Methodology of Laboratory Workshops on Computer Modeling with Programming in Microsoft Excel Visual Basic for Applications
    Huseynov, S. T.
    2013 7TH INTERNATIONAL CONFERENCE ON APPLICATION OF INFORMATION AND COMMUNICATION TECHNOLOGIES (AICT), 2013, : 416 - 420
  • [47] A method for gamma background subtraction using Visual Basic for Applications code with Microsoft Excel
    Suarez-Navarro, J. A.
    Pujol, Ll.
    Suarez-Navarro, M. J.
    Arana, M.
    Hernaiz, G.
    JOURNAL OF RADIOANALYTICAL AND NUCLEAR CHEMISTRY, 2019, 319 (03) : 1159 - 1163
  • [48] A method for gamma background subtraction using Visual Basic for Applications code with Microsoft Excel
    J. A. Suarez-Navarro
    Ll. Pujol
    M. J. Suarez-Navarro
    M. Arana
    G. Hernáiz
    Journal of Radioanalytical and Nuclear Chemistry, 2019, 319 : 1159 - 1163
  • [49] Simulation of Torricelli Effluent Flow by Using Visual Basic for Application (VBA) on Microsoft Excel
    Fajar, Dinar Maftukh
    Kurniasih, Neny
    Khairurrijal
    PROCEEDINGS OF THE 2014 INTERNATIONAL CONFERENCE ON ADVANCES IN EDUCATION TECHNOLOGY, 2015, 11 : 158 - 161
  • [50] Microsoft Excel应用技巧
    孙秀月
    网络与信息, 2008, (07) : 70 - 70