Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Euclidean Geometry And Transformations

Authors: Clayton W Dodge

1st Edition

0486138429, 9780486138428

More Books

Students also viewed these Mathematics questions

Question

describe how work-time control can promote recovery.

Answered: 1 week ago