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 engagement is low in their profession. She finds an employee engagement survey and administers it to her workers. The individual scores are above.

address below and 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, do 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 believe the next step should be in this analysis.