Access over 20 million homework documents through the notebank

Get on-demand Q&A homework help from verified tutors

Read 1000s of rich book guides covering popular titles

- Home >
- Mathematics >
- Bus308 Statistics for Managers

Anonymous

Problem Set Week One
Week One Assignment will require students to utilize the following
resources to complete the assignment. Assignment instructions are
contained within the following resources.
All statistical calculations will use the Employee Salary Data Set and Week
1 assignment sheet.
Carefully review the Grading Rubric for the criteria that will be used to
evaluate your assignment.

See comments at the right of the data set.
ID Salary Compa Midpoint Age
8
10
11
14
15
23
26
31
35
36
37
42
3
18
20
39
7
13
22
24
45
17
48
28
43
19
25
40
2
32
34
16
27
41
5
30
1
4
12
33
38
23
22
23
24
24
23
24
24
24
23
22
24
34
36
34
35
41
42
57
50
55
69
65
75
77
24
24
25
27
28
28
47
40
43
47
49
58
66
60
64
56
1.000
0.956
1.000
1.043
1.043
1.000
1.043
1.043
1.043
1.000
0.956
1.043
1.096
1.161
1.096
1.129
1.025
1.050
1.187
1.041
1.145
1.210
1.140
1.119
1.149
1.043
1.043
1.086
0.870
0.903
0.903
1.175
1.000
1.075
0.979
1.020
1.017
1.157
1.052
1.122
0.982
23
23
23
23
23
23
23
23
23
23
23
23
31
31
31
31
40
40
48
48
48
57
57
67
67
23
23
23
31
31
31
40
40
40
48
48
57
57
57
57
57
32
30
41
32
32
36
22
29
23
27
22
32
30
31
44
27
32
30
48
30
36
27
34
44
42
32
41
24
52
25
26
44
35
25
36
45
34
42
52
35
45
Performance Service Gender Raise Degree Gender1
Rating
90
9
1
5.8
0
F
80
7
1
4.7
0
F
100
19
1
4.8
0
F
90
12
1
6
0
F
80
8
1
4.9
0
F
65
6
1
3.3
1
F
95
2
1
6.2
1
F
60
4
1
3.9
0
F
90
4
1
5.3
1
F
75
3
1
4.3
1
F
95
2
1
6.2
1
F
100
8
1
5.7
0
F
75
5
1
3.6
0
F
80
11
1
5.6
1
F
70
16
1
4.8
1
F
90
6
1
5.5
1
F
100
8
1
5.7
0
F
100
2
1
4.7
1
F
65
6
1
3.8
0
F
75
9
1
3.8
1
F
95
8
1
5.2
0
F
55
3
1
3
0
F
90
11
1
5.3
1
F
95
9
1
4.4
1
F
95
20
1
5.5
1
F
85
1
0
4.6
1
M
70
4
0
4
0
M
90
2
0
6.3
0
M
80
7
0
3.9
0
M
95
4
0
5.6
0
M
80
2
0
4.9
1
M
90
4
0
5.7
0
M
80
7
0
3.9
1
M
80
5
0
4.3
0
M
90
16
0
5.7
1
M
90
18
0
4.3
0
M
85
8
0
5.7
0
M
100
16
0
5.5
1
M
95
22
0
4.5
0
M
90
9
0
5.5
1
M
95
11
0
4.5
0
M
44
46
47
49
50
6
9
21
29
60
65
62
60
66
76
77
76
72
1.052
1.140
1.087
1.052
1.157
1.134
1.149
1.134
1.074
57
57
57
57
57
67
67
67
67
45
39
37
41
38
36
49
43
52
90
75
95
95
80
70
100
95
95
16
20
5
21
12
12
10
13
5
0
0
0
0
0
0
0
0
0
5.2
3.9
5.5
6.6
4.6
4.5
4
6.3
5.4
1
1
1
0
0
1
1
1
0
M
M
M
M
M
M
M
M
M
Grade
A
A
A
A
A
A
A
A
A
A
A
A
B
B
B
B
C
C
D
D
D
E
E
F
F
A
A
A
B
B
B
C
C
C
D
D
E
E
E
E
E
The ongoing question that the weekly assignments will focus on is: Are males and females paid the same
Note: to simplfy the analysis, we will assume that jobs within each grade comprise equal work.
The column labels in the table mean:
ID – Employee sample number
Age – Age in years
Service – Years of service (rounded)
Midpoint – salary grade midpoint
Grade – job/pay grade
Gender1 (Male or Female)
Salary – Salary in thousands
Performance Rating – Appraisal rating (Employee evaluat
Gender: 0 = male, 1 = female
Raise – percent of last raise
Degree (0= BS\BA 1 = MS)
Compa - salary divided by midpoint
E
E
E
E
E
F
F
F
F
es and females paid the same for equal work (under the Equal Pay Act)?

Score:
<1 point>
Week 1. Measurement and Description - chapters 1 and 2
1
Measurement issues. Data, even numerically coded variables, can be one of 4 levels nominal, ordinal, interval, or ratio. It is important to identify which level a variable is, as
this impact the kind of analysis we can do with the data. For example, descriptive statistics
such as means can only be done on interval or ratio level data.
Please list under each label, the variables in our data set that belong in each group.
Nominal Ordinal Interval Ratio
b. For each variable that you did not call ratio, why did you make that decision?
<1 point>
2
The first step in analyzing data sets is to find some summary descriptive statistics for key varia
For salary, compa, age, performance rating, and service; find the mean, standard deviation, and
You can use either the Data Analysis Descriptive Statistics tool or the Fx =average and =stdev
(the range must be found using the difference between the =max and =min functions with Fx)
Note: Place data to the right, if you use Descriptive statistics, place that to the right as well.
Salary
Compa
Age
Perf. Rat. Service
Overall
Mean
Standard Deviation
Range
Female
Mean
Standard Deviation
Range
Male
Mean
Standard Deviation
Range
<1 point>
3
What is the probability for a:
a.
Randomly selected person being a male in grade E?
b.
Randomly selected male being in grade E?
Note part b is the same as given a male, what is probabilty of being in grade E?
c. Why are the results different?
<1 point>
4
For each group (overall, females, and males) find:
a.
b.
c.
d.
e.
f.
g.
h.
i.
<2 points>
5.
The value that cuts off the top 1/3 salary in each group.
The z score for each value:
The normal curve probability of exceeding this score:
What is the empirical probability of being at or exceeding this salary value?
The value that cuts off the top 1/3 compa in each group.
The z score for each value:
The normal curve probability of exceeding this score:
What is the empirical probability of being at or exceeding this compa value?
How do you interpret the relationship between the data sets? What do they mean about our eq
What conclusions can you make about the issue of male and female pay equality? Are all of th
What is the difference between the sal and compa measures of pay?
Conclusions from looking at salary results:
Conclusions from looking at compa results:
Do both salary measures show the same results?
Can we make any conclusions about equal pay for equal work yet?
an be one of 4 levels hich level a variable is, as
ample, descriptive statistics
ong in each group.
hat decision?
scriptive statistics for key variables.
mean, standard deviation, and range for 3 groups: overall sample, Females, and Males.
or the Fx =average and =stdev functions.
x and =min functions with Fx) functions.
ace that to the right as well.
Probability
bilty of being in grade E?
Overall
Female
Male
Hint: can use these Fx functions
Excel's standize function
1-normsdist function
hat do they mean about our equal pay for equal work question?
male pay equality? Are all of the results consistent?

Studypool values your privacy. Only questions posted as Public are visible on our website.

This question has not been answered.

Create a free account to get help with this and any other question!

Similar Questions

I need help figuring this out

John takes a random sample of 100 apples off of trees in the orchard during his last picking. The sample has an ...

calculating proability

IMG_2020.JPG hello am having difficulties calculating proability from question 6 till 8 and the ...

homework help for elementary statistics

How many different signals can be made by using exactly 3 different flags if there are 5 different flags from which to sel...

statistics proability

IMG_2077.JPG i need help solving these 2 questions i need it to be solved and please an explaination how it wa...

Can you do chapter 8?

HW6.docx...

statistics proability

IMG_2070.JPG i need help in solving questions that are circled with red ..and the bold numbers are the answer...

Related Tags

Book Guides

by Herman Melville

by Nathan Ballingrud

by Hillary Clinton

by Wiliam Shakespeare

by E. M. Forster

by Jane Austen

by Michel Foucault

by Min Jin Lee

by Fyodor Dostoyevsky

Brown University

1271 Tutors

California Institute of Technology

2131 Tutors

Carnegie Mellon University

982 Tutors

Columbia University

1256 Tutors

Dartmouth University

2113 Tutors

Emory University

2279 Tutors

Harvard University

599 Tutors

Massachusetts Institute of Technology

2319 Tutors

New York University

1645 Tutors

Notre Dam University

1911 Tutors

Oklahoma University

2122 Tutors

Pennsylvania State University

932 Tutors

Princeton University

1211 Tutors

Stanford University

983 Tutors

University of California

1282 Tutors

Oxford University

123 Tutors

Yale University

2325 Tutors

Have a homework question? Get help from verified tutors now!

Copyright © 2020. Studypool, Inc.

Take 10 seconds to Sign up!

Get instant access to your answer!

Access over 20 million homework documents through the notebank

Get on-demand Q&A homework help from verified tutors

Read 1000s of rich book guides covering popular titles

Login

or
Sign Up

Become A Tutor

OR

Sign up with:

Our Partner Countries

These are the countries currently available for verification, with more to come!

United States

Canada

Mexico

Europe(Continental)

South Africa

China

Israel

Japan

South Korea

Australia

New Zealand

Argentina

Brazil

Chile