**The table is bottom of these questions
a) What are the quartiles?
b) What are the deciles?
c) Where would 150 minutes rank as a percentile?
d) Where would 160 minutes rank as percentile?
Times |
175.21 |
175.18 |
176.6 |
141.83 |
174.09 |
158.53 |
140.57 |
172.2 |
152.03 |
177.64 |
171.46 |
141.97 |
158.39 |
143.76 |
165.63 |
173.9 |
185.41 |
141.18 |
175.58 |
173.18 |
183.97 |
152.07 |
146.59 |
142.33 |
164.87 |
165.06 |
143.44 |
191.42 |
147.78 |
143.96 |
171.33 |
169.49 |
145.11 |
176.29 |
164.17 |
146.67 |
192.84 |
144.69 |
140.95 |
158.75 |
145.91 |
170.43 |
219.96 |
141.06 |
173.24 |
176.98 |
144.41 |
153.34 |
156.9 |
140.1 |
150.51 |
165.08 |
201.79 |
178.38 |
160.88 |
The whole question can be solved easily using excel
First step is to sort the numbers in ascending order
1. use "quartile.exec(array,1or2or3) in order to determine first, second or third quartile
first quartile | second quartile (median) | third quartile |
145.11 | 164.17 | 175.18 |
2. use "PERCENTILE.EXC(array, 0.1)" to find the first decile and so on until the 9th decile
141.57 | 1st decile |
144.05 | 2nd decile |
146.654 | 3rd decile |
154.764 | 4th decile |
164.17 | 5th decile |
170.054 | 6th decile |
173.372 | 7th decile |
176.148 | 8th decile |
184.546 | 9th decile |
3. use "=PERCENTRANK.EXC(array,150)" to find the percentile of 150 = 0.335 = 33.5th percentile
4. use "=PERCENTRANK.EXC(array,160)" to find the percentile of 160 = 0.474 = 47.4th percentile
Get Answers For Free
Most questions answered within 1 hours.