SPSS part 3

MP3

Print

Modeling Project Part 3

Tables 

Create descriptive statistics for the Data Set. 

1. Create Descriptive Statistics for your dependent variable and all the independent variables  (make sure you get the minimum, maximum, mean, median, and standard deviation).

2. Run a regression for Y on all of the independent variables.

3. Look at your output and determine which independent variables are significant at a 10% significance level. (reject H0)

4. Run a second regression for Y on the SIGNIFICANT independent variables only. (if all of them are significant, you will only have 1 regression)

Clean-up your output and export it to Microsoft Word.

Write-up in Word

Proper Formatting of Tables: 

· Tables should have a title

· The variable names should be left-justified

· All numbers should be formatted to the thousandths place

· If the number is between -1 and 1, make sure there is a "0" in the ones place.  For example the number ".02356" should be typed in as "0.024" into your table.

· Number columns should be centered

Table 1:

Create a table of descriptive statistics with proper formatting (see above). 

Variables	Mean	St. Deviation
Age	40.285	1.402
Experience	7.488	5.748
Some College	0.135	0.002
High School	0.487	0.335

Table 2:

Your regression output.  Your regression tables should look like the ones presented in class (see your Wage or GPA output). There will be THREE columns. Column one will be the variable names, Column 2 is the model with ALL independent variables, Column 3 is the model with only the significant independent variables.

Make sure that you put the standard errors in parenthesis below the coefficients and use *** to indicate level of significance.

Variables	Model 1:  All Variables	Model 2:  Significant
Age	2.345** (1.132)	1.145 (1.675)
Experience	3.565*** (0.987)	3.675*** (1.109)
Some College	3.423 (2.324)
High School	0.243 (0.332)
Constant	11.345 (1.245)	12.458 (2.457)

What to turn-in:

You need to answer the following points in your write-up.

· Present a table with the descriptive statistics (reformat and type this table)

· Present a single table with the above two regressions.

· After the table submit the ACTUAL SPSS output, in word format, for the descriptive statistics and regressions.

Your grade on this section will partially be based on the presentation of the regressions. I will be looking for tables that show significant variables with the appropriate number of stars, use a consistent number of significant variables, the table should be labeled so that anyone reading the table knows what every number means. For examples of what I'm looking for look at some of the papers in the "School of Business Working Paper Series" on the third floor wall of Henderson or the Mabee Library website.