LISTSERV at the University of Georgia
Menubar Imagemap
Home Browse Manage Request Manuals Register
Previous messageNext messagePrevious in topicNext in topicPrevious by same authorNext by same authorPrevious page (December 2010)Back to main SPSSX-L pageJoin or leave SPSSX-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
Date:   Sat, 4 Dec 2010 09:10:57 -0500
Reply-To:   Art@DrKendall.org
Sender:   "SPSSX(r) Discussion" <SPSSX-L@LISTSERV.UGA.EDU>
From:   Art Kendall <Art@DrKendall.org>
Organization:   Social Research Consultants
Subject:   DON'T Use spreadsheets like Excel for much stat. A soapbox post.
Comments:   To: file@DrKendall.org
Content-type:   text/html; charset=ISO-8859-1

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"> <html> <head>

<meta http-equiv="content-type" content="text/html; charset=ISO-8859-1"> </head> <body bgcolor="#ffffff" text="#000000"> This is one of my soapbox posts, apologies to those of you who are tired of my making this point.<br> <br> Using spreadsheets for stat <b>can be</b> like using a hammer to drive a screw.<br> <br> IF I RECALL CORRECTLY any accounting system that uses computer spreadsheets cannot pass ISO certification.<br> <br> I do use Excel or Quattro Pro or tables in WordPerfect several times a week.<br> Sometimes it is practical to enter data via a spreadsheet and then read it into SPSS for checking double entry or quality checks. [This is because spread sheets are usually available, but it not cost effective to provide SPSS to every person who will do data entry.]<br> <br> For an overview of the issues<br> A video can be found at<br> <br> <a class="moz-txt-link-freetext" href="http://www.spss.com/events/event.cfm?E_ID=2921&amp;Country=US">http://www.spss.com/events/event.cfm?E_ID=2921&amp;Country=US</a><br> <br> A pdf can be found by clicking<br> &lt;<a href="http://forms.cognos.com/?elqPURLPage=4206&amp;offid=wp_spssrc_risks_of_using_spreadsheets_for_statistical_analysis_imw14297" target="_blank">The Risks of Using Spreadsheets in Data Analysis</a>&gt;<br> <br> <br> For more technical review see.<br> <br> <a class="moz-txt-link-freetext" href="http://www.pages.drexel.edu/~bdm25/excel-intro.pdf">http://www.pages.drexel.edu/~bdm25/excel-intro.pdf</a><br> <br> <a class="moz-txt-link-freetext" href="http://www.pages.drexel.edu/~bdm25/excel2007.pdf">http://www.pages.drexel.edu/~bdm25/excel2007.pdf</a><br> <br> <a class="moz-txt-link-freetext" href="http://www.pages.drexel.edu/~bdm25/excel-rng.pdf">http://www.pages.drexel.edu/~bdm25/excel-rng.pdf</a><br> <br> Art Kendall<br> Social Research Consultants<br> <br> <br> </body> </html>

===================== To manage your subscription to SPSSX-L, send a message to LISTSERV@LISTSERV.UGA.EDU (not to SPSSX-L), with no body text except the command. To leave the list, send the command SIGNOFF SPSSX-L For a list of commands to manage subscriptions, send the command INFO REFCARD


Back to: Top of message | Previous page | Main SPSSX-L page