Refer to the Excel file Salary (attached to the assignment) to address all the questions below: 1. What is the probability for: a.) Randomly selecting a person being a male in Grade E? b.) Given that we picked a random person and he was a m
Fin-Acc-BossRefer to the Excel file Salary (attached to the assignment) to address all the questions below:
1. What is the probability for:
a.) Randomly selecting a person being a male in Grade E?
b.) Given that we picked a random person and he was a male, what is the probability of being in grade E?
c.) Why the results different?
2. Consider each group (Male and Female separately) and assume the salaries follow a Normal Probability distribution:
a.) What is the top 75th percentile of salary for Males?
b.) What is the top 75th percentile of salary for Females?
c.) What is the probability that a male picked at random makes more than 50K?
d.) What is the probability that a female picked at random makes between 30K and 40K?
Salary Compa Midpoint Age Performance Rating Service Length Gender Raise Degree Gender 1 Grade
Data Type Ratio Scale Ratio Scale Ratio Scale Ratio Scale Ordnal Scale Ratio Scale Nominal Scale Ratio Scale Nominal Scale Nominal Scale Ordinal Scale
Salary: Salary data is ratio level as this satisifies satisfies all properties of the data measurement inclduing identity, magnitude, equal intervals, and meaningful zero value.
Compa: Compa salary data is ratio level as this satisifies satisfies all properties of the data measurement inclduing identity, magnitude, equal intervals, and meaningful zero value.
Midpoint Salary: Midpoint salary data is ratio level as this satisifies satisfies all properties of the data measurement inclduing identity, magnitude, equal intervals, and meaningful zero value.
Age: Age data is ratio level as this satisifies satisfies first three properties of the data measurement inclduing identity, magnitude, equal intervals. This this data zero value is not meaningful.
Performance Rating: Performance Rating data is ordinal scale as this satisfies firrst two properties of the data measurement inclduing identity, and magnitude.
Service Lenght: Service length data is ratio level as this satisifies all properties of the data measurement inclduing identity, magnitude, equal intervals, and meaningful zero value.
Gender: Gender data is nominal level as this satisifies only first property of the data measurement. Based on the data, ranking among the observation cannot be made here.
Percentage of Last Raise: Percentage of Last Raise: data is ratio level as this satisifies all properties of the data measurement inclduing identity, magnitude, equal intervals, and meaningful zero value.
Degree: Degree data is nominal level as this satisifies only first property of the data measurement. Based on the data, ranking among the observation cannot be made here.
Gender1: Gender 1 data is nominal level as this satisifies only first property of the data measurement. Based on the data, ranking among the observation cannot be made here.
Grade: Grade data is ordinal scale as this satisfies firrst two properties of the data measurement inclduing identity, and magnitude.
Mean, Standrd Deviation, and Range of Entire Salary Data Set
ID Salary Gender
1 62.9 M
2 27.2 M
3 34.9 F
4 64.6 M
5 49.2 M
6 77.7 M
7 41.2 F
8 22 F
9 73.4 M
10 23.9 F
11 21.8 F
12 60.8 M
13 41.8 F
14 23.3 F
15 24.6 F
16 47.4 M
17 66.6 F
18 34.8 F
19 24.5 M
20 35.9 F
21 77.1 M
22 58.9 F
23 23.8 F
24 55.1 F
25 24.6 M
26 24.1 F
27 45.3 M
28 75.2 F
29 78.7 M
30 48.3 M
31 24.2 F
32 27.6 M
33 61.2 M
34 27 M
35 23.8 F
36 24.4 F
37 23.5 F
38 61.3 M
39 34.4 F
40 24.7 M
41 45.8 M
42 22.4 F
43 75.6 F
44 61.3 M
45 59.7 F
46 55.1 M
47 63.8 M
48 62.8 F
49 64 M
50 66.3 M
Mean 45.57
Standard Deviation 19.381
Range 56.90
Mean, Standrd Deviation, and Range of Salary of Male Employees
ID Salary Gender
1 62.9 M
2 27.2 M
4 64.6 M
5 49.2 M
6 77.7 M
9 73.4 M
12 60.8 M
16 47.4 M
19 24.5 M
21 77.1 M
25 24.6 M
27 45.3 M
29 78.7 M
30 48.3 M
32 27.6 M
33 61.2 M
34 27 M
38 61.3 M
40 24.7 M
41 45.8 M
44 61.3 M
46 55.1 M
47 63.8 M
49 64 M
50 66.3 M
Mean 52.792
Standard Deviation 17.992
Range 54.20
Mean, Standrd Deviation, and Range of Salary of Female Employees
ID Salary Gender
3 34.9 F
7 41.2 F
8 22 F
10 23.9 F
11 21.8 F
13 41.8 F
14 23.3 F
15 24.6 F
17 66.6 F
18 34.8 F
20 35.9 F
22 58.9 F
23 23.8 F
24 55.1 F
26 24.1 F
28 75.2 F
31 24.2 F
35 23.8 F
36 24.4 F
37 23.5 F
39 34.4 F
42 22.4 F
43 75.6 F
45 59.7 F
48 62.8 F
Mean 38.348
Standard Deviation 18.289
Range 53.800
First, Second & Third Quartiles and Interquartile Range of Entire Salary Data Set
ID Salary Gender
1 62.9 M
2 27.2 M
3 34.9 F
4 64.6 M
5 49.2 M
6 77.7 M
7 41.2 F
8 22 F
9 73.4 M
10 23.9 F
11 21.8 F
12 60.8 M
13 41.8 F
14 23.3 F
15 24.6 F
16 47.4 M
17 66.6 F
18 34.8 F
19 24.5 M
20 35.9 F
21 77.1 M
22 58.9 F
23 23.8 F
24 55.1 F
25 24.6 M
26 24.1 F
27 45.3 M
28 75.2 F
29 78.7 M
30 48.3 M
31 24.2 F
32 27.6 M
33 61.2 M
34 27 M
35 23.8 F
36 24.4 F
37 23.5 F
38 61.3 M
39 34.4 F
40 24.7 M
41 45.8 M
42 22.4 F
43 75.6 F
44 61.3 M
45 59.7 F
46 55.1 M
47 63.8 M
48 62.8 F
49 64 M
50 66.3 M
First Quartile Range 24.6
Second Quartile Range 43.55
Third Quartile Range 61.3
Interquartile Range 36.70
First, Second & Third Quartiles and Interquartile Range of Male Salary Data
ID Salary Gender
1 62.9 M
2 27.2 M
4 64.6 M
5 49.2 M
6 77.7 M
9 73.4 M
12 60.8 M
16 47.4 M
19 24.5 M
21 77.1 M
25 24.6 M
27 45.3 M
29 78.7 M
30 48.3 M
32 27.6 M
33 61.2 M
34 27 M
38 61.3 M
40 24.7 M
41 45.8 M
44 61.3 M
46 55.1 M
47 63.8 M
49 64 M
50 66.3 M
First Quartile Range 45.3
Second Quartile Range 60.8
Third Quartile Range 64
Interquartile Range 18.70
Comparison of the First, Second & Third Quartiles and Interquartile Range of the Male and Female Salary Data: Whereas the first, second & third quartiles and interquartile range of female salary are 23.8, 34.4, 55.1 and 31.30 respectively, the first, second & third quartiles and interquartile range of male salary are 45.3, 60.8, 64, and 18.70 respectively. Here, from the observation of the first, second & third quartiles and interquartile range of male and female salary, it can be said that as compared to that of female’s salary, male’s salary is more dispersed.
Mean and Standard Deviation of Male Salary Data
ID Salary Gender
1 62.9 M
2 27.2 M
4 64.6 M
5 49.2 M
6 77.7 M
9 73.4 M
12 60.8 M
16 47.4 M
19 24.5 M
21 77.1 M
25 24.6 M
27 45.3 M
29 78.7 M
30 48.3 M
32 27.6 M
33 61.2 M
34 27 M
38 61.3 M
40 24.7 M
41 45.8 M
44 61.3 M
46 55.1 M
47 63.8 M
49 64 M
50 66.3 M
First Quartile Range 52.79
Second Quartile Range 17.99
Mean and Standard of Female Salary Data
ID Salary Gender
3 34.9 F
7 41.2 F
8 22 F
10 23.9 F
11 21.8 F
13 41.8 F
14 23.3 F
15 24.6 F
17 66.6 F
18 34.8 F
20 35.9 F
22 58.9 F
23 23.8 F
24 55.1 F
26 24.1 F
28 75.2 F
31 24.2 F
35 23.8 F
36 24.4 F
37 23.5 F
39 34.4 F
42 22.4 F
43 75.6 F
45 59.7 F
48 62.8 F
Mean 38.35
Standard Deviation 18.29
9 years ago
Purchase the answer to view it
a____week_1.xlsx
