Reference no: EM135541
Q. A major Statistics Canada household survey, the Survey of Labour and Income Dynamics or SLID, the latest of which is referred to as SLID 2009 (it relates to the income year 2009). The survey data will be analysed using SPSS, a widely used statistical software package. (SPSS stands for Statistical Package for the Social Sciences.) It is often convenient to copy SPSS output into Excel for further analysis and plotting; such procedures will be used in this and subsequent assignments. All assignments are to be submitted in A2L as MS Word or pdf files. Ensure that all tables and figures have an informative title and that the axes are labelled.
1. Use SPSS to create table 1 that shows the SLID 2009 sample size in five-year age groups (16-19, ..., 75-79, 80+), separately for each sex, and in total. Show the table.
2. Now apply the sample weights (variable "wtcsld26"), and create table 2. Show the table.
3. Bring the two tables into Excel; use Excel to create tables 3 and 4, based on tables 1 and 2, each showing the percent (or the proportion) of the total number of observations that is accounted for by each age/sex group. Show the new tables
4. Using Excel, create plots 1 and 2 based on tables 3 and 4 (with both sexes on each graph). Comment on the shape of the plot associated with table 4; how would you explain the rather large differences from one age group to another?
5. How would you explain the rather large sex difference for the oldest age group?
6. Now create table 5 to show the difference between the age/sex distribution of the sample and that of the inferred "population" once the weights have been applied. (That is, plot the percentage difference between the "sample" and the "population" distributions.) Describe and discuss what you find in Table 5 and the associated plot.
7. Based on Table 4, calculate the ratio of the population 65 and older relative to the population between 20 and 64. How would you interpret this ratio? Consider the inverse of the ratio -- that is, the population aged 20-64 relative to the population 65 and older. How would you interpret this ratio?