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 条
  • [1] Basic statistics with Microsoft Excel: a review
    Divisi, Duilio
    Di Leonardo, Gabriella
    Zaccagna, Gino
    Crisci, Roberto
    JOURNAL OF THORACIC DISEASE, 2017, 9 (06) : 1734 - 1740
  • [2] Excel Templates: A Helpful Tool for Teaching Statistics
    Quintela-del-Rio, Alejandro
    Francisco-Fernandez, Mario
    AMERICAN STATISTICIAN, 2017, 71 (04): : 317 - 325
  • [3] Microsoft Excel: a tool for research
    Perez Gonzalez, Luis Orlando
    MEDISUR-REVISTA DE CIENCIAS MEDICAS DE CIENFUEGOS, 2006, 4 (03): : 68 - 71
  • [4] Learning business statistics with Microsoft Excel
    Brennan, LL
    INTERFACES, 1998, 28 (06) : 79 - 80
  • [5] BASIC STATISTICS IN EXCEL
    Ceballos Urrego, Leonardo
    CUADERNO ACTIVA, 2011, (01): : 37 - 43
  • [6] Teaching comparative statics with Microsoft Excel
    Barreto, H
    JOURNAL OF ECONOMIC EDUCATION, 2001, 32 (04): : 397 - 397
  • [7] Is Microsoft Excel 2003 ready for the statistics classroom?
    Apigian, CH
    Gambill, SE
    JOURNAL OF COMPUTER INFORMATION SYSTEMS, 2004, 45 (02) : 27 - 35
  • [8] Remote Teaching of AB Graphs in Microsoft Excel
    Mondati, Ashley D.
    Reeve, Sharon A.
    Vladescu, Jason C.
    DeBar, Ruth M.
    Thomas, Rachel R.
    BEHAVIOR ANALYSIS IN PRACTICE, 2025, 18 (01) : 96 - 108
  • [9] Integrating Microsoft Excel into the introductory business statistics course
    Levine, DM
    DECISION SCIENCES INSTITUTE, 1997 ANNUAL MEETING, PROCEEDINGS, VOLS 1-3, 1997, : 128 - 130
  • [10] Microsoft Excel: An important tool for chemistry students
    Lapczynski, Patricia
    Pedersen, Larry D.
    ABSTRACTS OF PAPERS OF THE AMERICAN CHEMICAL SOCIETY, 2005, 230 : U891 - U891