Identify the data type and measurement scale of each

Question

Please answer the questions and clearly answer the questions

QUESTION 1:

Identify the data type and measurement scale of each variable.

QUESTION 2:

Create a simple frequency table to show the distribution of employees' departments. Comment on the distribution.

QUESTION 3:

Construct a contingency table to explore the relationship between employees' departments (column) and their levels of job satisfaction (row).

Transform the actual counts into a percentage table based on column totals. Comment on any possible pattern in the result.

QUESTION 4:

Create a group frequency table to show the distribution of vacation hours of employees. The table should include the count, percentage and cumulative percentage for each category. Comment on the distribution.

QUESTION 5:
Construct a simple bar graph to show the distribution of factors that motivate employees at work. Comment on the distribution

QUESTION 6:

Construct a pie chart to show the distribution of employees' education levels. Comment on the distribution.

QUESTION 7:

Construct a clustered bar graph to show the distribution of job satisfaction levels by employment status. Comment on your result.

QUESTION 8:

Construct a stacked bar graph to show the distribution of employees' departments by gender. Comment on your result.

QUESTION 9:

(a) Use MEAN, MEDIAN and MODE to compare the bonus received by male and female employees.

(b) Use RANGE and STANDARD DEVIATION to compare the bonus received by male and female employees

(c) Use SKEWNESS and KURTOSIS to compare the bonus received by male and female employees.

QUESTION 10:

Create a box-and-whisker plot to compare the distribution of job errors of male and female employees. Comment on their respective centrality, spread and skewness

Attachment:- project.xlsx