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 条
  • [21] Teaching statistics with Excel 2007 and other spreadsheets
    Nash, John C.
    COMPUTATIONAL STATISTICS & DATA ANALYSIS, 2008, 52 (10) : 4602 - 4606
  • [22] Excel as a teaching tool in the subjects of microeconomics
    Almenar Llongo, Vicent
    Hernandez Sancho, Francesc
    ATTIC-REVISTA D INNOVACIO EDUCATIVA, 2009, (03): : 108 - 114
  • [23] Excel, a teaching tool for OR/MS topics
    Andrews, RL
    Ragsdale, CT
    Evans, JR
    DECISION SCIENCES INSTITUTE 1998 PROCEEDINGS, VOLS 1-3, 1998, : 1074 - 1074
  • [24] 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
  • [25] Improving the teaching of Microsoft Excel: Traditional book versus online platform
    Brooks, Stoney
    Taylor, Joseph
    JOURNAL OF EDUCATION FOR BUSINESS, 2016, 91 (05) : 251 - 257
  • [26] Using Microsoft Excel® to Teach Statistics in a Graduate Advanced Practice Nursing Program
    DiMaria-Ghalili, Rose Ann
    Ostrow, C. Lynne
    JOURNAL OF NURSING EDUCATION, 2009, 48 (02) : 106 - 110
  • [27] Teaching an Introductory Data Analytics Course Using Microsoft Access® and Excel®
    Aqlan, Faisal
    Nwokeji, Joshua C.
    Shamsan, Abdulrahman
    2020 IEEE FRONTIERS IN EDUCATION CONFERENCE (FIE 2020), 2020,
  • [28] Accelerating the Performance of DES on GPU and a Visualization Tool in Microsoft Excel Spreadsheet
    Prabha, Pinchu
    Sikha, O. K.
    Suchithra, M.
    Soman, K. P.
    COMPUTATIONAL INTELLIGENCE, CYBER SECURITY AND COMPUTATIONAL MODELS, 2014, 246 : 405 - 411
  • [29] Application of the microsoft excel solver tool in the optimization of distillation sequences problems
    Briones, Laura
    Morales, Victoria
    Iglesias, Jose
    Morales, Gabriel
    Escola, Jose M.
    COMPUTER APPLICATIONS IN ENGINEERING EDUCATION, 2020, 28 (02) : 304 - 313
  • [30] A Microsoft Excel (R) 2010 Based Tool for Calculating Interobserver Agreement
    Reed, Derek D.
    Azulay, Richard L.
    BEHAVIOR ANALYSIS IN PRACTICE, 2011, 4 (02) : 45 - 51