Microsoft Excel™ as a Tool for Teaching Basic Statistics
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™ offers charting capabilities and the Analysis ToolPak, which provides a set of data analysis tools bey...
Gespeichert in:
| Veröffentlicht in: | Teaching of psychology 2001-10, Vol.28 (4), p.295-298 |
|---|---|
| Hauptverfasser: | , |
| Format: | Artikel |
| Sprache: | eng |
| Schlagworte: | |
| Online-Zugang: | Volltext |
| Tags: |
Tag hinzufügen
Keine Tags, Fügen Sie den ersten Tag hinzu!
|
| container_end_page | 298 |
|---|---|
| container_issue | 4 |
| container_start_page | 295 |
| container_title | Teaching of psychology |
| container_volume | 28 |
| creator | Warner, C. Bruce Meehan, Anita M. |
| description | 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™ 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. |
| doi_str_mv | 10.1207/S15328023TOP2804_11 |
| format | Article |
| fullrecord | <record><control><sourceid>proquest_cross</sourceid><recordid>TN_cdi_proquest_journals_1884370128</recordid><sourceformat>XML</sourceformat><sourcesystem>PC</sourcesystem><ericid>EJ661922</ericid><sage_id>10.1207_S15328023TOP2804_11</sage_id><sourcerecordid>1884370128</sourcerecordid><originalsourceid>FETCH-LOGICAL-c269t-6d6494619ee0d9b348895e25fc01d1a1320d641ed81432116ee4cb9c6023266a3</originalsourceid><addsrcrecordid>eNp9UMtKAzEUDaJgrX6BLgKuR3OTTJpxp6X1QaVCx3VIM5maUpuaTEH3fomf5peYYURciKsD9zzuuRehYyBnQMngfAY5o5JQVk4fEnIFsIN67TBrp7uoR0ghM0El20cHMS4JIZznvIcu7p0JPvq6waNXY1ef7x9YR6xx6f0K1z7g0mrz5NYLfKWjM3jW6MbFxpl4iPZqvYr26Bv76HE8Koc32WR6fTu8nGSGiqLJRCV4wQUU1pKqmDMuZZFbmteGQAUaGCVJAbaSwBkFENZyMy-MSMWpEJr10WmXuwn-ZWtjo5Z-G9ZppQIpORsQSHf1EetU7Tkx2FptgnvW4U0BUe2T1B9PSq6TzmWDMz-O0Z1IfSlNNOnoqBf219p_Er8ATfFv-A</addsrcrecordid><sourcetype>Aggregation Database</sourcetype><iscdi>true</iscdi><recordtype>article</recordtype><pqid>1884370128</pqid></control><display><type>article</type><title>Microsoft Excel™ as a Tool for Teaching Basic Statistics</title><source>Education Source</source><source>SAGE Complete</source><creator>Warner, C. Bruce ; Meehan, Anita M.</creator><creatorcontrib>Warner, C. Bruce ; Meehan, Anita M.</creatorcontrib><description>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™ 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.</description><identifier>ISSN: 0098-6283</identifier><identifier>EISSN: 1532-8023</identifier><identifier>DOI: 10.1207/S15328023TOP2804_11</identifier><language>eng</language><publisher>Los Angeles, CA: SAGE Publications</publisher><subject>College Students ; Computer Uses in Education ; Educational Research ; Educational Strategies ; Higher Education ; Introductory Courses ; Microsoft Excel ; Spreadsheets ; Statistics ; Student Reaction ; Surveys ; Teaching ; Undergraduate Study</subject><ispartof>Teaching of psychology, 2001-10, Vol.28 (4), p.295-298</ispartof><rights>2001 Society for the Teaching of Psychology</rights><lds50>peer_reviewed</lds50><woscitedreferencessubscribed>false</woscitedreferencessubscribed><citedby>FETCH-LOGICAL-c269t-6d6494619ee0d9b348895e25fc01d1a1320d641ed81432116ee4cb9c6023266a3</citedby><cites>FETCH-LOGICAL-c269t-6d6494619ee0d9b348895e25fc01d1a1320d641ed81432116ee4cb9c6023266a3</cites></display><links><openurl>$$Topenurl_article</openurl><openurlfulltext>$$Topenurlfull_article</openurlfulltext><thumbnail>$$Tsyndetics_thumb_exl</thumbnail><linktopdf>$$Uhttps://journals.sagepub.com/doi/pdf/10.1207/S15328023TOP2804_11$$EPDF$$P50$$Gsage$$H</linktopdf><linktohtml>$$Uhttps://journals.sagepub.com/doi/10.1207/S15328023TOP2804_11$$EHTML$$P50$$Gsage$$H</linktohtml><link.rule.ids>314,776,780,21798,27901,27902,43597,43598</link.rule.ids><backlink>$$Uhttp://eric.ed.gov/ERICWebPortal/detail?accno=EJ661922$$DView record in ERIC$$Hfree_for_read</backlink></links><search><creatorcontrib>Warner, C. Bruce</creatorcontrib><creatorcontrib>Meehan, Anita M.</creatorcontrib><title>Microsoft Excel™ as a Tool for Teaching Basic Statistics</title><title>Teaching of psychology</title><description>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™ 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.</description><subject>College Students</subject><subject>Computer Uses in Education</subject><subject>Educational Research</subject><subject>Educational Strategies</subject><subject>Higher Education</subject><subject>Introductory Courses</subject><subject>Microsoft Excel</subject><subject>Spreadsheets</subject><subject>Statistics</subject><subject>Student Reaction</subject><subject>Surveys</subject><subject>Teaching</subject><subject>Undergraduate Study</subject><issn>0098-6283</issn><issn>1532-8023</issn><fulltext>true</fulltext><rsrctype>article</rsrctype><creationdate>2001</creationdate><recordtype>article</recordtype><recordid>eNp9UMtKAzEUDaJgrX6BLgKuR3OTTJpxp6X1QaVCx3VIM5maUpuaTEH3fomf5peYYURciKsD9zzuuRehYyBnQMngfAY5o5JQVk4fEnIFsIN67TBrp7uoR0ghM0El20cHMS4JIZznvIcu7p0JPvq6waNXY1ef7x9YR6xx6f0K1z7g0mrz5NYLfKWjM3jW6MbFxpl4iPZqvYr26Bv76HE8Koc32WR6fTu8nGSGiqLJRCV4wQUU1pKqmDMuZZFbmteGQAUaGCVJAbaSwBkFENZyMy-MSMWpEJr10WmXuwn-ZWtjo5Z-G9ZppQIpORsQSHf1EetU7Tkx2FptgnvW4U0BUe2T1B9PSq6TzmWDMz-O0Z1IfSlNNOnoqBf219p_Er8ATfFv-A</recordid><startdate>200110</startdate><enddate>200110</enddate><creator>Warner, C. Bruce</creator><creator>Meehan, Anita M.</creator><general>SAGE Publications</general><general>Taylor & Francis Ltd</general><scope>7SW</scope><scope>BJH</scope><scope>BNH</scope><scope>BNI</scope><scope>BNJ</scope><scope>BNO</scope><scope>ERI</scope><scope>PET</scope><scope>REK</scope><scope>WWN</scope><scope>AAYXX</scope><scope>CITATION</scope><scope>K9.</scope></search><sort><creationdate>200110</creationdate><title>Microsoft Excel™ as a Tool for Teaching Basic Statistics</title><author>Warner, C. Bruce ; Meehan, Anita M.</author></sort><facets><frbrtype>5</frbrtype><frbrgroupid>cdi_FETCH-LOGICAL-c269t-6d6494619ee0d9b348895e25fc01d1a1320d641ed81432116ee4cb9c6023266a3</frbrgroupid><rsrctype>articles</rsrctype><prefilter>articles</prefilter><language>eng</language><creationdate>2001</creationdate><topic>College Students</topic><topic>Computer Uses in Education</topic><topic>Educational Research</topic><topic>Educational Strategies</topic><topic>Higher Education</topic><topic>Introductory Courses</topic><topic>Microsoft Excel</topic><topic>Spreadsheets</topic><topic>Statistics</topic><topic>Student Reaction</topic><topic>Surveys</topic><topic>Teaching</topic><topic>Undergraduate Study</topic><toplevel>peer_reviewed</toplevel><toplevel>online_resources</toplevel><creatorcontrib>Warner, C. Bruce</creatorcontrib><creatorcontrib>Meehan, Anita M.</creatorcontrib><collection>ERIC</collection><collection>ERIC (Ovid)</collection><collection>ERIC</collection><collection>ERIC</collection><collection>ERIC (Legacy Platform)</collection><collection>ERIC( SilverPlatter )</collection><collection>ERIC</collection><collection>ERIC PlusText (Legacy Platform)</collection><collection>Education Resources Information Center (ERIC)</collection><collection>ERIC</collection><collection>CrossRef</collection><collection>ProQuest Health & Medical Complete (Alumni)</collection><jtitle>Teaching of psychology</jtitle></facets><delivery><delcategory>Remote Search Resource</delcategory><fulltext>fulltext</fulltext></delivery><addata><au>Warner, C. Bruce</au><au>Meehan, Anita M.</au><format>journal</format><genre>article</genre><ristype>JOUR</ristype><ericid>EJ661922</ericid><atitle>Microsoft Excel™ as a Tool for Teaching Basic Statistics</atitle><jtitle>Teaching of psychology</jtitle><date>2001-10</date><risdate>2001</risdate><volume>28</volume><issue>4</issue><spage>295</spage><epage>298</epage><pages>295-298</pages><issn>0098-6283</issn><eissn>1532-8023</eissn><abstract>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™ 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.</abstract><cop>Los Angeles, CA</cop><pub>SAGE Publications</pub><doi>10.1207/S15328023TOP2804_11</doi><tpages>4</tpages></addata></record> |
| fulltext | fulltext |
| identifier | ISSN: 0098-6283 |
| ispartof | Teaching of psychology, 2001-10, Vol.28 (4), p.295-298 |
| issn | 0098-6283 1532-8023 |
| language | eng |
| recordid | cdi_proquest_journals_1884370128 |
| source | Education Source; SAGE Complete |
| subjects | College Students Computer Uses in Education Educational Research Educational Strategies Higher Education Introductory Courses Microsoft Excel Spreadsheets Statistics Student Reaction Surveys Teaching Undergraduate Study |
| title | Microsoft Excel™ as a Tool for Teaching Basic Statistics |
| url | https://sfx.bib-bvb.de/sfx_tum?ctx_ver=Z39.88-2004&ctx_enc=info:ofi/enc:UTF-8&ctx_tim=2025-01-28T21%3A52%3A16IST&url_ver=Z39.88-2004&url_ctx_fmt=infofi/fmt:kev:mtx:ctx&rfr_id=info:sid/primo.exlibrisgroup.com:primo3-Article-proquest_cross&rft_val_fmt=info:ofi/fmt:kev:mtx:journal&rft.genre=article&rft.atitle=Microsoft%20Excel%E2%84%A2%20as%20a%20Tool%20for%20Teaching%20Basic%20Statistics&rft.jtitle=Teaching%20of%20psychology&rft.au=Warner,%20C.%20Bruce&rft.date=2001-10&rft.volume=28&rft.issue=4&rft.spage=295&rft.epage=298&rft.pages=295-298&rft.issn=0098-6283&rft.eissn=1532-8023&rft_id=info:doi/10.1207/S15328023TOP2804_11&rft_dat=%3Cproquest_cross%3E1884370128%3C/proquest_cross%3E%3Curl%3E%3C/url%3E&disable_directlink=true&sfx.directlink=off&sfx.report_link=0&rft_id=info:oai/&rft_pqid=1884370128&rft_id=info:pmid/&rft_ericid=EJ661922&rft_sage_id=10.1207_S15328023TOP2804_11&rfr_iscdi=true |