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.

1.) What is the rank of the 71st percentile of the $Amount using the common formula (in our text) for calculating the rank of the Kth percentile?

Transaction Date $Amount AcctType OpenedBy Branch Customer Age of Cust DoW 1 9/3 4,000 Savings New Accts Central Existing 91 Mon 2 9/3 332 Checking New Accts Central Existing 89 Mon 3 9/3 50,000 Savings New Accts Central Existing 88 Mon 4 9/3 400 Checking Teller Central Existing 79 Mon 5 9/3 14,644 CD New Accts Westside New 75 Mon 6 9/3 15,759 CD Teller Westside Existing 75 Mon 7 9/3 4,623 Savings New Accts North County Existing 75 Mon 8 9/3 90,000 CD New Accts Central Existing 73 Mon 9 9/3 5,000 CD New Accts North County Existing 68 Mon 10 9/3 16,000 CD New Accts Central New 64 Mon 11 9/3 15,276 CD New Accts North County Existing 61 Mon 12 9/3 5,000 Checking New Accts Central Existing 60 Mon 13 9/3 5,879 Checking New Accts Central Existing 57 Mon 14 9/3 12,000 CD New Accts Westside Existing 55 Mon 15 9/3 7,000 Savings New Accts North County New 46 Mon 16 9/3 150 Checking Teller Central Existing 44 Mon 17 9/3 5,000 Savings New Accts Westside Existing 43 Mon 18 9/3 100 Checking New Accts Central Existing 42 Mon 19 9/3 3,171 Checking New Accts Westside Existing 35 Mon 20 9/3 13,636 CD New Accts North County Existing 27 Mon 21 9/6 2,000 IRA New Accts Westside Existing 93 Thu 22 9/6 3,075 Checking New Accts Westside Existing 88 Thu 23 9/6 3,000 Checking New Accts Central Existing 87 Thu 24 9/6 15,000 CD New Accts Westside New 85 Thu 25 9/6 5,000 Checking New Accts North County Existing 84 Thu 26 9/6 13,000 CD New Accts North County New 81 Thu 27 9/6 50,000 CD New Accts North County New 80 Thu 28 9/6 6,000 Savings New Accts Central Existing 79 Thu 29 9/6 14,548 CD New Accts Central Existing 78 Thu 30 9/6 11,000 CD New Accts Central New 77 Thu 31 9/6 12,000 CD New Accts Westside Existing 71 Thu 32 9/6 9,095 IRA Teller Central Existing 68 Thu 33 9/6 13,519 CD New Accts Central New 64 Thu 34 9/6 4,000 Checking New Accts Central Existing 57 Thu 35 9/6 4,000 Checking New Accts North County Existing 51 Thu 36 9/6 35,000 CD New Accts Central Existing 49 Thu 37 9/6 30,000 Savings New Accts Westside Existing 43 Thu 38 9/6 6,307 Savings Teller North County Existing 41 Thu 39 9/6 13,000 CD New Accts Central Existing 40 Thu 40 9/6 250 Checking New Accts Central Existing 26 Thu 41 9/6 250 Checking New Accts Central Existing 20 Thu 42 9/6 3,700 Savings New Accts North County Existing 20 Thu 43 9/7 3,000 Checking New Accts Central New 102 Fri 44 9/7 200 Checking New Accts Westside Existing 91 Fri 45 9/7 4,000 Checking Teller North County Existing 89 Fri 46 9/7 100 Checking New Accts North County Existing 84 Fri 47 9/7 3,405 IRA New Accts North County Existing 83 Fri 48 9/7 275 Checking Teller North County Existing 83 Fri 49 9/7 5,000 Checking New Accts North County Existing 78 Fri 50 9/7 100 Checking New Accts Central Existing 78 Fri 51 9/7 12,000 Checking New Accts Central Existing 74 Fri 52 9/7 1,000 Checking New Accts Central Existing 67 Fri 53 9/7 6,500 IRA New Accts North County Existing 60 Fri 54 9/7 13,500 CD New Accts North County Existing 53 Fri 55 9/7 1,946 Checking New Accts Central New 47 Fri 56 9/7 12,000 CD Teller Central Existing 47 Fri 57 9/7 45,000 CD Teller Westside Existing 42 Fri 58 9/7 13,000 CD Teller Westside Existing 39 Fri 59 9/7 200 Checking Teller Westside Existing 36 Fri 60 9/7 1,000 Savings Teller North County Existing 34 Fri 61 9/7 3,000 Checking New Accts North County New 30 Fri 62 9/7 13,500 CD New Accts North County Existing 30 Fri 63 9/7 17,000 CD Teller Westside Existing 27 Fri 64 9/7 2,310 Checking New Accts North County New 23 Fri 65 9/8 10,000 IRA Teller North County Existing 91 Sat 66 9/8 5,000 CD New Accts North County Existing 89 Sat 67 9/8 15,208 CD New Accts Central Existing 86 Sat 68 9/8 3,807 Checking New Accts Westside Existing 86 Sat 69 9/8 200 Savings Teller Central Existing 85 Sat 70 9/8 150 Checking New Accts Westside Existing 84 Sat 71 9/8 150 Checking Teller Central Existing 82 Sat 72 9/8 12,455 IRA Teller North County Existing 78 Sat 73 9/8 100 Checking New Accts Central Existing 78 Sat 74 9/8 500 Savings New Accts Westside Existing 75 Sat 75 9/8 14,644 CD New Accts Westside New 66 Sat 76 9/8 24,000 CD New Accts Central Existing 64 Sat 77 9/8 6,762 Savings New Accts Central Existing 53 Sat 78 9/8 5,345 Savings New Accts North County New 53 Sat 79 9/8 400 Checking Teller Central Existing 49 Sat 80 9/8 5,000 Savings New Accts North County Existing 43 Sat 81 9/8 12,000 CD New Accts North County Existing 38 Sat 82 9/8 7,342 Checking New Accts Central Existing 30 Sat 83 9/10 17,000 CD Teller Central Existing 93 Mon 84 9/10 600 Savings New Accts Central Existing 89 Mon 85 9/10 3,000 Checking New Accts Westside Existing 88 Mon 86 9/10 4,000 Savings New Accts Central Existing 88 Mon 87 9/10 5,000 Savings Teller North County Existing 87 Mon 88 9/10 75,000 CD New Accts North County New 87 Mon 89 9/10 100 Checking New Accts Central Existing 86 Mon 90 9/10 4,000 Checking New Accts Westside New 85 Mon 91 9/10 12,000 CD New Accts North County Existing 85 Mon 92 9/10 40,000 CD New Accts North County Existing 84 Mon 93 9/10 500 Checking New Accts Westside Existing 84 Mon 94 9/10 13,519 CD New Accts Central Existing 83 Mon 95 9/10 7,277 IRA New Accts North County Existing 78 Mon 96 9/10 4,535 Checking New Accts North County New 74 Mon 97 9/10 250 Checking New Accts Central Existing 72 Mon 98 9/10 4,000 Checking New Accts North County Existing 69 Mon 99 9/10 13,428 CD New Accts Central Existing 67 Mon 100 9/10 4,000 Checking New Accts Westside Existing 63 Mon 101 9/10 400 Checking New Accts Central Existing 58 Mon 102 9/10 2,749 Checking New Accts Central New 56 Mon 103 9/10 11,000 CD New Accts Central New 56 Mon 104 9/10 13,000 CD New Accts Central Existing 54 Mon 105 9/10 6,202 Savings Teller Central Existing 53 Mon 106 9/10 14,548 CD New Accts Central Existing 53 Mon 107 9/10 250 Checking New Accts North County Existing 48 Mon 108 9/10 14,000 CD Teller North County Existing 46 Mon 109 9/10 4,000 Checking New Accts Central New 46 Mon 110 9/10 250 Savings New Accts North County Existing 44 Mon 111 9/10 3,000 Checking New Accts Central Existing 42 Mon 112 9/10 5,000 Savings New Accts Central New 41 Mon 113 9/10 3,000 Checking New Accts North County Existing 38 Mon 114 9/10 4,000 Checking Teller North County Existing 36 Mon 115 9/10 350 Checking New Accts Westside Existing 36 Mon 116 9/10 10,373 CD New Accts Westside Existing 34 Mon 117 9/10 15,703 CD New Accts Central Existing 32 Mon 118 9/10 35,000 CD New Accts Central Existing 29 Mon 119 9/10 2,900 Savings New Accts North County Existing 27 Mon 120 9/10 16,000 CD New Accts Central New 25 Mon 121 9/10 2,000 IRA New Accts Westside Existing 25 Mon 122 9/10 13,903 CD New Accts Central Existing 24 Mon 123 9/10 8,000 Savings Teller Central Existing 20 Mon 124 9/13 4,000 Savings New Accts North County Existing 91 Thu 125 9/13 9,000 IRA New Accts Central Existing 85 Thu 126 9/13 500 Savings New Accts Westside Existing 83 Thu 127 9/13 3,434 Checking New Accts Central Existing 71 Thu 128 9/13 12,505 CD New Accts Westside New 66 Thu 129 9/13 4,635 Checking New Accts Central Existing 61 Thu 130 9/13 6,000 Checking Teller Westside Existing 55 Thu 131 9/13 100 Checking New Accts Central Existing 49 Thu 132 9/13 6,000 Savings New Accts Central New 40 Thu 133 9/13 1,000 Checking New Accts Central New 34 Thu 134 9/13 4,000 Checking New Accts Central Existing 32 Thu 135 9/13 4,000 Checking New Accts North County Existing 26 Thu 136 9/14 13,000 CD New Accts Central Existing 91 Fri 137 9/14 13,519 CD New Accts Central New 88 Fri 138 9/14 9,095 IRA Teller Central Existing 85 Fri 139 9/14 65,000 Savings New Accts Westside Existing 77 Fri 140 9/14 2,925 Checking New Accts Westside Existing 73 Fri 141 9/14 4,000 Checking New Accts North County Existing 65 Fri 142 9/14 2,100 Savings New Accts North County Existing 55 Fri 143 9/14 250 Checking New Accts Central Existing 55 Fri 144 9/14 6,000 Savings New Accts Central Existing 53 Fri 145 9/14 3,000 Checking New Accts Central Existing 47 Fri 146 9/14 4,000 Checking New Accts Central Existing 26 Fri 147 9/15 150 Checking Teller Central Existing 93 Sat 148 9/15 400 Checking New Accts Central New 86 Sat 149 9/15 3,000 Checking New Accts Central Existing 84 Sat 150 9/15 2,000 CD New Accts North County New 75 Sat 151 9/15 250 Savings Teller North County Existing 75 Sat 152 9/15 100 Checking New Accts Central Existing 75 Sat 153 9/15 1,325 Checking New Accts Central New 69 Sat 154 9/15 100 Checking New Accts Central New 65 Sat 155 9/15 7,000 Savings Teller North County Existing 58 Sat 156 9/15 16,000 CD New Accts North County Existing 34 Sat 157 9/15 400 Checking Teller Central Existing 32 Sat 158 9/15 5,000 CD New Accts Central Existing 23 Sat 159 9/15 17,000 CD Teller Central Existing 20 Sat 160 9/15 14,644 CD New Accts Westside New 19 Sat 161 9/17 250 Checking New Accts Central Existing 91 Mon 162 9/17 4,000 Checking New Accts Central Existing 89 Mon 163 9/17 6,000 Savings New Accts Central Existing 86 Mon 164 9/17 21,000 CD New Accts North County Existing 86 Mon 165 9/17 250 Checking New Accts Central Existing 85 Mon 166 9/17 13,636 CD New Accts North County Existing 84 Mon 167 9/17 5,000 Savings Teller North County Existing 83 Mon 168 9/17 2,667 Checking New Accts Central Existing 71 Mon 169 9/17 500 Savings New Accts Westside Existing 64 Mon 170 9/17 12,000 Checking New Accts Central Existing 64 Mon 171 9/17 12,000 CD New Accts North County Existing 62 Mon 172 9/17 12,000 CD New Accts North County Existing 60 Mon 173 9/17 9,095 IRA Teller Central Existing 58 Mon 174 9/17 500 Savings New Accts Westside Existing 57 Mon 175 9/17 12,000 CD New Accts Westside Existing 56 Mon 176 9/17 8,000 Savings New Accts Central Existing 56 Mon 177 9/17 13,500 CD New Accts North County Existing 54 Mon 178 9/17 5,000 Checking New Accts North County Existing 50 Mon 179 9/17 12,000 CD New Accts Westside Existing 47 Mon 180 9/17 500 Savings New Accts Westside Existing 43 Mon 181 9/17 6,000 Savings New Accts Central Existing 40 Mon 182 9/17 7,000 IRA New Accts North County Existing 38 Mon 183 9/17 6,000 Savings New Accts Central Existing 36 Mon 184 9/17 9,095 IRA Teller Central Existing 32 Mon 185 9/17 19,000 Savings New Accts Central New 30 Mon 186 9/17 16,000 CD New Accts Central Existing 23 Mon 187 9/17 8,000 Savings New Accts Central Existing 22 Mon 188 9/17 4,000 Checking New Accts North County New 20 Mon 189 9/17 2,850 Checking New Accts Westside Existing 20 Mon 190 9/17 500 Checking New Accts Westside Existing 20 Mon 191 9/20 15,208 CD New Accts Central New 88 Thu 192 9/20 10,000 IRA Teller North County Existing 86 Thu 193 9/20 5,788 Savings New Accts Central Existing 80 Thu 194 9/20 600 Savings New Accts Central Existing 75 Thu 195 9/20 200 Savings New Accts Central Existing 74 Thu 196 9/20 150 Checking New Accts Westside Existing 73 Thu 197 9/20 3,000 Checking New Accts Central Existing 72 Thu 198 9/20 3,400 Checking New Accts Westside Existing 60 Thu 199 9/20 12,455 IRA Teller North County Existing 52 Thu 200 9/20 13,000 CD Teller Westside Existing 51 Thu 201 9/20 2,000 CD New Accts North County Existing 34 Thu 202 9/21 6,725 Checking New Accts Central Existing 97 Fri 203 9/21 12,505 CD New Accts Westside Existing 89 Fri 204 9/21 3,500 Savings New Accts North County New 89 Fri 205 9/21 5,000 Savings New Accts Westside Existing 88 Fri 206 9/21 2,000 IRA New Accts Westside Existing 84 Fri 207 9/21 3,000 Checking New Accts Westside Existing 67 Fri 208 9/21 100 Checking New Accts Central Existing 61 Fri 209 9/21 5,444 Checking New Accts Central Existing 53 Fri 210 9/21 4,000 Savings New Accts Central Existing 25 Fri 211 9/21 1,000 Checking New Accts Central Existing 20 Fri 212 9/21 6,000 Checking Teller Westside Existing 19 Fri 213 9/22 4,000 Checking New Accts Central Existing 93 Sat 214 9/22 21,000 Savings New Accts North County Existing 88 Sat 215 9/22 13,519 CD New Accts Central Existing 85 Sat 216 9/22 200 Checking New Accts Central Existing 84 Sat 217 9/22 13,000 CD New Accts Central Existing 65 Sat 218 9/22 4,000 Checking Teller North County Existing 55 Sat 219 9/22 4,000 Checking New Accts North County Existing 34 Sat 220 9/22 10,373 CD New Accts Westside Existing 33 Sat 221 9/22 5,000 CD Teller North County Existing 23 Sat 222 9/22 100 Checking New Accts Westside Existing 18 Sat 223 9/24 40,599 Savings New Accts Central Existing 91 Mon 224 9/24 13,500 CD New Accts North County Existing 91 Mon 225 9/24 4,000 Savings New Accts North County Existing 89 Mon 226 9/24 250 Checking New Accts Central Existing 88 Mon 227 9/24 4,000 Checking New Accts North County Existing 87 Mon 228 9/24 9,000 IRA New Accts Central Existing 84 Mon 229 9/24 2,000 CD Teller Central Existing 82 Mon 230 9/24 4,000 Checking New Accts Westside Existing 79 Mon 231 9/24 4,000 Checking New Accts Central Existing 75 Mon 232 9/24 8,000 Savings Teller Central Existing 75 Mon 233 9/24 5,000 Checking New Accts North County Existing 74 Mon 234 9/24 13,000 CD New Accts Central Existing 69 Mon 235 9/24 6,000 Savings New Accts Central Existing 62 Mon 236 9/24 9,000 CD New Accts North County Existing 61 Mon 237 9/24 4,000 Checking New Accts Central Existing 60 Mon 238 9/24 2,775 Checking New Accts Westside New 59 Mon 239 9/24 1,300 Savings New Accts North County Existing 58 Mon 240 9/24 6,000 Savings New Accts Central Existing 58 Mon 241 9/24 13,636 CD New Accts North County Existing 55 Mon 242 9/24 500 Savings New Accts Westside Existing 50 Mon 243 9/24 344 Checking New Accts Westside Existing 49 Mon 244 9/24 100 Checking New Accts Central Existing 48 Mon 245 9/24 4,000 Checking New Accts North County New 47 Mon 246 9/24 13,903 CD New Accts Central New 42 Mon 247 9/24 500 Savings New Accts Westside Existing 42 Mon 248 9/24 5,000 Savings New Accts Central Existing 40 Mon 249 9/24 2,585 Checking New Accts Central Existing 39 Mon 250 9/24 3,000 Checking New Accts Central Existing 37 Mon 251 9/24 12,000 CD New Accts North County Existing 36 Mon 252 9/24 3,000 Checking New Accts Central Existing 35 Mon 253 9/24 7,000 IRA New Accts North County New 33 Mon 254 9/24 5,000 Savings New Accts North County New 26 Mon 255 9/24 4,000 Checking New Accts Central New 26 Mon 256 9/24 250 Checking New Accts Central Existing 25 Mon 257 9/24 13,519 CD New Accts Central Existing 23 Mon 258 9/24 15,703 CD New Accts Central Existing 22 Mon 259 9/24 500 Savings New Accts Westside New 21 Mon 260 9/27 600 Savings New Accts Central Existing 86 Thu 261 9/27 13,900 Savings New Accts Central Existing 84 Thu 262 9/27 2,700 Checking New Accts Westside Existing 79 Thu 263 9/27 4,700 Savings New Accts Central Existing 70 Thu 264 9/27 15,208 CD New Accts Central Existing 68 Thu 265 9/27 4,527 Checking New Accts Central Existing 56 Thu 266 9/27 2,503 Checking New Accts Central Existing 47 Thu 267 9/27 150 Checking New Accts Westside Existing 41 Thu 268 9/27 12,455 IRA Teller North County Existing 35 Thu 269 9/27 12,000 CD New Accts North County Existing 35 Thu 270 9/27 10,000 IRA Teller North County Existing 23 Thu 271 9/27 13,000 CD Teller Westside Existing 19 Thu 272 9/28 13,519 CD New Accts Central Existing 93 Fri 273 9/28 4,000 Savings New Accts North County Existing 93 Fri 274 9/28 9,000 IRA New Accts Central Existing 88 Fri 275 9/28 338 Checking New Accts Westside New 86 Fri 276 9/28 500 Savings New Accts North County Existing 86 Fri 277 9/28 4,000 Checking New Accts Central New 80 Fri 278 9/28 3,900 Checking New Accts Central Existing 67 Fri 279 9/28 2,700 Checking New Accts Westside Existing 60 Fri 280 9/28 3,000 Checking New Accts Central Existing 58 Fri 281 9/28 13,000 CD New Accts Central Existing 57 Fri 282 9/28 4,000 Checking New Accts North County Existing 45 Fri 283 9/28 4,000 Checking New Accts Central Existing 32 Fri 284 9/29 13,000 CD Teller Westside Existing 91 Sat 285 9/29 2,421 Checking New Accts Central New 91 Sat 286 9/29 200 Savings New Accts Central Existing 91 Sat 287 9/29 12,455 CD Teller North County Existing 88 Sat 288 9/29 30,000 Savings New Accts Central Existing 84 Sat 289 9/29 150 Checking New Accts Westside Existing 71 Sat 290 9/29 7,342 Checking New Accts Central New 58 Sat 291 9/29 100 Checking New Accts Central Existing 57 Sat 292 9/29 1,000 CD New Accts North County Existing 52 Sat 293 9/29 12,505 CD New Accts Westside Existing 42 Sat 294 9/29 6,000 Checking Teller Westside Existing 42 Sat 295 9/29 600 Savings New Accts Central Existing 40 Sat 296 9/29 5,200 Checking New Accts Westside Existing 39 Sat 297 9/29 15,208 CD New Accts Central Existing 38 Sat 298 9/29 2,000 IRA Teller North County New 32 Sat 299 9/29 1,000 Checking New Accts Central Existing 30 Sat 300 9/29 12,500 CD New Accts North County New 18 Sat 301 9/29 400 Checking Teller Central Existing 93 Sat 302 9/29 15,984 Savings New Accts North County New 93 Sat 303 9/29 15,208 CD New Accts Central Existing 93 Sat 304 9/29 1,000 Checking New Accts Central Existing 91 Sat 305 9/29 100 Checking New Accts Central Existing 91 Sat 306 9/29 2,355 Checking New Accts Westside Existing 88 Sat 307 9/29 6,000 Checking New Accts Central New 88 Sat 308 9/29 4,000 Savings New Accts Central New 87 Sat 309 9/29 100 Checking New Accts Central Existing 84 Sat 310 9/29 2,000 IRA New Accts Westside Existing 83 Sat 311 9/29 14,548 CD New Accts Central Existing 80 Sat 312 9/29 1,000 Checking New Accts Central Existing 78 Sat 313 9/29 100 Checking New Accts Central Existing 75 Sat 314 9/29 2,000 Checking New Accts Central Existing 74 Sat 315 9/29 2,000 IRA New Accts Westside Existing 73 Sat 316 9/29 6,000 Checking Teller Westside Existing 71 Sat 317 9/29 3,600 Savings New Accts North County Existing 70 Sat 318 9/29 12,505 CD New Accts Westside Existing 68 Sat 319 9/29 32,000 Savings New Accts Central New 67 Sat 320 9/29 7,000 Checking New Accts North County Existing 65 Sat 321 9/29 4,569 IRA New Accts North County Existing 64 Sat 322 9/29 13,000 CD New Accts Central Existing 63 Sat 323 9/29 400 Checking New Accts Central Existing 59 Sat 324 9/29 15,000 CD New Accts Central Existing 57 Sat 325 9/29 1,000 Checking New Accts Central Existing 56 Sat 326 9/29 5,000 CD New Accts North County Existing 54 Sat 327 9/29 5,000 Savings New Accts Westside Existing 53 Sat 328 9/29 250 Checking New Accts Central Existing 51 Sat 329 9/29 4,000 Checking Teller North County Existing 51 Sat 330 9/29 4,000 Checking New Accts Central New 51 Sat 331 9/29 250 Savings New Accts North County Existing 49 Sat 332 9/29 6,000 Checking Teller Westside Existing 47 Sat 333 9/29 4,230 Savings New Accts Central Existing 47 Sat 334 9/29 2,000 CD New Accts Central New 46 Sat 335 9/29 10,000 IRA Teller North County Existing 42 Sat 336 9/29 4,000 Savings New Accts Central New 41 Sat 337 9/29 17,000 CD Teller Central Existing 38 Sat 338 9/29 12,505 CD New Accts Westside Existing 37 Sat 339 9/29 11,000 CD New Accts Central New 36 Sat 340 9/29 25,000 CD New Accts Westside Existing 35 Sat 341 9/29 6,533 Checking New Accts Central Existing 34 Sat 342 9/29 3,400 Checking New Accts Central New 33 Sat 343 9/29 25,000 Savings New Accts North County Existing 31 Sat 344 9/29 6,200 Checking New Accts Central New 31 Sat 345 9/29 5,000 Savings New Accts Westside Existing 31 Sat 346 9/29 12,455 IRA Teller North County Existing 29 Sat 347 9/29 100 Checking New Accts Central New 29 Sat 348 9/29 7,000 Checking New Accts Westside Existing 23 Sat 349 9/29 150 Checking Teller Central Existing 21 Sat 350 9/29 600 Savings New Accts Central New 21 Sat

Explanation / Answer

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

$ 11,000

=PERCENTILE.EXC(C2:C351,0.71) in any blank space to get the required percentile

note that the data were in C2:C351

Please rate my solution

Related Questions

Navigate

• Browse (All)
• Browse T
• Subjects

---

---

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