##### Reference no: EM132183781

**Background**

This is an individual assignment, which requires you to analyse a dataset, interpret the results and then report your findings to a person with little or no knowledge of statistical data analysis.

**Scenario**

Osmidium is an American car parts manufacturer with a factory in Adelaide which employs 2,000 people. The company wishes to study its full-time workforce by developing an employee profile that measures factors such as salary, job satisfaction, and career progress.

You will be playing the role of Alicia Stats, a Senior Analyst at the company. Senior management of Osmidium has asked you to conduct a survey of their employees. You decide to take a random sample of 450 staff and conduct the survey via company internal mail. The results are saved in the data set "AusNetData.xlsx".

Vito Genovese, Human Resources Manager at Osmidium, has written to you regarding the Osmidium employee survey. His letter to you is reproduced below.

Regarding the recently collected data from the Osmidium employee survey, please provide me with answers to the following questions. Your responses will assist our department in constructing the employee profile required by senior management.

1. Please provide an overall summary of employees' hours worked per week.

2. Please provide an estimate of the proportion of employees who are very likely to stay in their job.

3. Senior management is also interested in how hours worked is related to gender. Does there appear to be any relationship between an employee's hours worked and their gender?

4. Can you please provide an overall summary of how Osmidium employees rated their relations with the management?

5. Senior management is interested in which numerical variables, if any, seem to influence an employee's hours worked. Please provide a summary of these relationships ifany.

Please present your written findings in a report (no more than two pages), with an appendix (no more than eight pages) containing the results of your analysis, by no later than 6.00pm, Sunday 9th December 2018.

**Part 1: Data Analysis**

To prepare a reply to the manager's letter, you will need to use Excel to analyse the data set "AusNetData.xlsx". You will find this file on Moodle.

You will need to apply techniques you have learned during lectures and tutorials in Weeks 1 to 3 such as:

- tables

- graphs, and

- summary measures.

You may initially produce more Excel output than you need, so you will only need to copy and paste the relevant output from these worksheets to a ‘Results' worksheet. Keep in mind the page limit of 8 printed pages for the analysis AND that the presentation of the results will be marked too!

**GUIDELINES**

The manager has asked for a number of tasks to be done. The following guidelines for each question should be followed:

1. Please provide an overall summary of employees' hours worked per week.

You will need to use numerical analysis methods to summarise overall hours worked. In the report, you will also need to write about averages, variability etc. as presented in the examples in the relevant lecture and tutorial.

2. Please provide an estimate of the proportion of employees who are very likely to stay in their job. You will need determine the variable type and hence what methods you should use to provide this estimate.

3. Senior management is also interested in how hours worked is related to gender. Does there appear to be any relationship between an employee's hours worked and their gender?

You will need to focus on whether there is a difference or not. If yes, make sure you describe them. If not, you should explain why you think there is no difference.

4. Can you please provide an overall summary of how Osmidium employees rated their relations with the management?

You will need to use categorical analysis methods to summarise the variable. In the report you also need to briefly describe your findings. Examples can be found in the relevant lecture and tutorial.

5. Senior management is interested in which numerical variables seem to influence an employee's salary. Please provide a summary of these relationships if any.

Once more you will need to use techniques for the analysis of two variables. You will need to analyse six

(6) numerical relationships. In each case, the type of the relationship - if there is one - and its direction and strength are of interest. Make sure you comment on what you find in each case.

**Part 2: Report **(that is, your reply to the Manager's letter)

Write a letter to the manager, explaining essential information and conclusions from your data analysis. You are allowed no more than two pages to convey your written findings.

- Keep the English simple and the explanations brief.

- Avoid the use of technical statistical terminology. Your reader will not necessarily understand even simple statistical terms, thus your task is to explain your analysis using plain, understandable language.

**Assignment Checklist:**

Part 1 (Data Analysis)

1. Have you applied the correct analysis techniques?

2. Is the analysis in the same order as the manager's requests?

3. Is every table and every graph clearly labelled?

4. Are there tables or graphs that are broken across 2 pages? (If yes, make sure you change that!)

5. Is the analysis output no more than 8 pages long?

Part 2 (Report)

1. Is your report written in plain language?

2. Is it free of grammar and spelling mistakes?

3. Is it free of technical language?

4. Is it free of Excel output (tables, graphs)?

5. Are the answers numbered and in the same order as the manager's requests?

6. Is the report no more than 2 pages long?

**Attachment:-** Business Analytics.rar