Reference no: EM132372855

Engagement (on a five-point scale, 5 being highest) 5 4 3 4 1 2 3 4 3 1 4

3 4 1 5 3 3 2 5 5 5 2 4 4 5 4 2 5 1 2

Age (in years) 37 34 47 37 25 48 36 50 35 26 25 33 25 37 47 40 36 35 44 39 46 47 27 28 30 35 46 40 29 26

Gender (0=male, 1=female) 1 1 0 1 0 1 1 0 0 1 0 0 0 0 0 1 0 1 1 1 1 0 1 0 1 0 0 1 1 0

A manager is worried that her employees are not engaged at work. She finds an employee engagement survey and administers it to her workers. The individual scores are provided in the dataset file. copy and paste all visuals. explain excel and spss inputs help too

a. Use Excel to calculate the mean, median, and standard deviation for the employee engagement data.

b. Use SPSS to calculate the mean, median, and standard deviation for the employee engagement data.

c. Use SPSS to set up histogram of these data. copy and paste below

d. Next, conduct an analysis of the "age" and "gender" variables using the appropriate measures of central tendency and dispersion. Use SPSS only. Also, set up appropriate graphic for each variable. copy and paste below

d. Interpret the results for employee engagement, age, and gender. Identify what you believe the next step should be in this analysis.