Business Statistics
Title Page
| This spreadsheet supports STUDENT analysis of the case “Nils Baker” (UVA-QA-0793). | |
| This spreadsheet was prepared by Anton Ovchinnikov, Assistant Professor of Business Administration, Phillip E. Pfeifer, Richard S. Reynolds Professor of Business Administration, and Nathan Call (MBA ’08). Names and data have been disguised. Copyright © 2012 by the University of Virginia Darden School Foundation, Charlottesville, VA. All rights reserved. For customer service inquiries, send an e-mail [email protected]. No part of this publication may be reproduced, stored in a retrieval system, posted to the Internet, or transmitted in any form or by any means—electronic, mechanical, photocopying, recording, or otherwise—without the permission of the Darden School Foundation. | |
| Aug. 7, 2012 |
Nils Baker data
| ID | Total Households in Area | Households with Account | Inside/Outside Footprint |
| 1 | 1,772,960 | 17,563 | Outside |
| 2 | 1,345,209 | 14,547 | Outside |
| 3 | 960,434 | 10,847 | Outside |
| 4 | 928,274 | 18,133 | Inside |
| 5 | 893,995 | 5,291 | Outside |
| 6 | 812,137 | 6,297 | Outside |
| 7 | 748,942 | 9,195 | Outside |
| 8 | 722,804 | 8,547 | Outside |
| 9 | 603,903 | 3,725 | Outside |
| 10 | 595,213 | 3,218 | Outside |
| 11 | 562,390 | 7,621 | Outside |
| 12 | 542,007 | 11,225 | Outside |
| 13 | 489,865 | 5,735 | Outside |
| 14 | 440,767 | 5,703 | Outside |
| 15 | 339,224 | 3,474 | Outside |
| 16 | 332,315 | 5,450 | Outside |
| 17 | 325,698 | 4,777 | Outside |
| 18 | 287,628 | 1,998 | Outside |
| 19 | 275,046 | 2,937 | Outside |
| 20 | 254,036 | 4,790 | Outside |
| 21 | 245,942 | 2,172 | Outside |
| 22 | 227,997 | 8,092 | Inside |
| 23 | 217,511 | 1,761 | Outside |
| 24 | 202,815 | 2,098 | Inside |
| 25 | 176,018 | 2,163 | Outside |
| 26 | 170,380 | 1,726 | Outside |
| 27 | 170,222 | 1,273 | Outside |
| 28 | 158,496 | 2,090 | Inside |
| 29 | 158,489 | 1,066 | Outside |
| 30 | 154,349 | 1,850 | Inside |
| 31 | 151,797 | 2,283 | Outside |
| 32 | 146,332 | 5,870 | Outside |
| 33 | 146,119 | 1,921 | Outside |
| 34 | 142,345 | 3,106 | Outside |
| 35 | 135,681 | 1,376 | Outside |
| 36 | 133,114 | 1,196 | Outside |
| 37 | 125,420 | 879 | Outside |
| 38 | 124,506 | 1,178 | Outside |
| 39 | 124,379 | 2,517 | Inside |
| 40 | 116,390 | 2,938 | Inside |
| 41 | 105,192 | 642 | Inside |
| 42 | 100,405 | 2,896 | Inside |
| 43 | 100,089 | 868 | Outside |
| 44 | 96,897 | 1,866 | Inside |
| 45 | 89,566 | 2,457 | Outside |
| 46 | 81,025 | 1,013 | Inside |
| 47 | 77,940 | 1,238 | Outside |
| 48 | 76,094 | 1,183 | Outside |
| 49 | 69,325 | 702 | Inside |
| 50 | 67,422 | 362 | Outside |
| 51 | 63,131 | 486 | Outside |
| 52 | 55,466 | 360 | Outside |
| 53 | 52,500 | 462 | Inside |
| 54 | 52,194 | 668 | Inside |
| 55 | 51,251 | 356 | Outside |
| 56 | 49,698 | 510 | Inside |
| 57 | 49,410 | 804 | Inside |
| 58 | 48,064 | 769 | Inside |
| 59 | 47,816 | 467 | Outside |
| 60 | 47,332 | 314 | Outside |
| 61 | 44,833 | 545 | Outside |
| 62 | 44,805 | 280 | Outside |
| 63 | 44,391 | 282 | Outside |
| 64 | 43,791 | 295 | Outside |
| 65 | 43,661 | 275 | Inside |
| 66 | 43,040 | 817 | Inside |
| 67 | 40,755 | 435 | Inside |
| 68 | 40,587 | 330 | Inside |
| 69 | 40,531 | 333 | Inside |
| 70 | 39,960 | 277 | Inside |
| 71 | 39,958 | 411 | Inside |
| 72 | 39,692 | 472 | Inside |
| 73 | 38,144 | 350 | Inside |
| 74 | 37,553 | 376 | Inside |
| 75 | 37,458 | 198 | Outside |
| 76 | 36,157 | 365 | Inside |
| 77 | 36,149 | 1,044 | Inside |
| 78 | 36,008 | 340 | Outside |
| 79 | 35,222 | 252 | Inside |
| 80 | 34,366 | 378 | Inside |
| 81 | 33,678 | 669 | Inside |
| 82 | 33,240 | 658 | Inside |
| 83 | 32,453 | 497 | Inside |
| 84 | 32,420 | 383 | Outside |
| 85 | 31,943 | 398 | Inside |
| 86 | 30,731 | 344 | Inside |
| 87 | 30,560 | 482 | Inside |
| 88 | 29,560 | 198 | Inside |
| 89 | 29,077 | 842 | Inside |
| 90 | 29,034 | 177 | Inside |
| 91 | 28,341 | 158 | Outside |
| 92 | 27,735 | 495 | Inside |
| 93 | 27,012 | 255 | Inside |
| 94 | 26,547 | 439 | Inside |
| 95 | 26,384 | 146 | Outside |
| 96 | 26,220 | 466 | Inside |
| 97 | 25,748 | 585 | Outside |
| 98 | 23,764 | 791 | Outside |
| 99 | 23,522 | 255 | Inside |
| 100 | 23,435 | 171 | Outside |
| 101 | 23,217 | 297 | Inside |
| 102 | 22,696 | 202 | Inside |
| 103 | 22,018 | 441 | Outside |
| 104 | 21,122 | 112 | Outside |
| 105 | 21,025 | 159 | Outside |
| 106 | 20,900 | 149 | Outside |
| 107 | 20,880 | 156 | Outside |
| 108 | 19,259 | 285 | Outside |
| 109 | 17,121 | 482 | Outside |
| 110 | 16,200 | 105 | Inside |
| 111 | 15,699 | 336 | Outside |
| 112 | 15,341 | 219 | Outside |
| 113 | 13,002 | 246 | Inside |
| 114 | 10,731 | 1,466 | Inside |
| 115 | 9,513 | 137 | Outside |
| 116 | 9,025 | 338 | Inside |
| 117 | 8,843 | 42 | Inside |
| 118 | 8,480 | 284 | Outside |
| 119 | 5,019 | 87 | Outside |
| 120 | 1,799 | 13 | Inside |
| Data source: Company documents. |