1. How to clean up data in Excel so it can be imported and used in SPSS -
be sure to Save As any Excel 2007 file in the Excel 97-2003 Workbook format, because SPSS is not capable
of importing Excel 2007 workbook files.
Practice Excel workbook requires some Excel formulas and Excel Macros to clean up the data.
This small data set would be faster to modify by hand, but we will imagine
it is actually 5,000 or 12,000 or 21,000 rows of data.
2. If we get time, we will cover briefly cover ANOVA again during this class.
We may also cover paired samples T-Test, since all we did during part I was the
Independent Samples T-Test. Two-Sample T-Tests and ANOVA is session9.pdf
at the Lancaster University SPSS tutorial site.
3. How to compute new variables will be reviewed as we study Linear Regression.
4. y = ax + b is a formula for simple linear regression.
y is the dependent variable. x is the independent variable.
a is the slope of the scatterplot line and the direction of the relationship.
b is the intercept. When x is 0, we have y = a*0 + b or y = b.
b is where the scatterplot regression line crosses or intercepts the y axis.
5. Correlation and simple linear regression. Multiple regression.
6. You are welcome to come to the Thursday class if you want further practice and experience.
It generally will be a repeat of today's class, except for differences in questions that arise and
improvements that are made based on how today's class goes.
7. The URL to get the SCL (Statistical Consulting Lab) home page is: http://www.cs.uni.edu/~jacobson/SCL
8. Send email to: jacobson@cs.uni.edu if you want to make an appointment for help on your research in the future.
Excellent SPSS Short Course tutorial material is available at Lancaster University. If you wish to review the major topics we walked through very quickly today, you might want to read and perhaps practice and do the SPSS exercises in the following 3 sessions.