Background

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

The assignment uses the file “Assignment 1 and 2 DATASET – Cleveland.xlsx” which can be downloaded from the MIS171 section in Model (in the Deakin College Portal).

Scenario

The company wishes to study its full‐time work force by developing an employee profile that measures factors such as salary , job satisfaction, and care retrogress .

You will be playing the role of John Smith , a Senior Analy stat the company . Senior management of Cleveland Corp has asked you to conduct a survey of their employees .You decide to take a randomise ample of450staffandconductthesurveyviacompanyinternalmail.The results are saved in the data set “Assignment 1 and 2 DATASET- Cleveland.xlsx”.

George Tim ,Human Resources Manager at C level and ,has written to your egarding the C level and employee survey . His letter to you is reproduced below.

For Attention:                     John Smith, Senior Analyst                                                                                      9/8/2017

From:                                  Tim George, Human Resources Manager

Regarding:                         Analysis of employee survey

Dear John,

Regarding the recently collected data from the C level and Corp’s employees urvey  , please provide me with answerstothefollowingquestions.Yourresponseswillassistourdepartmentinconstructingthe employee profile required by senior management.

1. Please provide an overall summary of employees’ salaries.

2. Please provide an estimate of the proportion of employees who are “Moderately satisfied” or “Very satisfied ”with their job at Cleveland Corp.

3. Senior management is also in terested in how salary is related to gender . Does there appear to be any relationship between an employee’s salary and their gender?

4. Can you please provide an overall summary of how Cleveland Corp employees rated their relations with the management?
5. Senior management sinter ested in which numerical variables, if any, see mtoinfluencean employee’s salary .Please provide a summary of these relationships if any.

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 5.00pm on Thursday 17 August 2017.

Regards

Tim George

Part1: Data Analysis

To prepare a reply to the manager’s letter, you will need to use Excel to analyse the data set “Assignment 1 and 2 DATASET – Cleveland.xlsx”thoroughly.

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

• tables
• graphs, and
• summary measures.

You DO NOT need to perform any additional analysis other than what you have learned in weeks 1, 2,3 and 4!

Please use the worksheets ‘Q1’ through ‘Q5’ to work on each question. 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 the ‘Results’ worksheet. Keep in mind the page limit of 8printed pages for the analysis AND that the presentation of the results will be marked too!

GUIDELINES

The manager has asked for a numberof taskstobedone.Thefollowingguidelinesforeachquestionshouldbefollowed:

1. Please provide an overall summary of employees’ salaries.

You will need to use numerical analysis methods to summarise over all salaries. In the report, you will also need to write aboutaverages, variability etc. as presented in the examples in the relevant lecture and tutorial.

2. Please provide an estimate of the proportion of employees’ job satisfaction(that is,who are“Moderately satisfied” or “Very satisfied “with their job)at Cleveland.

You will need to use categorical variable analysis methods to provide this estimate. In the report, you will also need testate the estimate and discuss the limitations of this type of estimate.

3. Senior management is also in retested in how salary is related toDoes there appear to be any relationship be twee Nan employee’s salary 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 Cleveland Corp 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 analysesix (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.

GENERAL GUIDELINES:

• Before doing any analysis ,classify all your variables as either numerical or categorical .The techniques you will use depend on the type of data you have.
• As mentioned above, than alysis section(Part 1) yousubmitshouldbenomorethan8pagesofcomputYoumightproducemuchmorethanthisinitially,butyoushouldtrimit down to only show the most relevant results.
• When satisfied ,you should copy-and-paste your analysis output in to a Word docu
• Your analysis should be presented in the same sequenceas the manager’s questions, and everything should be clearly labelled and grouped around each ques
• Also, make sure, there are no table or graph “breaks” across two pages.
• Poorly presented or unorganised analysis or excessive output (more than 8 pages) will be penalised.
• Save your computer analysis frequently (every 10 to 15 minutes).

Part2: Report (that is, yourreply to the Manager’s letter)

Write a letter to the manager, explaining essentialin form ationand conclusions from your data analysis.Youareallowednomorethantwopagestoconveyyourwrittenfindings.

• Keep the Englishes impel and the explanation brief.
• Avoid the use of technical statistical terminology. Your reader will not necessarily understand even simples statistic cater ms, thus your task is to explain your analysis using plain, understandable lang

General instructions:

• There portistobe written as a standalone document(that is, assume for the scenario that the manager will only read your report, andnotlookatyouranalysisoutput).Thus,youshouldnothaveanydirectreferencesto your an alysisin your report.
• When writing your reply ,make sure that you actually provide the information the manager requested in her letter to you. That is, answer the manager’s questions.
• Do not include e computer out put table sand chartsin your response report.
• Numberyouranswersinyourreport1,2a, …e, to match these quence of the manager’s requests.
• Include anintroduction at the start of the report and a summary/ conclusionatt heend.
• Markswillbedeductedfortheuseoftechnicalterms,poorgrammar,awkwardsentencestructure,poorspelling andpunctuation,irrelevantmaterial,poorpresentation/organisationandlettersthatareovertwo (2) pageslo