Excel and statistics
Microsoft Excel, part of the Microsoft Office software suite, is not a statistical analysis program. However, it does have some statistical functions, and data can be moved between Excel and SPSS, as long as you do a little planning. Here are some guides to using Excel to record data and then moving them to SPSS to analyze them.
- How do I import an Excel File into IBM SPSS Statistics?From IBM, the creator of SPSS.
- Importing data into SPSSFrom Kent State University (Ohio) Library. Import from Excel or a delimited text file.
- Tips for creating an Excel file that can be easily moved to a statistical program for analysisAdvice on Excel formatting, variable names, working with variables, date and time, and things to look for.
- SPSS Tutorial: Importing Data (University of Illinois)Importing from a CSV (comma-delimited text file), which Excel can produce.
