SPSS and Excel
Posted on 2014-04-10
I have been exposed to SPSS as an ETL tool (only one of its capabilities (ie Stats.). My "use case" was taking consistent data provided by my employer (each week) and mapping it into my personal Excel spreadsheet in order to keep the integrity while updating my spreadsheet. I am most impressed with its ability to map data from one file to another on a visual basis as well as perform specific actions against the data as you move it from one file to another. My alternative in Excel was to write macros to do the data manipulation.
Here's my question; How does SPSS compare to Excel for data manipulation? And Statistical analysis? Your personal experience with SPSS and Excel "Data slicer, pivots, etc." would be very helpful in the dialog and answer to the question.
Thank you in advance,