Share
Explore BrainMass

Correlation analysis in SPSS

I need assistance with entering the following data/variables into SPSS, so I may compute a correlation matrix for the variables and answer the questions below (i.e. a, b, & c). I'm having the most problems with actually "entering the data and building the variables in SPSS", so I primarily need help understanding how to enter the data and building the variables in SPSS, so I may answer the the questions below (i.e. a, b, & c). I'm using SPSS 17.0. See below.

The following table gives a football team's season-ticket sales, percentage of games won, and number of active alumni for the years 1996-2005.

Year Season-Ticket Sales Percentage of Games Won #of Active Alumni
1998 4,995 40 NA
1999 8,599 54 3,450
2000 8,479 55 3,801
2001 8,419 58 4,000
2002 10,253 63 4,098
2003 12,457 75 6,315
2004 13,285 36 6,860
2005 14,177 27 8,423
2006 15,730 63 9,000
2007 15,805 70 9,500

a. Compute a correlation matrix for the variables, using SPSS. Interpret
the correlation between each pair of variables.
b. Estimate a regression model for sales = Percentage of games won.
c. Estimate a regression model for sales = Number of active alumni.

Solution Summary

Step by step method for computing Correlation analysis in SPSS is given in the answer.

$2.19