excel

profilemr.5rmasho
stat231-lab2-s16.xlsx
Home>Mathematics homework help>excel

Wage data

wage I. Assume that the estimated mean and standard deviation are actually the population mean
18.7 20.61566 and standard deviation of wages that are normally distributed.
11.5 12.8 A) Find the probability that an individual has wages below $10 per hour.
15.04 Put your answer is cell E5 with the correct pdf function in the cell reference.
25.95
24.03 B) Find the probability that an individual has a wage above $15 per hour.
20 Put your answer is cell E8 with the correct pdf function in the cell reference.
53.84
25 C) Use your answers to find the probability that a worker has below $10 per hour or
28.85 above $15 per hour for their hourly wage.
16.83 Put your answer is cell F12 with the correct pdf function in the cell reference.
14.8
43.25 D) We found our answers above by assuming that the wage followed a normal distribution.
19.23 We can now find the actual number of individuals with a wage below $10 per hour.
14 In cell E16, type =countif(A2.A1001, "<10")
8
57.7 In cell E18, calculate the percentage of individuals with a wage below $10 per hour
20
20.83 E) Based on your answer to part A and part D, was the normal distribution a good
22 approximation to the data?
68.75
10.5
9.88
10.96
8.25
14.86
8.75
15.3
12.7
10.75
17.33
7.5
18.5
9
51.29
20.53
12.68
7.25
18.28
21.63
19.23
25
16.83
10.53
16.35
5.2
50
10
9
13
18.25
36.05
11.3
11
7.5
7.5
25.63
25.95
19.23
25
28
9
29.75
8.75
15.55
25.63
17.19
10.5
12.7
9.46
28.85
47.13
9
72.13
30.77
28.84
26.93
8
8
18.75
13
34.62
39.9
10.25
15.37
19.23
13.45
27.5
10
13.03
7.88
8
16.83
13.8
10.3
11.5
12
35.89
28.85
16.95
17
8
40.38
20
19.23
10
35.71
39.06
9
13.5
31.25
19.23
29.91
13.5
15
32.68
29.08
27.83
14.25
38.47
18.28
20
9
12
12
25.63
22.05
10.5
6.76
6.5
9.32
10.58
24.03
18
18.03
39.23
18.52
24.05
28.85
9.57
14.95
15.65
25
27.88
15.4
19.23
38
15.38
28.85
15.88
25
11.35
15.38
30.76
18.75
72.13
13.75
24.05
17.5
43.25
9.93
24.63
36.3
30.9
11
12.5
28.85
10
25.35
12.31
21.27
17.49
23
36.05
9
27.3
21.63
17
14.29
35.1
16
7
21.63
9.25
15.43
21.25
34.63
10
15.38
45.23
12
10
14
31.25
50.95
37.5
15.88
23.08
8.52
10
18
31.73
20
28
7.25
14.4
21.63
24.05
21
24.29
6
12.5
19.23
15.53
7.25
35.49
19.24
22.7
30.7
10
72.13
72.13
19.23
9.9
15
6.5
28.72
34.63
12.03
9
30
3.75
16.83
12.08
43.8
8.25
19.55
21.54
14.5
10.5
11.3
35
19.55
10.94
13.33
18
9.5
18
15
13
19.2
11.5
36.52
10
20.04
24.03
31.25
13.04
16
31.25
16.88
29.8
7.6
11
16.28
17.57
24.33
16.24
22
25
20
43
40.38
11.5
19.23
7.5
19.23
21.5
26
16.08
14
23.06
13.25
61.11
11.25
16.83
8
8.63
18.75
30.33
40.46
27.63
11
7.5
17.88
8
18.3
28.83
13
25.32
18.9
17.86
9.26
18.49
14.43
24.05
6.87
19.24
24.05
20.09
26
21.15
27.4
38.45
12.86
10.3
11
15.13
24.05
13
20.2
7.5
8
7.25
11.5
24.05
24.05
13.73
7.93
8.75
13.2
15
15.39
8
35.25
14.68
12.4
12.5
10
21.67
20
13.08
7
19.23
15
6.5
8.5
6.35
19.24
20.63
24.05
48.55
13.16
12.75
19.57
8.53
10
24.33
11
33.65
14.91
14.16
10.78
21.36
38.23
36.71
6.25
27.1
10
8
7.5
10.38
13.73
54.05
17.3
20.3
7.14
25
31.15
9.5
8.1
8.5
25.96
13.75
12.5
9
57.69
72.13
36.05
19.79
50
7.49
16
40.38
33.65
38.45
52.88
13
24.05
8.75
40.38
8.8
15.56
10
9.34
10.5
18
6.93
17.5
24.05
12.31
32.7
9.5
17.5
25
14.43
9.33
17.48
12.5
8
17.3
15.38
6.5
44.43
15.85
14.4
7.29
19.7
21
11
16.57
48.55
12
40.15
22.4
11.5
28.85
24.23
24.05
7.5
11.25
19.23
12.98
16.56
23
12
53.57
8.85
47.8
20
1.97
10.51
9
9.73
38.45
28
27.23
13.03
30
10.1
16.25
15.25
35
57.68
50
9.63
10
15.23
10.5
10
20.1
8
17
35.17
9
12.9
12.75
24.05
10.19
38.45
14.25
12.03
19.23
8.75
29.1
33.65
16
13.88
25
15
25.18
17.5
36.8
32.68
28.83
25.25
16
18
14.5
41.35
16.25
9
17.71
15.45
23.08
8
13.75
8.76
8.78
7.75
28.85
20.2
9.23
14
25
21.48
12.97
27
37.5
21.15
2.88
9.75
16
13
48.08
7.7
22.6
5.73
14.4
33.5
18.82
17.5
11
9.35
16.25
9.5
76.39
36.67
9
51.52
15
38.75
15.38
43.28
17.3
33.65
2.5
16.25
14.6
12.5
36.05
19.23
9.24
9.15
36.05
16.25
14.55
29.4
50.03
28
28.83
72.13
13
6.14
36.33
18.06
22.64
15
42.11
13.8
55
10.4
24.03
20.63
12.5
24.95
23.49
28
9.5
34.63
48.55
8.06
17.36
28.44
35.75
13.95
9
21
20
8.33
65.98
13
21.33
15
8.1
15
15
18.75
9.78
9.83
10
12.5
30.44
12.5
13.45
29.8
26.78
10
21.52
12.87
22.5
15
24.79
6.66
10.73
10.5
13.16
9.75
17
36.05
41.54
34.18
50
6.73
6.38
20.6
6.75
10
26.78
72.13
21.63
44.23
17.35
25.73
50
20
8
34.63
9.5
7.7
9
16
8.75
11
13.82
13.1
19.23
18.45
14.43
21.93
16.1
14.5
15.71
28.18
28.85
57.7
28.85
23.08
25.25
15
23.08
21.88
8.26
12.03
8.5
40
30
28
9.5
23.07
22.3
7.52
38.45
18.75
2.52
26.14
36.06
12
15.38
16.23
31.25
20
10.38
9.48
25
10.49
11.5
8
14.5
38.45
11.5
45.65
14
5.33
12.9
23.63
30.3
20.2
31.25
26.44
23
32.68
18.25
20.2
22.6
7.45
13
8
26.1
46.16
8
16
8.76
33.65
11.78
47.62
24.45
34.18
31.73
18.45
34.62
21.36
38.46
2.3
22.65
4.33
31.25
8.5
22.76
19.55
17.96
24.04
44.24
31.88
28.83
39.9
61.82
25.38
12
8.65
38.45
38.45
7.2
7.5
25
18.48
61.54
15.8
39.43
10
6.25
28.85
15.33
23.3
9
21.8
15.33
10
20.17
25.64
10.5
10.38
16.83
15.75
19.24
8.65
10.85
18.7
16.22
9
12
6.77
20.13
15
10
12
17.96
37.6
14.43
42
41.52
23.08
24.53
9.52
12
13.8
42
10.55
10
12.75
8.75
28.85
25
25
25
9
72.13
21.03
35.23
9.4
12.5
37.5
6.5
52.5
7.5
31.25
25
10.48
17.75
13
5.97
25
18.5
11.55
44.87
7.4
11.85
24.17
7.2
18.18
14
36.05
13.61
34.63
17.3
14
29.9
15
16.14
38
7.98
24.03
23.51
22.43
15.75
11.5
21.63
45.45
35.63
19.05
30.63
16.35
12.4
31.25
14.1
24
27.49
7.9
11
16.83
57.68
11
6.4
16.83
19.58
28.52
12
21.15
14.9
14.26
8.15
32.3
7
22.5
30
24.14
72.13
11.8
60.1
19.23
12.82
15
21.25
11.51
28.83
25.64
12.26
10
8
25.48
52.88
19.22
19.23
15
19.23
23.58
4.58
9
15
25
29.8
64.11
19.23
27.4
21.63
10
11.55
38.45
17
64.11
28.1
21.25
10.58
16.67
31.75
25.75
17.42
21.63
7.97
48.08
21.25
10
19.63
16
19.23
28.85
8.5
60
9.63
9
37.18
33.65
16.25
14.43
10
19.23
19.23
7
24.03
7.57
12.5
11.4
13
25
22.13
13.5
8
11.25
14.43
9.8
17.3
8
35.76
10
19.23
20
10.25
17.63
14.53
5.9
18.46
39.33
7.5
16
14.5
62.03
16.35
24.44
17
14.96
67.3
21
20.4
16
12.82
20
12
35.1
12.5
31.73
12.38
12.5
21
21.38
12.5
57.7
29.76
18
7.25
9
27.7
28
12
9.7
7
18.24
25.95
16.04
14
40.08
8
16.93
11.5
21.15
7.2
23.1
16.83
28.85
11.25
7.5
8.5

Discrete Probability Dist

I. Practice using each of the discrete probability distribution functions in any cell before attempting the problems shown below.
You can delete your practice cells when done.
II. A) Suppose that 60% of the population gets their primary news from late night television, such as the Daily Show.
If we sample 100 individuals, find the probability that 58 of them get their primary news from late night television.
Put your answer is cell B7 with the correct pdf function in the cell reference.
II B) Using the same scenario as the problem above, find the probability the 58 or fewer of them get their primary
news from late night television.
Put your answer in cell B12 with the correct pdf function in the cell reference.
IIC) Using the same scenario as the problem above, find the probability that more than 58 of them get their primary
news from late night television.
Put your answer in cell B17 with the correct pdf function in the cell reference.
IIIA) According to the US Geological survey, there are an average of 15 earthquakes per year that are of a
magnitude 7.0 - 7.9 worldwide. Find the probability that there will be 1 earthquake next year.
Put your answer in cell B19 with the correct pdf function in the cell reference.
IIIB) Using the same scenario as above, find the probability that there will not be an earthquake of that
magnitude next year.
Put your answer in cell B23 with the correct pdf function in the cell reference.
IV) In a federal prison, 120 of the 300 inmates are serving time for drug-related offenses. If
eight of the inmates are chosen at random to appear before a legislative committee, what is the probability
that half of the inmates chosen will be serving time for drug-related offenses?
Put your answer in cell B28 with the correct pdf function in the cell reference.
V) Among the 200 employees of a compnay, 120 are union members while the others are not.
If six of the employees are chosen to serve on a committee that adminsters the pension fund,
find the probability that three of them will be union members while the others are not.
Put your answer in cell B33 with the correct pdf function in the cell reference.

Trashbag

Strength
48.5
52.3
53.5
50.5
50.3
49.6
51.0
48.3
50.6
50.2
52.5
47.5
50.9
49.8
50.0
50.8
53.0
50.9
49.9
50.1
50.7
48.2
51.5
49.0
51.7
53.2
51.1
52.6
51.2
49.5
49.4
51.9
52.0
48.8
46.8
51.3
49.3
54.0
49.2
51.4