Use the following cell phone airport data speeds? (Mbps) from a particular netwo
ID: 2946437 • Letter: U
Question
Use the following cell phone airport data speeds? (Mbps) from a particular network. Find
Upper P 60
0.1
0.2
0.2
0.4
0.4
0.5
0.5
0.6
0.6
0.7
0.7
0.7
0.8
0.8
0.8
0.9
1.1
1.6
1.7
1.8
1.8
2.1
2.4
2.5
2.7
2.9
3.4
3.5
3.5
3.9
4.6
4.6
5.7
6.5
7.2
7.5
8.9
10.3
10.5
10.8
11.3
11.4
12.3
12.3
12.9
13.3
14.2
14.8
15.9
28.6
Use the following cell phone airport data speeds? (Mbps) from a particular network. Find
Upper Q3.
0.1
0.2
0.3
0.3
0.4
0.5
0.6
0.6
0.7
0.7
0.7
0.7
0.8
0.8
0.9
1.1
1.2
1.5
1.6
1.8
1.9
1.9
2.1
2.4
2.4
2.7
2.7
2.8
2.9
3.1
3.3
3.5
3.7
4.3
4.7
5.6
5.8
6.5
6.8
7.8
7.9
8.3
8.5
11.7
12.5
12.5
13.5
14.4
14.7
30.1
Explanation / Answer
Solution:
Used Excel to find the percentile
=PERCENTILE(A2:A51;0.6)
P 60=4.18
To get the quartile 3
=QUARTILE(H2:H51;3)
6.325
Q3=6.325
4.18