Thursday, 1 September 2011

SPSS or Excel???

Why use a data analysis package like SPSS when you could use Excel? This is one question which was coming in my mind during today’s classes of Business Analytics. While I was learning a new technique of producing and analyzing graphs using SPSS, I was in a dilemma whether to use SPSS or continue using Excel for such analysis. Here are some comparisons that were found:

Key reasons offered by “Discover Secrets Your Spreadsheet Can’t Tell You”:

  • Easy access to descriptive statistics and frequencies: True. While you can do descriptives in Excel using some of the built-in functions and the data analysis add-in, it is a lot easier and faster in SPSS.
  • Wider variety of charts & graphs: True, although I tend to find Excel easier to manage
  • Better, more flexible pivot tables Sort of true. That is, true if you have SPSS Tables. If you don’t, then in my opinion Excel pivot tables are easier to work with. SPSS Tables, on the other hand, is extremely easy to use and lets you do a lot more things that you can’t do with Excel Pivot Tables.
  • Full set of statistical tests: True. While it is definitely possible to run statistical tests in Microsoft Excel, they’re much harder to find and work with compared to SPSS, where they pretty much come “free” with every function you run.
  • Easy to run similar reports and graphics for subsets: True. Using the “Split” function in SPSS, it is relatively easy to create tables and charts for subsets without doing any extra work. Or you can create syntax (SPSS’s macro language) that lets you reuse your tables and codes over and over again.
  • Labels instead of codes in your reports: I love this feature. Just because your survey software makes Male=1 and Female=2 doesn’t mean you want to see lots of 1s and 2s in your reports. And while it isn’t difficult to use search/replace in Excel to change all of your 1s to Male and your 2s to Female, SPSS lets you keep your values intact.
  • Accurate results when some data is missing: Sortof true. For this item, they point to the benefits you get from using the SPSS Missing Value Analysis add-on module (an extra $800 or so). This tells you whether the questions that were skipped by your respondents will impact your analysis, and will even estimate what these values should have been. Obviously Excel can’t do anything like that, but keep in mind you need to buy the extra module to get it to work.
  • Easy import functions: I’m not sure that I completely agree with this one. It is true that it is easy to bring in text files. And they do provide functionality to bring in ODBC databases, including Excel spreadhsheets, Access tables and SPSS databases. But the interface for doing so is a little funky and the experience isn’t as clean or smooth as it is with Excel.
  • Unlimited rows: This point describes how SPSS can handle an unlimited number of rows while Excel can only handle 65,000. Microsoft Excel 2007 can handle unlimited rows too, but SPSS’s assertion may have been true when the article was published.
  • Using SPSS saves time and increases productivity: I suppose that really depends on what it is that you’re trying to do. There are a lot of analysis that I find easier to do in Excel. But certainly if you’re doing statistical analysis it is easier and faster in SPSS.
  • SPSS makes it easy to understand statistical results. SPSS has added a lot of extra help files and tutorials that explain how you can/should interpret a lot of the statistical jargon that the software spits out. Excel obviously does not.

Certainly now, irrespective of the fact that I am used to the ease of usage, and addicted to Excel for graphs and charts for analysis, SPSS has come up as a very helpful platform for a better and more efficient analysis of data which will be an advantage in analyzing large and complex data.

Posted By:

Kunal Mandpe

Marketing 06

Roll No: 13084

No comments:

Post a Comment