Question
Audit Times (Days) Audit Times (Days) Frequency Cumulative Frequency Relative Frequency Cumulative Relative Freq. Percentage freq. Cumulative % Freq. 17 17 1 1 0.04 0.04
Audit Times (Days) Audit Times (Days) Frequency Cumulative Frequency Relative Frequency Cumulative Relative Freq. Percentage freq. Cumulative % Freq. 17 17 1 1 0.04 0.04 4% 4% 18 18 1 2 0.04 0.08 4% 8% 19 19 2 4 0.08 0.16 8% 16% 19 20 3 7 0.12 0.28 12% 28% 20 21 1 8 0.04 0.32 4% 32% 20 22 1 9 0.04 0.36 4% 36% 20 23 4 13 0.16 0.52 16% 52% 21 24 1 14 0.04 0.56 4% 56% 22 25 1 15 0.04 0.60 4% 60% 23 26 1 16 0.04 0.64 4% 64% 23 27 4 20 0.16 0.80 16% 80% 23 28 1 21 0.04 0.84 4% 84% 23 31 1 22 0.04 0.88 4% 88% 24 32 1 23 0.04 0.92 4% 92% 25 33 1 24 0.04 0.96 4% 96% 26 38 1 25 0.04 1.00 4% 100% 27 27 27 27 28 31 32 33 38
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 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 relative frequency column
e.Create cumulative frequency column
f.Create 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.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started