statistics

Order Description
this should be in a report format in either word document or pdf while u should include the u calculate in the appendix capture from excel

The formatting of the work should be 1.5 line spacing in a San Serif font such as Arial 11 font size.

The individual assignment will be a report demonstrating the ability of the student to evaluate and analyse a problem related to a data set by means of statistical methods learned during the lectures.
The students will be introduced to a fictional company that has designed and run an employee survey to solve current challenges. The survey is linked to financial and performance records of the company. Each student will be issued with a unique variation of a simulated dataset.
Students write a report addressed to the Board of Directors. The report should include a short description of the background of the problem, data preparation, analysis, interpretation of the results with recommendations for actions. In addition, students should critically evaluate the quality of the questionnaire. The analysis should include descriptive statistics, correlation and regression.
The report should follow a classic structure including an executive summary as well as a log about data preparation as appendix. The log should be user friendly with appropriate illustration to enable a reproduction of the analysis with the same results.
You work in the HR department of a large call centre with several establishments. The
company is interested in the relation between employee’s performance and their work
environment and issued a questionnaire to all employees. The survey is linked to
performance records of the company.
You are commissioned to analyse the data and produce a report addressed to the Board of
Directors. The report should include a short description of the background of the problem,
data preparation, analysis, interpretation of the results with recommendations for actions. In
addition, you should critically evaluate the quality of the questionnaire. The analysis should
include descriptive statistics, correlations and regressions.
Word count: 2.500 words +/- 10%
Your dataset includes variables from two sources, the administrative data and the survey
question. You find the survey questionnaire and the data codes below.
Administrative records:
1. Average handling time for calls in seconds (admin 1)
2. Age (admin 2)
3. Gender (admin 3, females ==1)
4. Tenure in months (admin 4)
Survey:
5. Stress (survey1)
6. Procedural justice (survey2)
7. Distributional justice (survey3-survey6)
8. Supervisory support (survey7-survey10)
9. Relation with co-workers (survey11-survey14)
10. Job satisfaction (survey15)
Personal code: MY8r4
We would like to ask you to give us your opinion how you perceive your work environment.
We can ensure that all your responses are treated anonymously.
Please read the following sentence and thick whether you totally disagree, somewhat
disagree, are neutral, somewhat agree or totally agree.
Totally disagree
Somewhat disagree
neutral
Somewhat agree
Totally agree
I often feel a lot of time pressure over a long period 1 2 3 4 5
The rules and procedures to make decisions are fair. 1 2 3 4 5
I feel I am being paid a fair amount for the work I do. 1 2 3 4 5
Raises are too few and far between. 1 2 3 4 5
I feel appreciated by the organization when I think about what they pay
me
1 2 3 4 5
I feel satisfied with my chances for salary increase 1 2 3 4 5
Supervisors here are really good at understanding peoples’ problems 1 2 3 4 5
Supervisors show that they have confidence in those they manage 1 2 3 4 5
Supervisors here are friendly and easy to approach 1 2 3 4 5
Supervisors can be relied upon to give good guidance to people 1 2 3 4 5
I like the people I work with. 1 2 3 4 5
I find I have to work harder because of the incompetence of people I
work with.
1 2 3 4 5
I can easily approach my co-workers. 1 2 3 4 5
There is too much bickering and fighting at work. 1 2 3 4 5
How satisfied are you with your job?
Very unsatisfied Very satisfied
0 1 2 3 4 5 6 7 8 9 10