Task A

Table 1: The table, which can be found on page 4 , was taken from the Office for National Statistics (ONS) website. It shows the relative distribution of salaries for UK graduates who are in their first year of full time paid work (2004). You can copy and paste the table on an Excel file.

Required :

1. Create a relative cumulative frequency table for each gender.
2. Estimate the mean, median and standard deviation of the salaries of UK graduates (2004) for each gender.
   You may calculate other appropriate statistics.
   Note: Only two A4 pages of Excel printouts are required for this task
3. Write a report of no more than 600 words to be addressed to the vice chancellors of the UK universities. The report should address the following points:
   1. A comparison of the relative cumulative frequencies by gender.
   2. A comparison of the "average" salary for UK graduates in 2004 between the two gender groups. A clear interpretation of the meaning of the mean and median, in the context of this data.
   3. A comparison of the standard deviations and an interpretation of these measures in the context of the data for the two gender groups. You may use other appropriate statistics.
   4. A statement that indicates which of the two gender groups earns more, on average, once they finish their degree and the spread of the salaries among each gender group.

Task B

The data in the table below (from March 2004) refers to various variables that may affect the economic activity rate of a borough. The economic activity rate is defined broadly as the proportion of the economically active population out of the total population in the working age. For example, the total number of people in employment, the number of benefit claimants, the percentage of females benefit claimants, the percentage of benefit claimants that have claimed for over 12months and the percentage of claimants of the working age can all affect in some way the economic activity rate.

The full table ( Table 2 ) is shown on page 4. You can copy and paste it on an Excel file.

Required:

1. Using "Economic activity rate (%)" as the dependent variable and each of the other variables as independent variables, draw five scatter diagrams (one for each independent variable). You must use an Excel facility.
2. Again, using an Excel facility, calculate the Pearson correlation coefficients (each independent variable against the dependent variable).
3. Use the best explanatory variable for "Economic activity rate (%)" to construct a linear model using a linear regression. Only one (best) model based on a single independent variable is to be presented. Use the best linear regression model to predict the "Economic activity rate (%)" in localities that have the following statistics:
   

   Locality	Total in employment (000)	Claimant count (000)	Females percentage of claimant	Percentage claiming over 12 months	Percentage of working age claimant population
   London	3380	168.4	27.9	19.4	3.5
   United Kingdom	27433	932	25.2	15.1	2.6

   
   Note: Only two A4 pages of Excel printouts are required for this task
4. Write a memo addressing and interpreting the following:
   • Describing the trend and type of correlation for each of the five scatter diagrams.
   • Interpreting the correlation coefficients.
   • Identifying the best linear regression model and stating the explanatory variable. You need to give a reason for this statement.
   • Interpreting the coefficients of regression in the context of the data.
   • Stating any outliers to this general rule and naming the locality(ies) of the outlier(s).

You should send the content of this memo to the director of the economic recovery programme, Paul Dent, at the Directorate of Employment, to include in his report on "Understanding the Economic activity". Your findings will be a contribution to the report.

Price: $21.22

Solution: The downloadable solution consists of 11 pages, 1022 words and 11 charts.
Deliverable: Word Document