Issue 1: Grievance Board

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.

To randomly select the nine employees to serve on the Grievance Board, the following method was used:

Maintaining the order in which the employees were listed on the data sheet provided, each employee was assigned a number (1 – 39) as can be seen in the screenshot below:

The following formula was entered into Excel to allow the program to randomly select a number (1-39): =RANDBETWEEN(1,39)
This formula was then entered eight more times so that a list of nine random numbers would be generated by Excel as can be seen in the screenshot below: The numbers randomly selected by Excel were then matched with the corresponding employee numbers to derive the final list of the nine employees to serve on the Grievance Board, which are as follows:
Randomly Selected Number from Excel Corresponding Employee ID Number
32 694
18 945
2 101
28 301
22 169
12 558
13 605
25 233
34 727
Therefore, the final list of employees to serve on the Grievance Board are: 694, 945, 101, 301, 169, 558, 605, 233, 727

The method chosen represents a simple random sample, in that each employee has an equal chance of being selected to participate on the Grievance Board. This method was selected to ensure that no employees were selected or excluded based on any personal preferences

Issue 2: Probability Table
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 4 0 1 1 2 8
Dept. 2 2 4 1 1 0 8
Dept. 3 1 2 3 0 1 7
Dept. 4 4 0 1 1 2 8
Dept. 5 3 2 1 0 2 8
Total 14 8 7 3 7 39

Table II Female Male Total
Black 6 2 8
White 6 8 14
Hispanic 3 4 7
Asian 1 2 3
Foreign 2 5 7
Total 18 21 39

Issue 3: Vacation Histogram

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.

The shape of the distribution is J-shaped