PS1_ans

# PS1_ans - Department of Economics University of California...

This preview shows pages 1–3. Sign up to view the full content.

This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document
2 2. Download the Excel spreadsheet file called PS1data.xls from the Resources section of bSpace. It contains a dataset with 261 observations. The variables are defined as: FEMALE: 1 if the individual is female and 0 if the individual is male. AGE: Age of the individual. COLLEGE: 1 if the individual has a college degree, 0 otherwise. YEAR: two years, 1992 and 1998. a) Use Excel to complete the following table: 1992 1998 Total Males Females Total Observations Average Age Median Age Std Dev of Age % College % College & Age>30 b) Use Excel to compute the sample covariance and sample correlation between FEMALE and COLLEGE for each of the two years. ANSWER: The values for the missing statistics are computed in the PS1 Excel answer sheet and reported below. Look at the cell contents to see the formula. a) b) Year 1992: Corr(Female,College) = 0.084 Cov(Female,College) = 0.0209 Year 1998: Corr(Female, College) = - 0.04 Cov(Female,College) = - 0.009 3. In 1998, the campus placement office of a large, public university conducted a survey of starting salaries of graduating economics majors. With the help of the registrar, they were able to anonymously match the reported salaries of 108 graduates with their cumulative GPA during their undergrad career.
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

### Page1 / 6

PS1_ans - Department of Economics University of California...

This preview shows document pages 1 - 3. Sign up to view the full document.

View Full Document
Ask a homework question - tutors are online