1)The second sheet on QMB3200-Homework#1Data.xlsx is named BetaEmployees.It gives data about some employees at Beta Corporation.

a.For each of the variables, state the type of each of the six variables as either Numeric or Categorical.

b.For the Gender variable, find the number of males and females and their proportions.Assume 0 denotes Male and 1 denotes Female.

c.Create a frequency table for annual salary by creating frequencies for groups of intervals of 10,000.Create the groups as 0 to 9999, 10,000 to 19,999, 20,000 to 29,999, and so on up to 169,999.

d.Create a relative frequency column

e.Create a cumulative frequency column

f.Create a cumulative relative frequency column

g.Plot a chart of the relative frequencies

h.Guess if the shape is skewed or not and if so, in what direction.

i.Find the skewness of annual salary column and interpret its value.

j.Find the kurtosis of annual salary column and interpret its value.

k.Make three statements about the data.

The link to data file:

https://docs.google.com/spreadsheets/d/1d0EoH8kKZvKzRY7dTxifeumtYFv1gGrLkl4_3qDcGGo/edit?usp=sharing