Use the following cell phone airport data speeds? (Mbps) from a particular netwo

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

Related Questions

Navigate

• Browse (All)
• Browse U
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.