Assessment 3: Analytical Case Study
In this assignment, you will examine employment data obtained through a survey of business school graduates undertaken by a university placement office. The data is contained in the file Survey_of_graduates.xlsand contains the following columns (variables):
| Variable | Description |
| Area | Area of employment: 1 = Accounting, 2 = Finance, 3 = General management, 4 |
| = Marketing/Sales, 5 = Other | |
| Gender | 1 = Female, 2 = Male |
| Satisfaction | Job satisfaction: 4 = very, 3 = quite, 2 = little, 1 = none |
| Search | Number of weeks job searching |
| Salary | $thousands |
Random Sample
Before youbegin your analysis, you are required to take a random sample of size 150 from the 253 cases in the file. Use the file Sample-Generator.xlsto do this. Your Lecturer will show youhow this can be done in EXCEL. Your answers to the questions below are to be based on your sample of 150 cases. Make sure to keep a safe copy of your sample since youcannot use Sample-Generatorto reproduce the first sample.
Provide a printout of the data in your sample, with ID numbers in ascending order.
Task 1:Variable List
1. Using the variables listed in the table above, Describe each variable. 2. State for each variable whether it is qualitative or quantitative; if it is qualitative, state whether it is nominal or ordinal, and if it is quantitative, state whether it is discrete or continuous.
Task 2:Histogram
3. Create a histogram showing the distribution of salaries. Find the 5-number summary of the distribution of salaries. Comment upon the shape of the distribution: is it symmetric? If it is not, is it positively or negatively skewed? Are there any outliers present? If so, are they of particular interest? State which central measure would be best to use to describe the centre of this distribution, and the reason(s) why.
Task 3:Descriptive Statistics
Prepare a simple summary table that shows the average and standard deviation of salary for the five work areas. Construct side-by-side boxplots for the salaries. Briefly comment
upon any differences you observe in salaries for each work site.
Task 4:Pivot Table and Bar Chart
4. Construct a pivot table that shows satisfaction for each area of employment. Place satisfaction in the rows, area in the columns and a count of job satisfaction in the body of the table. Obtain a second pivot table by converting the frequencies in each column into relative frequencies in each column (right click on any number in the table, then choose Summarize Values as % of column totals).
If the business school graduate wanted to get most satisfaction from their job, based on the information in the table, which area of employment should they choose?
Construct a bar chart comparing the distribution of males and females in all areas of employment.
Do employment areas differ in percentage of female/male graduates? If yes, how?
Conclusion:
5. From the tasks above, you should have some idea of the employment of business school graduates. In this section, you should write a short paragraph summarising your main findings.
Submit your assignment to Turnitin
Submission details
a. Upload your completed assignment electronically byclicking onto the Assignment Upload tab inthe General Information section of the Moodle site.
b. Please complete a first draft of your case study at least 48 hours prior to the due date and upload it.You will receive a report from the site on the extent to which any sections of your answer ‘match’ either published material or other student assignments. Take this as an opportunity to revise your answer and resubmit – the section in the Essay Writing Guide on the use of ‘voice’ inacademic writing will be of assistance. If you do not upload a first draft well inadvance of the cut off time, you will not have the opportunity to make any changes.