Stat assign 1

Please read the excel sheet for 1st queston and main ask is to do “1.a”

Question 1 : The first sheet on QMB6305–Homework#1Data.xlsx is named CommuteTime. It lists the average commute time (in minutes) it takes citizens of 379 metropolitan areas to travel to work and back home each day.

1.a : Make five statements about the data from the cumulative relative frequency table or the plots.

Question 2 : The second sheet on QMB6305–Homework#1Data.xlsx is named BetaEmployees. It gives data about some employees at Beta Corporation.
After review excel sheet, please answer below From “a” to “k”

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 five statements about the data.

Last Completed Projects