The bank data shown in the table is from a promotion conducted by a bank during

Question

The bank data shown in the table is from a promotion conducted by a bank during the month of September. Each record represents a transaction of: an Existing or New customer; an opening of an account type (savings, Cd, etc.); in a particular $ Amount;at a particular branch (Central, Westside, etc.); the account transaction was performed by a teller or a New Accts agent. Data is also collected on the customers age and the day of the week the account was opened.

a.) What is the 71st percentile on the $ Amount using the percentile function (use the Excel ".INC." version)?

b.) What is the rank of the 71st percentile of the $Amount using the common formula for calculating the reank of the Kth percentile?

c.) What is the 71st percentile of the $Amount using the Rank and Percentile Data Analysis tool in Excel?

OpenedBy Branch Customer Age of Cust DoW New Accts Central Existing 91 Mon New Accts Central Existing 89 Mon New Accts Central Existing 88 Mon Teller Central Existing 79 Mon New Accts Westside New 75 Mon Teller Westside Existing 75 Mon New Accts North County Existing 75 Mon New Accts Central Existing 73 Mon New Accts North County Existing 68 Mon New Accts Central New 64 Mon New Accts North County Existing 61 Mon New Accts Central Existing 60 Mon New Accts Central Existing 57 Mon New Accts Westside Existing 55 Mon New Accts North County New 46 Mon Teller Central Existing 44 Mon New Accts Westside Existing 43 Mon New Accts Central Existing 42 Mon New Accts Westside Existing 35 Mon New Accts North County Existing 27 Mon New Accts Westside Existing 93 Thu New Accts Westside Existing 88 Thu New Accts Central Existing 87 Thu New Accts Westside New 85 Thu New Accts North County Existing 84 Thu New Accts North County New 81 Thu New Accts North County New 80 Thu New Accts Central Existing 79 Thu New Accts Central Existing 78 Thu New Accts Central New 77 Thu New Accts Westside Existing 71 Thu Teller Central Existing 68 Thu New Accts Central New 64 Thu New Accts Central Existing 57 Thu New Accts North County Existing 51 Thu New Accts Central Existing 49 Thu New Accts Westside Existing 43 Thu Teller North County Existing 41 Thu New Accts Central Existing 40 Thu New Accts Central Existing 26 Thu New Accts Central Existing 20 Thu New Accts North County Existing 20 Thu New Accts Central New 102 Fri New Accts Westside Existing 91 Fri Teller North County Existing 89 Fri New Accts North County Existing 84 Fri New Accts North County Existing 83 Fri Teller North County Existing 83 Fri New Accts North County Existing 78 Fri New Accts Central Existing 78 Fri New Accts Central Existing 74 Fri New Accts Central Existing 67 Fri New Accts North County Existing 60 Fri New Accts North County Existing 53 Fri New Accts Central New 47 Fri Teller Central Existing 47 Fri Teller Westside Existing 42 Fri Teller Westside Existing 39 Fri Teller Westside Existing 36 Fri Teller North County Existing 34 Fri New Accts North County New 30 Fri New Accts North County Existing 30 Fri Teller Westside Existing 27 Fri New Accts North County New 23 Fri Teller North County Existing 91 Sat New Accts North County Existing 89 Sat New Accts Central Existing 86 Sat New Accts Westside Existing 86 Sat Teller Central Existing 85 Sat New Accts Westside Existing 84 Sat Teller Central Existing 82 Sat Teller North County Existing 78 Sat New Accts Central Existing 78 Sat New Accts Westside Existing 75 Sat New Accts Westside New 66 Sat New Accts Central Existing 64 Sat New Accts Central Existing 53 Sat New Accts North County New 53 Sat Teller Central Existing 49 Sat New Accts North County Existing 43 Sat New Accts North County Existing 38 Sat New Accts Central Existing 30 Sat Teller Central Existing 93 Mon New Accts Central Existing 89 Mon New Accts Westside Existing 88 Mon New Accts Central Existing 88 Mon Teller North County Existing 87 Mon New Accts North County New 87 Mon New Accts Central Existing 86 Mon New Accts Westside New 85 Mon New Accts North County Existing 85 Mon New Accts North County Existing 84 Mon New Accts Westside Existing 84 Mon New Accts Central Existing 83 Mon New Accts North County Existing 78 Mon New Accts North County New 74 Mon New Accts Central Existing 72 Mon New Accts North County Existing 69 Mon New Accts Central Existing 67 Mon New Accts Westside Existing 63 Mon New Accts Central Existing 58 Mon New Accts Central New 56 Mon New Accts Central New 56 Mon New Accts Central Existing 54 Mon Teller Central Existing 53 Mon New Accts Central Existing 53 Mon New Accts North County Existing 48 Mon Teller North County Existing 46 Mon New Accts Central New 46 Mon New Accts North County Existing 44 Mon New Accts Central Existing 42 Mon New Accts Central New 41 Mon New Accts North County Existing 38 Mon Teller North County Existing 36 Mon New Accts Westside Existing 36 Mon New Accts Westside Existing 34 Mon New Accts Central Existing 32 Mon New Accts Central Existing 29 Mon New Accts North County Existing 27 Mon New Accts Central New 25 Mon New Accts Westside Existing 25 Mon New Accts Central Existing 24 Mon Teller Central Existing 20 Mon New Accts North County Existing 91 Thu New Accts Central Existing 85 Thu New Accts Westside Existing 83 Thu New Accts Central Existing 71 Thu New Accts Westside New 66 Thu New Accts Central Existing 61 Thu Teller Westside Existing 55 Thu New Accts Central Existing 49 Thu New Accts Central New 40 Thu New Accts Central New 34 Thu New Accts Central Existing 32 Thu New Accts North County Existing 26 Thu New Accts Central Existing 91 Fri New Accts Central New 88 Fri Teller Central Existing 85 Fri New Accts Westside Existing 77 Fri New Accts Westside Existing 73 Fri New Accts North County Existing 65 Fri New Accts North County Existing 55 Fri New Accts Central Existing 55 Fri New Accts Central Existing 53 Fri New Accts Central Existing 47 Fri New Accts Central Existing 26 Fri Teller Central Existing 93 Sat New Accts Central New 86 Sat New Accts Central Existing 84 Sat New Accts North County New 75 Sat Teller North County Existing 75 Sat New Accts Central Existing 75 Sat New Accts Central New 69 Sat New Accts Central New 65 Sat Teller North County Existing 58 Sat New Accts North County Existing 34 Sat Teller Central Existing 32 Sat New Accts Central Existing 23 Sat Teller Central Existing 20 Sat New Accts Westside New 19 Sat New Accts Central Existing 91 Mon New Accts Central Existing 89 Mon New Accts Central Existing 86 Mon New Accts North County Existing 86 Mon New Accts Central Existing 85 Mon New Accts North County Existing 84 Mon Teller North County Existing 83 Mon New Accts Central Existing 71 Mon New Accts Westside Existing 64 Mon New Accts Central Existing 64 Mon New Accts North County Existing 62 Mon New Accts North County Existing 60 Mon Teller Central Existing 58 Mon New Accts Westside Existing 57 Mon New Accts Westside Existing 56 Mon New Accts Central Existing 56 Mon New Accts North County Existing 54 Mon New Accts North County Existing 50 Mon New Accts Westside Existing 47 Mon New Accts Westside Existing 43 Mon New Accts Central Existing 40 Mon New Accts North County Existing 38 Mon New Accts Central Existing 36 Mon Teller Central Existing 32 Mon New Accts Central New 30 Mon New Accts Central Existing 23 Mon New Accts Central Existing 22 Mon New Accts North County New 20 Mon New Accts Westside Existing 20 Mon New Accts Westside Existing 20 Mon New Accts Central New 88 Thu Teller North County Existing 86 Thu New Accts Central Existing 80 Thu New Accts Central Existing 75 Thu New Accts Central Existing 74 Thu New Accts Westside Existing 73 Thu New Accts Central Existing 72 Thu New Accts Westside Existing 60 Thu Teller North County Existing 52 Thu Teller Westside Existing 51 Thu New Accts North County Existing 34 Thu New Accts Central Existing 97 Fri New Accts Westside Existing 89 Fri New Accts North County New 89 Fri New Accts Westside Existing 88 Fri New Accts Westside Existing 84 Fri New Accts Westside Existing 67 Fri New Accts Central Existing 61 Fri New Accts Central Existing 53 Fri New Accts Central Existing 25 Fri New Accts Central Existing 20 Fri Teller Westside Existing 19 Fri New Accts Central Existing 93 Sat New Accts North County Existing 88 Sat New Accts Central Existing 85 Sat New Accts Central Existing 84 Sat New Accts Central Existing 65 Sat Teller North County Existing 55 Sat New Accts North County Existing 34 Sat New Accts Westside Existing 33 Sat Teller North County Existing 23 Sat New Accts Westside Existing 18 Sat New Accts Central Existing 91 Mon New Accts North County Existing 91 Mon New Accts North County Existing 89 Mon New Accts Central Existing 88 Mon New Accts North County Existing 87 Mon New Accts Central Existing 84 Mon Teller Central Existing 82 Mon New Accts Westside Existing 79 Mon New Accts Central Existing 75 Mon Teller Central Existing 75 Mon New Accts North County Existing 74 Mon New Accts Central Existing 69 Mon New Accts Central Existing 62 Mon New Accts North County Existing 61 Mon New Accts Central Existing 60 Mon New Accts Westside New 59 Mon New Accts North County Existing 58 Mon New Accts Central Existing 58 Mon New Accts North County Existing 55 Mon New Accts Westside Existing 50 Mon New Accts Westside Existing 49 Mon New Accts Central Existing 48 Mon New Accts North County New 47 Mon New Accts Central New 42 Mon New Accts Westside Existing 42 Mon New Accts Central Existing 40 Mon New Accts Central Existing 39 Mon New Accts Central Existing 37 Mon New Accts North County Existing 36 Mon New Accts Central Existing 35 Mon New Accts North County New 33 Mon New Accts North County New 26 Mon New Accts Central New 26 Mon New Accts Central Existing 25 Mon New Accts Central Existing 23 Mon New Accts Central Existing 22 Mon New Accts Westside New 21 Mon New Accts Central Existing 86 Thu New Accts Central Existing 84 Thu New Accts Westside Existing 79 Thu New Accts Central Existing 70 Thu New Accts Central Existing 68 Thu New Accts Central Existing 56 Thu New Accts Central Existing 47 Thu New Accts Westside Existing 41 Thu Teller North County Existing 35 Thu New Accts North County Existing 35 Thu Teller North County Existing 23 Thu Teller Westside Existing 19 Thu New Accts Central Existing 93 Fri New Accts North County Existing 93 Fri New Accts Central Existing 88 Fri New Accts Westside New 86 Fri New Accts North County Existing 86 Fri New Accts Central New 80 Fri New Accts Central Existing 67 Fri New Accts Westside Existing 60 Fri New Accts Central Existing 58 Fri New Accts Central Existing 57 Fri New Accts North County Existing 45 Fri New Accts Central Existing 32 Fri Teller Westside Existing 91 Sat New Accts Central New 91 Sat New Accts Central Existing 91 Sat Teller North County Existing 88 Sat New Accts Central Existing 84 Sat New Accts Westside Existing 71 Sat New Accts Central New 58 Sat New Accts Central Existing 57 Sat New Accts North County Existing 52 Sat New Accts Westside Existing 42 Sat Teller Westside Existing 42 Sat New Accts Central Existing 40 Sat New Accts Westside Existing 39 Sat New Accts Central Existing 38 Sat Teller North County New 32 Sat New Accts Central Existing 30 Sat New Accts North County New 18 Sat Teller Central Existing 93 Sat New Accts North County New 93 Sat New Accts Central Existing 93 Sat New Accts Central Existing 91 Sat New Accts Central Existing 91 Sat New Accts Westside Existing 88 Sat New Accts Central New 88 Sat New Accts Central New 87 Sat New Accts Central Existing 84 Sat New Accts Westside Existing 83 Sat New Accts Central Existing 80 Sat New Accts Central Existing 78 Sat New Accts Central Existing 75 Sat New Accts Central Existing 74 Sat New Accts Westside Existing 73 Sat Teller Westside Existing 71 Sat New Accts North County Existing 70 Sat New Accts Westside Existing 68 Sat New Accts Central New 67 Sat New Accts North County Existing 65 Sat New Accts North County Existing 64 Sat New Accts Central Existing 63 Sat New Accts Central Existing 59 Sat New Accts Central Existing 57 Sat New Accts Central Existing 56 Sat New Accts North County Existing 54 Sat New Accts Westside Existing 53 Sat New Accts Central Existing 51 Sat Teller North County Existing 51 Sat New Accts Central New 51 Sat New Accts North County Existing 49 Sat Teller Westside Existing 47 Sat New Accts Central Existing 47 Sat New Accts Central New 46 Sat Teller North County Existing 42 Sat New Accts Central New 41 Sat Teller Central Existing 38 Sat New Accts Westside Existing 37 Sat New Accts Central New 36 Sat New Accts Westside Existing 35 Sat New Accts Central Existing 34 Sat New Accts Central New 33 Sat New Accts North County Existing 31 Sat New Accts Central New 31 Sat New Accts Westside Existing 31 Sat Teller North County Existing 29 Sat New Accts Central New 29 Sat New Accts Westside Existing 23 Sat Teller Central Existing 21 Sat New Accts Central New 21 Sat

Explanation / Answer

The data is not complete but i search the data and find that amount series is not given.

I get the orginial data and get the result

a)

The 71st percentile on the $ Amount using the percentile function

In excelcommand

PERCENTILE(C2:C351,0.71) = $10868.33

b) The rank of the 71st percentile of the $Amount using the common formula for calculating the rank of the Kth percentile

The rank is 100

c) The 71st percentile of the $Amount using the Rank and Percentile Data Analysis tool in Excel is

$ 11,000

Point Column1 Rank Percent 8 90,000 1 100.00% 88 75,000 2 99.70% 139 65,000 3 99.40% 3 50,000 4 98.80% 27 50,000 4 98.80% 57 45,000 6 98.50% 223 40,599 7 98.20% 92 40,000 8 97.90% 36 35,000 9 97.40% 118 35,000 9 97.40% 319 32,000 11 97.10% 37 30,000 12 96.50% 288 30,000 12 96.50% 340 25,000 14 95.90% 343 25,000 14 95.90% 76 24,000 16 95.70% 164 21,000 17 95.10% 214 21,000 17 95.10% 185 19,000 19 94.80% 63 17,000 20 93.60% 83 17,000 20 93.60% 159 17,000 20 93.60% 337 17,000 20 93.60% 10 16,000 24 92.50% 120 16,000 24 92.50% 156 16,000 24 92.50% 186 16,000 24 92.50% 302 15,984 28 92.20% 6 15,759 29 91.90% 117 15,703 30 91.40% 258 15,703 30 91.40% 11 15,276 32 91.10% 67 15,208 33 89.60% 191 15,208 33 89.60% 264 15,208 33 89.60% 297 15,208 33 89.60% 303 15,208 33 89.60% 24 15,000 38 89.10% 324 15,000 38 89.10% 5 14,644 40 88.20% 75 14,644 40 88.20% 160 14,644 40 88.20% 29 14,548 43 87.30% 106 14,548 43 87.30% 311 14,548 43 87.30% 108 14,000 46 87.10% 122 13,903 47 86.50% 246 13,903 47 86.50% 261 13,900 49 86.20% 20 13,636 50 85.30% 166 13,636 50 85.30% 241 13,636 50 85.30% 33 13,519 53 83.60% 94 13,519 53 83.60% 137 13,519 53 83.60% 215 13,519 53 83.60% 257 13,519 53 83.60% 272 13,519 53 83.60% 54 13,500 59 82.50% 62 13,500 59 82.50% 177 13,500 59 82.50% 224 13,500 59 82.50% 99 13,428 63 82.20% 26 13,000 64 78.70% 39 13,000 64 78.70% 58 13,000 64 78.70% 104 13,000 64 78.70% 136 13,000 64 78.70% 200 13,000 64 78.70% 217 13,000 64 78.70% 234 13,000 64 78.70% 271 13,000 64 78.70% 281 13,000 64 78.70% 284 13,000 64 78.70% 322 13,000 64 78.70% 128 12,505 76 77.30% 203 12,505 76 77.30% 293 12,505 76 77.30% 318 12,505 76 77.30% 338 12,505 76 77.30% 300 12,500 81 77.00% 72 12,455 82 75.60% 199 12,455 82 75.60% 268 12,455 82 75.60% 287 12,455 82 75.60% 346 12,455 82 75.60% 14 12,000 87 71.90% 31 12,000 87 71.90% 51 12,000 87 71.90% 56 12,000 87 71.90% 81 12,000 87 71.90% 91 12,000 87 71.90% 170 12,000 87 71.90% 171 12,000 87 71.90% 172 12,000 87 71.90% 175 12,000 87 71.90% 179 12,000 87 71.90% 251 12,000 87 71.90% 269 12,000 87 71.90% 30 11,000 100 71.00% 103 11,000 100 71.00% 339 11,000 100 71.00% 116 10,373 103 70.40% 220 10,373 103 70.40% 65 10,000 105 69.30% 192 10,000 105 69.30% 270 10,000 105 69.30% 335 10,000 105 69.30% 32 9,095 109 68.10% 138 9,095 109 68.10% 173 9,095 109 68.10% 184 9,095 109 68.10% 125 9,000 113 67.00% 228 9,000 113 67.00% 236 9,000 113 67.00% 274 9,000 113 67.00% 123 8,000 117 65.90% 176 8,000 117 65.90% 187 8,000 117 65.90% 232 8,000 117 65.90% 82 7,342 121 65.30% 290 7,342 121 65.30% 95 7,277 123 65.00% 15 7,000 124 63.30% 155 7,000 124 63.30% 182 7,000 124 63.30% 253 7,000 124 63.30% 320 7,000 124 63.30% 348 7,000 124 63.30% 77 6,762 130 63.00% 202 6,725 131 62.70% 341 6,533 132 62.40% 53 6,500 133 62.10% 38 6,307 134 61.80% 105 6,202 135 61.60% 344 6,200 136 61.30% 28 6,000 137 57.30% 130 6,000 137 57.30% 132 6,000 137 57.30% 144 6,000 137 57.30% 163 6,000 137 57.30% 181 6,000 137 57.30% 183 6,000 137 57.30% 212 6,000 137 57.30% 235 6,000 137 57.30% 240 6,000 137 57.30% 294 6,000 137 57.30% 307 6,000 137 57.30% 316 6,000 137 57.30% 332 6,000 137 57.30% 13 5,879 151 57.00% 193 5,788 152 56.70% 209 5,444 153 56.40% 78 5,345 154 56.10% 296 5,200 155 55.80% 9 5,000 156 50.10% 12 5,000 156 50.10% 17 5,000 156 50.10% 25 5,000 156 50.10% 49 5,000 156 50.10% 66 5,000 156 50.10% 80 5,000 156 50.10% 87 5,000 156 50.10% 112 5,000 156 50.10% 158 5,000 156 50.10% 167 5,000 156 50.10% 178 5,000 156 50.10% 205 5,000 156 50.10% 221 5,000 156 50.10% 233 5,000 156 50.10% 248 5,000 156 50.10% 254 5,000 156 50.10% 326 5,000 156 50.10% 327 5,000 156 50.10% 345 5,000 156 50.10% 263 4,700 176 49.80% 129 4,635 177 49.50% 7 4,623 178 49.20% 321 4,569 179 48.90% 96 4,535 180 48.70% 265 4,527 181 48.40% 333 4,230 182 48.10% 1 4,000 183 37.80% 34 4,000 183 37.80% 35 4,000 183 37.80% 45 4,000 183 37.80% 86 4,000 183 37.80% 90 4,000 183 37.80% 98 4,000 183 37.80% 100 4,000 183 37.80% 109 4,000 183 37.80% 114 4,000 183 37.80% 124 4,000 183 37.80% 134 4,000 183 37.80% 135 4,000 183 37.80% 141 4,000 183 37.80% 146 4,000 183 37.80% 162 4,000 183 37.80% 188 4,000 183 37.80% 210 4,000 183 37.80% 213 4,000 183 37.80% 218 4,000 183 37.80% 219 4,000 183 37.80% 225 4,000 183 37.80% 227 4,000 183 37.80% 230 4,000 183 37.80% 231 4,000 183 37.80% 237 4,000 183 37.80% 245 4,000 183 37.80% 255 4,000 183 37.80% 273 4,000 183 37.80% 277 4,000 183 37.80% 282 4,000 183 37.80% 283 4,000 183 37.80% 308 4,000 183 37.80% 329 4,000 183 37.80% 330 4,000 183 37.80% 336 4,000 183 37.80% 278 3,900 219 37.50% 68 3,807 220 37.20% 42 3,700 221 36.90% 317 3,600 222 36.60% 204 3,500 223 36.30% 127 3,434 224 36.10% 47 3,405 225 35.80% 198 3,400 226 35.20% 342 3,400 226 35.20% 19 3,171 228 34.90% 22 3,075 229 34.60% 23 3,000 230 30.90% 43 3,000 230 30.90% 61 3,000 230 30.90% 85 3,000 230 30.90% 111 3,000 230 30.90% 113 3,000 230 30.90% 145 3,000 230 30.90% 149 3,000 230 30.90% 197 3,000 230 30.90% 207 3,000 230 30.90% 250 3,000 230 30.90% 252 3,000 230 30.90% 280 3,000 230 30.90% 140 2,925 243 30.60% 119 2,900 244 30.30% 189 2,850 245 30.00% 238 2,775 246 29.70% 102 2,749 247 29.50% 262 2,700 248 28.90% 279 2,700 248 28.90% 168 2,667 250 28.60% 249 2,585 251 28.30% 266 2,503 252 28.00% 285 2,421 253 27.70% 306 2,355 254 27.50% 64 2,310 255 27.20% 142 2,100 256 26.90% 21 2,000 257 23.70% 121 2,000 257 23.70% 150 2,000 257 23.70% 201 2,000 257 23.70% 206 2,000 257 23.70% 229 2,000 257 23.70% 298 2,000 257 23.70% 310 2,000 257 23.70% 314 2,000 257 23.70% 315 2,000 257 23.70% 334 2,000 257 23.70% 55 1,946 268 23.40% 153 1,325 269 23.20% 239 1,300 270 22.90% 52 1,000 271 20.30% 60 1,000 271 20.30% 133 1,000 271 20.30% 211 1,000 271 20.30% 292 1,000 271 20.30% 299 1,000 271 20.30% 304 1,000 271 20.30% 312 1,000 271 20.30% 325 1,000 271 20.30% 84 600 280 18.90% 194 600 280 18.90% 260 600 280 18.90% 295 600 280 18.90% 350 600 280 18.90% 74 500 285 15.70% 93 500 285 15.70% 126 500 285 15.70% 169 500 285 15.70% 174 500 285 15.70% 180 500 285 15.70% 190 500 285 15.70% 242 500 285 15.70% 247 500 285 15.70% 259 500 285 15.70% 276 500 285 15.70% 4 400 296 13.70% 79 400 296 13.70% 101 400 296 13.70% 148 400 296 13.70% 157 400 296 13.70% 301 400 296 13.70% 323 400 296 13.70% 115 350 303 13.40% 243 344 304 13.10% 275 338 305 12.80% 2 332 306 12.60% 48 275 307 12.30% 40 250 308 8.50% 41 250 308 8.50% 97 250 308 8.50% 107 250 308 8.50% 110 250 308 8.50% 143 250 308 8.50% 151 250 308 8.50% 161 250 308 8.50% 165 250 308 8.50% 226 250 308 8.50% 256 250 308 8.50% 328 250 308 8.50% 331 250 308 8.50% 44 200 321 6.80% 59 200 321 6.80% 69 200 321 6.80% 195 200 321 6.80% 216 200 321 6.80% 286 200 321 6.80% 16 150 327 4.50% 70 150 327 4.50% 71 150 327 4.50% 147 150 327 4.50% 196 150 327 4.50% 267 150 327 4.50% 289 150 327 4.50% 349 150 327 4.50% 18 100 335 0.00% 46 100 335 0.00% 50 100 335 0.00% 73 100 335 0.00% 89 100 335 0.00% 131 100 335 0.00% 152 100 335 0.00% 154 100 335 0.00% 208 100 335 0.00% 222 100 335 0.00% 244 100 335 0.00% 291 100 335 0.00% 305 100 335 0.00% 309 100 335 0.00% 313 100 335 0.00% 347 100 335 0.00%

Related Questions

Navigate

• Browse (All)
• Browse T
• Subjects

---

---

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