Using the data analysis function in Excel, draw and calculate descriptive statis
Using the data analysis function in Excel, draw and calculate descriptive statistics for the following variables: 1) gender, 2) Job Level, 3) Employee engagement(multiple items), 4) Work-Life Balance (multiple items), 5) job performance (multiple items), and 6) salary.
1. Draw a frequency table and a histogram for six variables.
2. Calculate central tendency (mean, median, and mode) for six variables and explain them. What statistic best describes the central tendency of each variable? (hint: mode, median, or mean) and why?
3. Calculate dispersion (range and standard deviation) for six variables and explain them.
