MATH 107 UA Score Value and Standard Normal Table Questionnaire

User Generated

oelfbawhyrf

Mathematics

Math 107

The University Of Arizona

MATH

Description

Unformatted Attachment Preview

Students’ Heights Excel Project 5 Before you begin… Open the Project Instructions and follow them to complete your Project 2 Excel Template. The following slides will then ask you to complete various tasks regarding your Excel project. • Most slides will require you to annotate the slides. Make sure you show your math computations and answer the questions in complete sentences. • One slide will require you to create a Zoom video recording of yourself working in Excel and interpreting your result. Make sure to add the link to your Zoom cloud recording in assignment’s Student Work section in Teams. Demonstrate in a Zoom video how you used the mean and standard deviation in Excel to calculate the z-score in cell B2. Explain what the z-score value tell us about each the following Math 107 students and their relationship to the mean? • A 76-inch male student • A 67-inch male student Display your histogram and explain how the shape helps you to know that the data is approximately normally distributed. Display your relative frequency table and compare the percentages of observations within one, two, and three standard deviation of the mean with those required by the Empirical Rule. Distance from Mean By Empirical Rule Within 1 Standard Deviation of the Mean 68% Within 2 Standard Deviations of the Mean 95% Within 3 Standard Deviations of the Mean 99.7% Our Relative Frequency Table Knowing this data is approximately normally distributed, use the standard normal table, normalcdf on your calculator, or norm.dist on Excel to find the probability that a male Math 107 student is shorter than 66 inches. Show your work! Knowing this data is approximately normally distributed, use the standard normal table, normalcdf on your calculator, or norm.dist on Excel to find the probability that a male Math 107 student is taller than 70 inches. Show your work! Knowing this data is approximately normally distributed, use the standard normal table, normalcdf on your calculator, or norm.dist on Excel to find the probability that a male Math 107 student is between 68 and 72 inches tall. Show your work!
Purchase answer to see full attachment
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

Explanation & Answer

Please view explanation and answer below.

Stage 2
Shear
0.00%
14.00%
18.00%
26.65%
34.98%
49.13%
61.37%
70.65%
78.98%
87.00%
93.55%
96.11%
100.00%
100.00%
100.00%
100.00%
25
16.37
3.5
0

`Stage 3
Stage 1
50
100
H.Dis.
V. Dis.
Shear
H.Dis.
V. Dis.
Shear
H.Dis.
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00
8.33%
11.53%
8.33%
11.00%
0.29
16.67%
27.48% 16.67%
30.23%
0.58
25.00%
42.93% 25.00%
42.11%
0.87
33.33%
56.44% 33.33%
50.42%
1.17
41.67%
67.33% 41.67%
62.70%
1.46
50.00%
75.32% 50.00%
70.33%
1.75
58.33%
86.23% 58.33%
79.33%
2.04
66.67%
90.43% 66.67%
86.43%
2.33
75.00%
94.00% 75.00%
94.00%
2.62
83.33%
100.00% 83.33%
96.40%
2.92
91.67%
98.00% 91.67%
100.00%
3.21
100.00%
96.00% 100.00%
97.66%
3.50
100.00%
96.00% 100.00%
97.66%
3.50
100.00%
96.00% 100.00%
97.66%
3.50
100.00% 100.00% 96.00% 100.00% 100.00% 97.66%
3.50
50
100
28.34
46.18
ϕ
21.4
3.75
4.3
C
7.45
0
0
40

Stage 2
25
V. Dis.
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
ID:
Date:

Shear
0.00
2.29
2.95
4.36
5.73
8.04
10.05
11.57
12.93
14.24
15.31
15.73
16.37
16.37
16.37
16.37

H.Dis.
0.00
0.31
0.62
0.94
1.25
1.56
1.88
2.19
2.50
2.81
3.13
3.44
3.75
3.75
3.75
3.75

MA 0% CBA - 0D
October 21, 2020

Stage 3
50
V. Dis.
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00

Shear
0.00
3.27
7.79
12.17
16.00
19.08
21.35
24.44
25.63
26.64
28.34
27.77
27.21
27.21
27.21
27.21

H.Dis.
0.00
0.36
0.72
1.07
1.43
1.79
2.15
2.51
2.87
3.22
3.58
3.94
4.30
4.30
4.30
4.30

100
V. Dis.
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00

S-D
Shear
0.00
5.08
13.96
19.45
23.28
28.95
32.48
36.63
39.91
43.41
44.52
46.18
45.10
45.10
45.10
45.10

50.00

Shear Stress

25
No H.Dis.
V. Dis.
1
0.00%
0.00%
2
8.33%
3
16.67%
4
25.00%
5
33.33%
6
41.67%
7
50.00%
8
58.33%
9
66.67%
10
75.00%
11
83.33%
12
91.67%
13 100.00%
14 100.00%
15 100.00%
16 100.00% 100.00%
Shear Stress Stage
Peak Shear
H. Displacement
V. Displacement

40.00
30.00
20.00
10.00
0.00
0

1

2

3

4

5

H. Displacement
Stage 1

Stage 2

Stage 3

S-N
50

Shear Stress

Stage 1

40

30

0
7.45
100 46.61571

20
10
0
0

20

40

60

Normal Stress

80

100

Stage 2
Shear
0.00%
9.14%
13.44%
31.11%
45.76%
57.98%
64.79%
72.86%
80.63%
86.25%
93.55%
96.11%
100.00%
100.00%
100.00%
100.00%
25
16.34
3.5
0

`Stage 3
Stage 1
50
100
H.Dis.
V. Dis.
Shear
H.Dis.
V. Dis.
Shear
H.Dis.
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00
8.33%
12.00%
8.33%
12.00%
0.29
16.67%
22.00% 16.67%
27.89%
0.58
25.00%
28.00% 25.00%
40.36%
0.87
33.33%
38.13% 33.33%
54.90%
1.17
41.67%
55.52% 41.67%
66.25%
1.46
50.00%
64.25% 50.00%
75.32%
1.75
58.33%
74.42% 58.33%
82.11%
2.04
66.67%
86.14% 66.67%
88.90%
2.33
75.00%
94.52% 75.00%
92.45%
2.62
83.33%
100.00% 83.33%
100.00%
2.92
91.67%
99.76% 91.67%
98.76%
3.21
100.00%
99.00% 100.00%
99.00%
3.50
100.00%
99.00% 100.00%
99.00%
3.50
100.00%
99.00% 100.00%
99.00%
3.50
100.00% 100.00% 99.00% 100.00% 100.00% 99.00%
3.50
50
100
28.25
46.46
ϕ
21.6
4.3
4.3
C
7.235
0
0

Stage 2
25
V. Dis.
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
ID:
Date:

Shear
0.00
1.49
2.20
5.08
7.48
9.47
10.59
11.91
13.17
14.09
15.29
15.70
16.34
16.34
16.34
16.34

H.Dis.
0.00
0.36
0.72
1.07
1.43
1.79
2.15
2.51
2.87
3.22
3.58
3.94
4.30
4.30
4.30
4.30

LA 0% CBA - 0D
October 21, 2020

Stage 3
50
V. Dis.
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00

Shear
0.00
3.39
6.22
7.91
10.77
15.68
18.15
21.02
24.33
26.70
28.25
28.18
27.97
27.97
27.97
27.97

H.Dis.
0.00
0.36
0.72
1.07
1.43
1.79
2.15
2.51
2.87
3.22
3.58
3.94
4.30
4.30
4.30
4.30

100
V. Dis.
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00

S-D
Shear
0.00
5.58
12.96
18.75
25.51
30.78
34.99
38.15
41.30
42.95
46.46
45.88
46.00
46.00
46.00
46.00

50.00

Shear Stress

25
No H.Dis.
V. Dis.
1
0.00%
0.00%
2
8.33%
3
16.67%
4
25.00%
5
33.33%
6
41.67%
7
50.00%
8
58.33%
9
66.67%
10
75.00%
11
83.33%
12
91.67%
13 100.00%
14 100.00%
15 100.00%
16 100.00% 100.00%
Shear Stress Stage
Peak Shear
H. Displacement
V. Displacement

40.00
30.00
20.00
10.00
0.00
0

1

2

3

4

5

H. Displacement
Stage 1

Stage 2

Stage 3

S-N
50

Shear Stress

Stage 1

40

30

0
7.235
100 46.86071

20
10
0
0

20

40

60

Normal Stress

80

100

Stage 2
Shear
0.00%
9.00%
12.00%
24.65%
41.54%
55.79%
63.78%
74.76%
84.79%
88.52%
93.25%
97.66%
100.00%
100.00%
100.00%
100.00%
25
16.43
3.25
0

`Stage 3
Stage 1
50
100
H.Dis.
V. Dis.
Shear
H.Dis.
V. Dis.
Shear
H.Dis.
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00
8.33%
12.00%
8.33%
13.00%
0.27
16.67%
25.42% 16.67%
28.66%
0.54
25.00%
38.58% 25.00%
38.98%
0.81
33.33%
56.11% 33.33%
57.30%
1.08
41.67%
65.98% 41.67%
67.90%
1.35
50.00%
76.43% 50.00%
75.02%
1.62
58.33%
88.31% 58.33%
80.00%
1.90
66.67%
90.72% 66.67%
88.54%
2.17
75.00%
95.48% 75.00%
95.66%
2.44
83.33%
97.86% 83.33%
100.00%
2.71
91.67%
100.00% 91.67%
98.67%
2.98
100.00%
98.88% 100.00%
98.00%
3.25
100.00%
98.88% 100.00%
98.00%
3.25
100.00%
98.88% 100.00%
98.00%
3.25
100.00% 100.00% 98.88% 100.00% 100.00% 98.00%
3.25
50
100
28.44
46.56
ϕ
21.6
4.3
4.3
C
7.37
0
0

Stage 2
25
V. Dis.
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
ID:
Date:

Shear
0.00
1.48
1.97
4.05
6.83
9.17
10.48
12.28
13.93
14.54
15.32
16.05
16.43
16.43
16.43
16.43

H.Dis.
0.00
0.36
0.72
1.07
1.43
1.79
2.15
2.51
2.87
3.22
3.58
3.94
4.30
4.30
4.30
4.30

N 0% CBA - 0D
October 21, 2020

Stage 3
50
V. Dis.
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00

Shear
0.00
3.41
7.23
10.97
15.96
18.76
21.74
25.12
25.80
27.15
27.83
28.44
28.12
28.12
28.12
28.12

H.Dis.
0.00
0.36
0.72
1.07
1.43
1.79
2.15
2.51
2.87
3.22
3.58
3.94
4.30
4.30
4.30
4.30

100
V. Dis.
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00

S-D
Shear
0.00
6.05
13.34
18.15
26.68
31.61
34.93
37.25
41.22
44.54
46.56
45.94
45.63
45.63
45.63
45.63

50.00

Shear Stress

25
No H.Dis.
V. Dis.
1
0.00%
0.00%
2
8.33%
3
16.67%
4
25.00%
5
33.33%
6
41.67%
7
50.00%
8
58.33%
9
66.67%
10
75.00%
11
83.33%
12
91.67%
13 100.00%
14 100.00%
15 100.00%
16 100.00% 100.00%
Shear Stress Stage
Peak Shear
H. Displacement
V. Displacement

40.00
30.00
20.00
10.00
0.00
0

1

2

3

4

5

H. Displacement
Stage 1

Stage 2

Stage 3

S-N
50

Shear Stress

Stage 1

40

30

0
7.37
100 46.98143

20
10
0
0

20

40

60

Normal Stress

80

100

Shear
0.00%
5.00%
18.64%
31.40%
42.76%
51.76%
59.86%
68.23%
78.00%
85.87%
93.00%
97.87%
100.00%
100.00%
100.00%
100.00%
25
18.47
3
0

Stage 2

`Stage 3

50
H.Dis.
V. Dis.
0.00%
0.00%
8.33%
16.67%
25.00%
33.33%
41.67%
50.00%
58.33%
66.67%
75.00%
83.33%
91.67%
100.00%
100.00%
100.00%
100.00% 100.00%
50
100
28.44
48.15
4.3
4
0
0

100
H.Dis.
V. Dis.
0.00%
0.00%
8.33%
16.67%
25.00%
33.33%
41.67%
50.00%
58.33%
66.67%
75.00%
83.33%
91.67%
100.00%
100.00%
100.00%
100.00% 100.00%

Shear
0.00%
12.00%
17.54%
34.12%
48.99%
65.42%
74.60%
83.98%
88.09%
94.00%
97.98%
98.77%
100.00%
100.00%
100.00%
100.00%

ϕ
C

Stage 1

21.6
8.615

Shear
0.00%
17.54%
34.53%
47.61%
59.65%
73.75%
80.75%
88.00%
91.00%
97.66%
98.01%
98.37%
100.00%
100.00%
100.00%
100.00%

H.Dis.
0.00
0.25
0.50
0.75
1.00
1.25
1.50
1.75
2.00
2.25
2.50
2.75
3.00
3.00
3.00
3.00

Stage 2
25
V. Dis.
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00

Shear
0.00
0.92
3.44
5.80
7.90
9.56
11.06
12.60
14.41
15.86
17.18
18.08
18.47
18.47
18.47
18.47

H.Dis.
0.00
0.36
0.72
1.07
1.43
1.79
2.15
2.51
2.87
3.22
3.58
3.94
4.30
4.30
4.30
4.30

ID: MA 4% CBA - 28D
Date: November 18, 2020

Stage 3
50
V. Dis.
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00

Shear
0.00
3.41
4.99
9.70
13.93
18.61
21.22
23.88
25.05
26.73
27.87
28.09
28.44
28.44
28.44
28.44

H.Dis.
0.00
0.33
0.67
1.00
1.33
1.67
2.00
2.33
2.67
3.00
3.33
3.67
4.00
4.00
4.00
4.00

100
V. Dis.
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00

S-D
Shear
0.00
8.45
16.63
22.92
28.72
35.51
38.88
42.37
43.82
47.02
47.19
47.37
48.15
48.15
48.15
48.15

60.00
50.00

Shear Stress

25
No H.Dis.
V. Dis.
1
0.00%
0.00%
2
8.33%
3
16.67%
4
25.00%
5
33.33%
6
41.67%
7
50.00%
8
58.33%
9
66.67%
10
75.00%
11
83.33%
12
91.67%
13 100.00%
14 100.00%
15 100.00%
16 100.00% 100.00%
Shear Stress Stage
Peak Shear
H. Displacement
V. Displacement

40.00
30.00
20.00
10.00
0.00
0

1

2

3

4

5

H. Displacement
Stage 1

Stage 2

Stage 3

S-N
Shear Stress

Stage 1

60
50
40
30
20
10
0

0
8.615
100 48.16643
0

20

40

60

Normal Stress

80

100

Shear
0.00%
7.52%
14.63%
26.64%
47.86%
60.17%
72.75%
82.87%
89.07%
96.46%
100.00%
100.00%
100.00%
100.00%
100.00%
100.00%
25
18.12
3.5
0

Stage 2

`Stage 3

50
H.Dis.
V. Dis.
0.00%
0.00%
8.33%
16.67%
25.00%
33.33%
41.67%
50.00%
58.33%
66.67%
75.00%
83.33%
91.67%
100.00%
100.00%
100.00%
100.00% 100.00%
50
100
29.39
49.46
4
3.75
0
0

100
H.Dis.
V. Dis.
Shear
0.00%
0.00%
0.00%
8.33%
7.00%
16.67%
21.00%
25.00%
34.73%
33.33%
52.74%
41.67%
62.85%
50.00%
74.98%
58.33%
85.74%
66.67%
90.45%
75.00%
97.40%
83.33%
100.00%
91.67%
100.00%
100.00%
96.00%
100.00%
96.00%
100.00%
96.00%
100.00% 100.00% 96.00%

Shear
0.00%
10.33%
22.00%
34.87%
45.65%
45.00%
60.00%
73.87%
82.75%
94.00%
100.00%
100.00%
100.00%
100.00%
100.00%
100.00%

ϕ
C

Stage 1

22.6
8.085

H.Dis.
0.00
0.29
0.58
0.87
1.17
1.46
1.75
2.04
2.33
2.62
2.92
3.21
3.50
3.50
3.50
3.50

Stage 2
25
V. Dis.
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00

Shear...


Anonymous
Really helpful material, saved me a great deal of time.

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4

Related Tags