upload your
ASSIGNMENT
E-mail: learn@coachoncouch.com

The Project

 

The infamous company, Jordan & Associates, is in trouble again.  The Deputy Director has just resigned in the midst of rumors going around the departments about discrimination, lawsuits, and even the company picnic has been canceled.

 

I would like to seek your help in putting together an Ad hoc Statistics Report to be submitted to the CEO so that he can make the appropriate corrective, proactive, and retroactive decisions for the troubled company.

 

The Report Format

As you might have known already, my brother, the Jordan & Associates CEO is a very difficult person: his way or the highway.  He is also insistence on proper report format.  Nonetheless, we have to address quite a few issues, which are listed in the later section.  Meanwhile, please follow the standard Jordan & Associates report format as follow:

 

Make a cover page entitled: Ad-hocStatistics Report submitted to the CEO.  Then skip a few lines

     By (Your Name)

     Skip one or two more line and put the date.

     This should be the first page, the cover.  Then after the cover page, make a table of contents.

     Write Table of Contents at the top center.

     The table of contents should be listed as such:


Title Page ...............................................................................................................................................i

Table of Contents ..................................................................................................................................iii

Vacation Histogram ...............................................................................................................................1


Means ...................................................................................................................................................2

Promotion Recommendation ..................................................................................................................3


Bonus Recommendation ........................................................................................................................4

Grievance Board ...................................................................................................................................5

Probability Table ...................................................................................................................................6

Promotions Committee ..........................................................................................................................7

Evaluation Confidence Interval ...............................................................................................................8

T-shirt Order .........................................................................................................................................9
 

 

The Issues to be Addressed

Issue 1

Nine employees need to be chosen randomly to serve on the Grievance Board from the Employee Roster so that no one will say that we chose employees based on popularity.  You may use any method, including with the aid of a random number table, to accomplish this task.  However, you have to explain your method, whichever you choose to use.

Please list the employees ID# after selecting them.

Issue 2

Please complete the following two conditional probability tables.  There have been complaints that there is skewness in certain departments as it relates to ethnicity and gender.  It seems that certain supervisors are hiring only females or only Asians.  Please complete this accurately so that the CEO can see if there are hiring trends in his agency.

    Table I

 

White

Black

Hispanic

Asian

Foreign

Total

Dept. 1

 

 

 

 

 

 

Dept. 2

 

 

 

 

 

 

Dept. 3

 

 

 

 

 

 

Dept. 4

 

 

 

 

 

 

Dept. 5

 

 

 

 

 

 

Total

 

 

 

 

 

 


    Table II  

 

Female

Male

Total

Black

 

 

 

White

 

 

 

Hispanic

 

 

 

Asian

 

 

 

Foreign

 

 

 

Total

 

 

 

 


Issue 3

Please create a histogram for vacation hours for employees in Department 1, 3, and 5.  Please exclude any vacation hours over 320 as a person cannot accumulate vacation over that amount.

After you have created this histogram, please indicate the distribution's shape.

Issue 4

    Find the Mean weight for Departments 4 and 5 combined.

    Find the Mean salary for Department 2.

    Find Mean age for Department 1.

    Find the Mean Placement Score (P. Score) for Department 3.

Issue 5

Find the standard deviation for the evaluation score (E. Score) of Department 5 and Department 2 separately.

The CEO is thinking about giving one of these department a $1000 per person bonus.  Based on their means and standard deviation, which department is doing better as it relates to this year's evaluation?  Who should the bonus go to and why?

Issue 6

The Equal Opportunity Commission has cited Jordan & Associates with discrimination against Asian females and Hispanic females.  They need to promote either an Asian female or an Hispanic female within the next month.  Based on their evaluation scores (E. Score), find the corresponding z -score for each Asian and Hispanic female and make a decision on which person should be promoted.  Please list them by their ID # based on the percentile.

Use   s = 6.06  and   m = 16.


Issue 7

Please refer to the conditional probability table or complete it first before attempting this assignment.  The CEO has asked for a committee to be formed to approve and review promotions.  Please list all your answers in percentages?

From Table 1, what is the probability of choosing an African American employee?

From Table 2, what is the probability of choosing an Asian female given all females?

From Table 1, what is the probability of choosing a White employee from Dept. 2 and then an Hispanic employee from Dept. 3?

From Table 2, what is the probability of choosing a Black male or Foreign male?

From Table 1, what is the probability of choosing a Foreigner or an Hispanic both from Department 5?

Issue 8

Find the evaluation score (E. Score) confidence intervals for the following two departments: Department 1 and Department 4 combined.

Find the confidence interval at the 95% level.  Use   s = 6.06 and   http://polaris.umuc.edu/~aau/stat200/week08/x-bar.gif= 17.625
 

Issue 9

We are about to order the annual summer picnic T-shirts.  In the past, the mean employee weight is 210 lbs with an   s = 67 lbs.  Test H a> 210 at 0.05 significance level by combining the weights of departments 2, 3, and 4.  If their mean weight is greater than 210, we need to order all extra large T-shirts.  Please make a decision.

 

The Data

ID #
 

Dept.
 

Ethnicity
 

Gender
 

Weight
 

Age
 

Salary ($)
 

Vacation Hrs.
 

Absences
 

E. Score
 

P. Score
 

694
 

3
 

F
 

F
 

252
 

18
 

69,380
 

300
 

16
 

24
 

94
 

261
 

3
 

W
 

F
 

178
 

21
 

39,986
 

60
 

22
 

22
 

90
 

138
 

2
 

B
 

F
 

132
 

21
 

40,000
 

138
 

34
 

15
 

86
 

222
 

2
 

B
 

F
 

162
 

22
 

32,000
 

159
 

32
 

17
 

76
 

556
 

5
 

B
 

M
 

219
 

24
 

31,000
 

120
 

70
 

19
 

98
 

300
 

1
 

W
 

F
 

192
 

24
 

84,000
 

120
 

18
 

18
 

80
 

58
 

3
 

H
 

F
 

110
 

25
 

12,775
 

60
 

0
 

14
 

94
 

169
 

1
 

W
 

M
 

138
 

26
 

25,594
 

125
 

0
 

21
 

72
 

558
 

5
 

F
 

M
 

220
 

27
 

22,000
 

85
 

7
 

16
 

87
 

765
 

4
 

F
 

M
 

271
 

30
 

22,697
 

330
 

42
 

17
 

71
 

728
 

3
 

B
 

F
 

270
 

30
 

97,424
 

60
 

16
 

22
 

65
 

901
 

2
 

W
 

M
 

310
 

31
 

18,000
 

1292
 

40
 

15
 

71
 

611
 

5
 

W
 

F
 

229
 

31
 

98,000
 

85
 

15
 

13
 

84
 

264
 

1
 

H
 

F
 

189
 

31
 

67,089
 

125
 

81
 

20
 

70
 

128
 

2
 

B
 

M
 

127
 

31
 

48,000
 

444
 

10
 

15
 

91
 

118
 

1
 

W
 

M
 

126
 

31
 

37,328
 

85
 

61
 

25
 

84
 

101
 

2
 

A
 

F
 

124
 

32
 

66,000
 

336
 

47
 

21
 

96
 

605
 

3
 

H
 

F
 

226
 

34
 

27,082
 

60
 

24
 

10
 

76
 

945
 

5
 

W
 

F
 

399
 

35
 

14,000
 

120
 

15
 

8
 

75
 

721
 

4
 

H
 

M
 

255
 

35
 

31,466
 

64
 

9
 

18
 

80
 

852
 

1
 

F
 

M
 

288
 

37
 

51,243
 

85
 

40
 

1
 

72
 

207
 

3
 

A
 

F
 

159
 

37
 

54,101
 

300
 

49
 

15
 

79
 

811
 

5
 

W
 

M
 

287
 

38
 

35,000
 

325
 

43
 

10
 

86
 

508
 

5
 

F
 

M
 

217
 

38
 

17,000
 

300
 

45
 

7
 

77
 

927
 

4
 

W
 

M
 

315
 

41
 

40,718
 

212
 

15
 

15
 

97
 

17
 

4
 

F
 

F
 

97
 

41
 

83,331
 

534
 

28
 

11
 

88
 

421
 

5
 

H
 

M
 

212
 

42
 

11,000
 

60
 

78
 

1
 

92
 

327
 

2
 

W
 

F
 

204
 

43
 

214,000
 

317
 

90
 

23
 

74
 

507
 

4
 

W
 

M
 

215
 

44
 

43,847
 

58
 

0
 

12
 

80
 

204
 

3
 

H
 

M
 

151
 

46
 

80,712
 

150
 

34
 

12
 

80
 

325
 

3
 

B
 

F
 

198
 

47
 

86,274
 

150
 

17
 

17
 

82
 

206
 

1
 

W
 

F
 

155
 

47
 

15,544
 

85
 

85
 

18
 

94
 

333
 

2
 

H
 

M
 

210
 

48
 

26,400
 

384
 

0
 

19
 

79
 

727
 

4
 

W
 

M
 

262
 

51
 

15,155
 

156
 

0
 

19
 

81
 

496
 

2
 

B
 

F
 

214
 

51
 

15,400
 

155
 

39
 

11
 

77
 

233
 

4
 

A
 

M
 

174
 

53
 

29,050
 

151
 

0
 

25
 

76
 

971
 

1
 

F
 

M
 

407
 

56
 

43,761
 

120
 

21
 

23
 

85
 

301
 

4
 

W
 

M
 

195
 

59
 

73,582
 

564
 

110
 

23
 

97
 

877
 

1
 

A
 

M
 

290
 

66
 

12,484
 

85
 

28
 

16
 

87
 

906
 

5
 

B
 

F
 

314
 

73
 

91,000
 

325
 

12
 

22
 

73
 

 

Views (295)
Body Preview(8845 words)

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

By:

<name>

 

Dated:

<DATE>

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 


Table xxxxxxx Contents ..........................................................................................................................iii


Vacation xxxxxxx xxxxxxx /> Means .................................................................................................................................................2


 

Bonus xxxxxxx Board.............................................................................................................................5

 

Promotions Committee................................................................................................................7
 

Evaluation Confidence xxxxxxx xxxxxxx />  

T-shirt xxxxxxx style="list-style-type:circle;">

  • Issue 1
  •  

    The xxxxxxx number method xxxxxxx no restriction xxxxxxx xxxxxxx data xxxxxxx choose from xxxxxxx given table. xxxxxxx I xxxxxxx xxxxxxx ten random xxxxxxx and then xxxxxxx with the xxxxxxx style="margin-left:35.45pt;"> 

    The xxxxxxx numbers selected xxxxxxx me are xxxxxxx xxxxxxx 694, xxxxxxx 518, 026, xxxxxxx 111, 758, xxxxxxx 327,

     

    Hence, xxxxxxx range is xxxxxxx xxxxxxx All xxxxxxx intervals fall xxxxxxx between this xxxxxxx Lower xxxxxxx xxxxxxx any interval xxxxxxx (Upper Limit xxxxxxx previous interval xxxxxxx 1). For, xxxxxxx first interval xxxxxxx Limit = xxxxxxx xxxxxxx align="center">Table xxxxxxx Random Interval xxxxxxx align="center"> 

    Emp. ID

    Probability xxxxxxx rowspan="2" style="width:95px;">

    0.025

    0.025

    024

    261

    0.050

    025

    138

    0.025

    050

    074

    0.025

    0.100

    099

    556

    0.125

    100

    300

    0.025

    125

    149

    0.025

    0.175

    174

    169

    0.200

    175

    558

    0.025

    200

    224

    0.025

    0.250

    249

    728

    0.275

    250

    901

    0.025

    275

    299

    0.025

    0.325

    324

    264

    0.350

    325

    128

    0.025

    350

    374

    0.025

    0.400

    399

    101

    0.425

    400

    605

    0.025

    425

    449

    0.025

    0.475

    474

    721

    0.500

    475

    852

    0.025

    500

    524

    0.025

    0.550

    549

    811

    0.575

    550

    508

    0.025

    575

    599

    0.025

    0.625

    624

    17

    0.650

    625

    421

    0.025

    650

    674

    0.025

    0.700

    699

    507

    0.725

    700

    204

    0.025

    725

    749

    0.025

    0.775

    774

    206

    0.800

    775

    333

    0.025

    800

    824

    0.025

    0.850

    849

    496

    0.875

    850

    233

    0.025

    875

    899

    0.025

    0.925

    924

    301

    0.950

    925

    877

    0.025

    950

    974

    0.025

    1.000

    999

     

     

     

     

    Simulated xxxxxxx Selection

     

    Random xxxxxxx xxxxxxx align="center">Employee ID

    694

    261

    728

    852

    26

    404

    101

    556

    758

    811

    333

    264

     

    694 xxxxxxx in the xxxxxxx 675-699, with xxxxxxx ID 327. xxxxxxx others are xxxxxxx xxxxxxx style="margin-left:35.45pt;"> 

     

     

     

     

     

     

     

     

     

    Table xxxxxxx I:

    Black

    Asian

    Foreign

    Dept. 1

    0

    2

    8

    2

    1

    1

    Dept. xxxxxxx style="width:71px;">

    1

    2

    1

    1

    0

    1

    2

    8

    1

    0

    8

    Total

    8

    7

    7

    40

     

     

    Female

    Total

    Black

    2

    8

    6

    Hispanic

    3

    7

    Asian

    2

    4

    2

    5

    Total

    19

    40

     

     

     

     

     

     

     

     

     

     

     

     

     

     

    • Issue xxxxxxx xxxxxxx III: xxxxxxx of Employees.

       

      Dept.

      1

      120

      169

      264

      125

      85

      852

      206

      85

      120

      877

      830

      3

      694

      261

      60

      60

      728

      605

      60

      300

      204

      325

      150

      Total

      556

      120

      85

      611

      945

      120

      320*

      508

      421

      60

      320*

      Total

      1410

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

      Emp xxxxxxx style="width:76px;">

      Weight

      4

      765

      721

      255

      315

      17

      507

      215

      262

      233

      301

      195

      Total

      556

      219

      220

      611

      945

      399

      287

      508

      421

      212

      314

      Total

      2,097

       

      1. xxxxxxx (Mean Weight xxxxxxx Dept 4 xxxxxxx Mean Weight xxxxxxx Dept 5)/2 xxxxxxx xxxxxxx + xxxxxxx = 242.563

       

        The mean xxxxxxx for xxxxxxx xxxxxxx 40,000+32,000+18,000+48,000+66,000+2,14,000+26,400+15,400  = xxxxxxx 8

         

        1. 24+26+31+31+37+47+56+66  =  xxxxxxx =  39.75

        8                              xxxxxxx xxxxxxx value="5">The xxxxxxx P.Score for xxxxxxx 3 = xxxxxxx = xxxxxxx xxxxxxx 82.5

      8 8

       

       

       

       

       

       

       

       

       

       

       

      • The standard xxxxxxx for E. xxxxxxx of Dept. xxxxxxx border="1" cellpadding="0" xxxxxxx style="width:83px;">

        Emp xxxxxxx xxxxxxx align="center">E. xxxxxxx (x)

        (x- xxxxxxx style="width:83px;">

        15

        4

        222

        0

        0

        15

        128

        15

        101

        4

        16

        23

        6

        333

        4

        496

        36

          xxxxxxx 136

         = xxxxxxx style="margin-left:35.45pt;"> = 136/8 xxxxxxx 17, where xxxxxxx xxxxxxx number xxxxxxx employees in xxxxxxx 2

         

        xxxxxxx xxxxxxx   =  xxxxxxx standard deviation xxxxxxx E. Score xxxxxxx Dept. 5:

       

      Emp ID#

      y-

      (y- )2

      556

      7

      49

      16

      4

      611

      13

      1

      945

      -4

      16

      10

      -2

      508

      7

      25

      421

      -11

      121

      22

      10

       

        = xxxxxxx style="width:57px;">

       

       = 332

       

       

      Standard xxxxxxx = xxxxxxx xxxxxxx =  6.887

      The CEO xxxxxxx give the xxxxxxx of $1,000 xxxxxxx Department 2.

      In xxxxxxx of Dept. xxxxxxx the mean xxxxxxx 12 and xxxxxxx xxxxxxx is xxxxxxx which implies xxxxxxx the E. xxxxxxx is xxxxxxx xxxxxxx variable with xxxxxxx typical range xxxxxxx about 5.11 xxxxxxx 18.89.

      Hence, xxxxxxx CEO must xxxxxxx bonus to xxxxxxx xxxxxxx employees, xxxxxxx they are xxxxxxx well this xxxxxxx style="list-style-type:circle;">

    • Issue xxxxxxx xxxxxxx List of xxxxxxx & Hispanic xxxxxxx Employees

       

         

      z- Score*

      z-score (%)**

    •  
    •      
       
    •  
    •      
    •  
    •      
       
    •  
    •      
    •  
    •      

       

      From xxxxxxx Data given,

       

      Standard xxxxxxx (s) = xxxxxxx xxxxxxx = xxxxxxx z-score is xxxxxxx by the xxxxxxx Employee xxxxxxx xxxxxxx who is xxxxxxx Hispanic Female, xxxxxxx = (20-16)/6.06 xxxxxxx 0.660

      Similarly, the xxxxxxx for other xxxxxxx and Hispanic xxxxxxx xxxxxxx calculated xxxxxxx put in xxxxxxx table above.

      ** xxxxxxx the xxxxxxx xxxxxxx used to xxxxxxx the % xxxxxxx the help xxxxxxx z-score table, xxxxxxx is available xxxxxxx any statistics xxxxxxx xxxxxxx online.

       

      Based xxxxxxx the z-score xxxxxxx from the xxxxxxx table, xxxxxxx xxxxxxx observed that xxxxxxx Asian Female xxxxxxx with ID# xxxxxxx working in xxxxxxx 2 having xxxxxxx E. Score xxxxxxx xxxxxxx should xxxxxxx promoted next xxxxxxx by the xxxxxxx of xxxxxxx xxxxxxx Associates. This xxxxxxx because her xxxxxxx (%) is xxxxxxx at 79.53%, xxxxxxx also means xxxxxxx only 20.47% xxxxxxx xxxxxxx employees xxxxxxx worked better xxxxxxx her this xxxxxxx In xxxxxxx xxxxxxx all the xxxxxxx four Asian xxxxxxx Hispanic Females xxxxxxx performance percentile xxxxxxx lower than xxxxxxx and hence xxxxxxx xxxxxxx not xxxxxxx off than xxxxxxx Emp. ID# xxxxxxx style="list-style-type:circle;">

    • Issue xxxxxxx xxxxxxx 1:

      No. of xxxxxxx American Employee xxxxxxx Black Employee xxxxxxx 8

      Total nos. xxxxxxx Employees (n) xxxxxxx 40

       

      Let A’  xxxxxxx xxxxxxx event xxxxxxx selecting an xxxxxxx American Employee xxxxxxx the xxxxxxx xxxxxxx all employees.

      Probability xxxxxxx A (PA) xxxxxxx Nos. of xxxxxxx American Employees/ xxxxxxx Employees (n)

      = xxxxxxx = 0.2 xxxxxxx xxxxxxx Table xxxxxxx of Asian xxxxxxx Employees = xxxxxxx nos. xxxxxxx xxxxxxx Employees = xxxxxxx A’  be xxxxxxx event of xxxxxxx an Asian xxxxxxx Employee from xxxxxxx set of xxxxxxx xxxxxxx employees.

      Probability xxxxxxx A (PA) xxxxxxx Nos. of xxxxxxx Female xxxxxxx xxxxxxx Total Female xxxxxxx (n)

      = 2/19 xxxxxxx 0.1052 = xxxxxxx Table 1:

      Nos. xxxxxxx White Employees xxxxxxx Dept. 2 xxxxxxx xxxxxxx of xxxxxxx Employees in xxxxxxx 3 = xxxxxxx nos. xxxxxxx xxxxxxx = 40

       

      Let xxxxxxx the event xxxxxxx selecting a xxxxxxx Employee from xxxxxxx 2& a xxxxxxx Employee from xxxxxxx xxxxxxx style="list-style-type:circle;">

    •  

    Probability xxxxxxx A i.e. xxxxxxx =(2+3)/40 = xxxxxxx Table xxxxxxx xxxxxxx Black Males xxxxxxx 2

    Nos. of xxxxxxx Males = xxxxxxx nos. of xxxxxxx = 40

     

    Let xxxxxxx the event xxxxxxx xxxxxxx a xxxxxxx Male,

    And, ‘B’ xxxxxxx the event xxxxxxx selecting xxxxxxx xxxxxxx Male

     

    •  

    Probability xxxxxxx A(PA) = xxxxxxx = 5%

    Probability xxxxxxx B(PB) = xxxxxxx =12.5%

    The events xxxxxxx mutually exclusive, xxxxxxx xxxxxxx (A xxxxxxx = P(A) xxxxxxx P(B) = xxxxxxx = xxxxxxx xxxxxxx 1:

    Nos. of xxxxxxx in Dept. xxxxxxx = 2

    Nos. xxxxxxx Hispanic in xxxxxxx 5 = xxxxxxx Employees in xxxxxxx xxxxxxx = xxxxxxx Employees = xxxxxxx ‘A’be the xxxxxxx of xxxxxxx xxxxxxx Foreigner or xxxxxxx Hispanic from xxxxxxx 5,

     

    •  

    Probability xxxxxxx A(PA) = xxxxxxx = 7.5%

     

     

     

     

     

     

     

    Table: E.Score xxxxxxx xxxxxxx 2 xxxxxxx 4

     

    1.  

    1. 138

    15

    17

    128

    15

    327

    333

    19

    11

    1. 765

     
    721

    1.  

    1. 17

     
    507

    1.  

    1. 233

     
    301

    1.  

     

    Mean ( xxxxxxx (given)

    Standard xxxxxxx xxxxxxx = 6.06 xxxxxxx Interval (µ) xxxxxxx 95% level xxxxxxx given by xxxxxxx formula:

               

                                        xxxxxxx …………….eqn. (1)

     

                             = xxxxxxx derived from xxxxxxx table for xxxxxxx corresponding dfand xxxxxxx style="margin-left:35.45pt;">Degree of xxxxxxx (df) = xxxxxxx xxxxxxx (n) xxxxxxx 1 = xxxxxxx – 1 xxxxxxx 15 xxxxxxx xxxxxxx sum.

     

     

    For xxxxxxx interval we xxxxxxx the values xxxxxxx above in xxxxxxx xxxxxxx style="margin-left:35.45pt;"> 

                            xxxxxxx style="margin-left:35.45pt;">            =         

    The xxxxxxx xxxxxxx for 95% xxxxxxx level is xxxxxxx 20.512)

     

     

     

    • Issue xxxxxxx Mean ( xxxxxxx 210 lbs,

      S.D xxxxxxx = 67 xxxxxxx xxxxxxx border="1" xxxxxxx cellspacing="0">

      1.  
      Weights xxxxxxx xxxxxxx align="center">Total (lbs)

      Dept. 2

       
    •               Dept. 3

                      Dept. 4

                     

                                                                                                         xxxxxxx = 4811 xxxxxxx of Sample xxxxxxx (y) = xxxxxxx = 200.46 xxxxxxx nullhypothesis (H0): xxxxxxx xxxxxxx alternate xxxxxxx (Ha): Ha≥ xxxxxxx lbs

      z = xxxxxxx  = xxxxxxx xxxxxxx zat 0.05 xxxxxxx level = xxxxxxx computed z xxxxxxx < Critical xxxxxxx (1.96), hence xxxxxxx conclude that xxxxxxx xxxxxxx hypothesis xxxxxxx be rejected. xxxxxxx means there xxxxxxx no xxxxxxx xxxxxxx order extra xxxxxxx T-shirts by xxxxxxx company.

    Price : $5.00 Buy Now
     
    Newsletter Sign Up Put your email address below...
    Contact to : learn@coachoncouch.com
    Copyright © 2014 by CoachOnCouch