A.) find the probability that a student would work over 30 hours a week. B.)find
ID: 3266342 • Letter: A
Question
A.) find the probability that a student would work over 30 hours a week.
B.)find the hours of work for those in the top 8%
Pad 12:46 PM hartnell.instructure.com Math13ReviewForFinal.pdf Download Info ×Close Page of 2 ZOOM Accoun Dashbo e Gen Sibs Work ExerciseUnits Mom 10 15 15 13 15 16 17 23 14 Cour 16 20 18 18 18 18 16 16 16 16 16 14 14 14 13 13 12 12 12 12 12 12 12 12 12 12 10 13 18 37 13 19 21 16 16 25 25 10 28 16 25 10 10 19 19 19 19 21 21 19 21 17 Help 15 20 13 18 16 15 20 21 36 25 10 15 15 24 15 19 19 10 13 13 16 12 16 21 21 25 19 37 19 12 10 13 16 6Explanation / Answer
A
B
C
1
20
0
2
0
0
3
20
0
4
0
0
5
22
0
6
11
0
7
48
1
8
37
1
9
0
0
10
30
0
11
25
0
12
25
0
13
10
0
14
28
0
15
16
0
16
25
0
17
0
0
18
15
0
19
0
0
20
20
0
21
0
0
22
36
1
23
25
0
24
20
0
25
24
0
26
30
0
27
20
0
28
22
0
29
20
0
30
16
0
31
20
0
32
25
0
33
30
0
34
12
0
35
40
1
36
20
0
A)Steps in Excel :
1.Enter the data for work hours only.
2.In the cell C1, type “=IF(A1>30,1,0)” to check if the value is greater than 30.
Drag by holding the cell pointer on the bottom right corner of the cell C1 and drag till C36 to copy the formula.
3. Find the sum of the column C which will give us the number of individuals working > 30 hours since if an individual has working hours > 30, we have assigned 1.
Type “=SUM(C1:C36)”.
Here, we get 4.
4.To find the probability, divide the sum by total number of individuals i.e 36.
Thus, we get probability = 4/36 = 0.111111.
B)To find the hours of work for those in the top 8% is same as finding the (100-8) = 92th percentile for the data.
Excel steps :
Type in a cell “=PERCENTILE(A1:A36,0.92)”.
The required hours of work = 36.2.
A
B
C
1
20
0
2
0
0
3
20
0
4
0
0
5
22
0
6
11
0
7
48
1
8
37
1
9
0
0
10
30
0
11
25
0
12
25
0
13
10
0
14
28
0
15
16
0
16
25
0
17
0
0
18
15
0
19
0
0
20
20
0
21
0
0
22
36
1
23
25
0
24
20
0
25
24
0
26
30
0
27
20
0
28
22
0
29
20
0
30
16
0
31
20
0
32
25
0
33
30
0
34
12
0
35
40
1
36
20
0
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.