Knopfel-WK3.xlsx - House Sales Sales vs Cost Lot Cost...

This preview shows page 1 - 14 out of 44 pages.

House Sales Selling Price Lot Cost $85,145 $17,030 $112,740 $20,700 $115,350 $18,030 $116,415 $19,600 $133,070 $24,455 $136,530 $25,500 $139,435 $29,155 $139,955 $30,400 $147,905 $24,650 $153,845 $27,500 $155,270 $19,600 $155,870 $24,650 $160,000 $29,500 $165,220 $25,500 $165,350 $25,000 $168,354 $27,316 $168,500 $33,000 $170,000 $25,200 $172,749 $45,025 $175,000 $28,000 $175,470 $28,600 $179,365 $32,200 $181,916 $45,025 $182,237 $45,025 $183,370 $28,000 $184,210 $28,000 $184,460 $22,300 $184,873 $33,400 $185,160 $29,000 $186,000 $35,851 $187,390 $27,000 $188,603 $31,300 $189,120 $35,000 $191,028 $45,000 $196,898 $45,025 $198,202 $45,025 $200,119 $45,000 $200,423 $45,025 $201,700 $40,940 $202,000 $31,160 $203,076 $45,025 $203,950 $33,000 $0 $100,000 $200,000 $300,000 $400,000 $500,000 $ $0 $10,000 $20,000 $30,000 $40,000 $50,000 $60,000 $70,000 $80,000 $90,000 $100,000 Sales vs Cost Selling Price Lot Cost
$204,900 $34,000 $205,821 $39,299 $206,400 $35,851 $207,345 $35,600 $209,400 $43,579 $210,380 $33,856 $211,513 $31,300 $211,797 $34,000 $212,079 $33,400 $214,205 $36,500 $214,900 $31,300 $216,049 $35,600 $219,990 $37,557 $220,257 $31,300 $223,890 $28,000 $224,108 $45,025 $225,900 $28,618 $226,000 $35,600 $230,000 $45,025 $230,440 $33,000 $230,555 $28,000 $233,900 $44,200 $234,971 $29,202 $239,000 $39,169 $239,870 $41,354 $241,195 $41,340 $242,191 $33,434 $242,899 $48,252 $246,648 $41,600 $248,500 $20,000 $249,900 $38,200 $250,005 $33,000 $250,800 $73,400 $252,135 $41,341 $253,055 $41,340 $254,048 $39,680 $255,000 $43,198 $256,235 $48,500 $257,040 $37,631 $260,100 $73,400 $262,740 $44,900 $262,890 $48,500 $265,058 $41,404 $265,500 $35,800 $267,060 $73,400
$267,250 $45,676 $267,640 $73,400 $268,000 $43,344 $268,210 $29,700 $268,500 $41,099 $269,410 $73,400 $270,518 $46,499 $271,105 $45,000 $274,455 $41,000 $274,903 $45,345 $277,720 $44,650 $280,622 $45,130 $280,804 $40,667 $281,487 $57,285 $281,824 $50,448 $283,440 $50,900 $286,758 $57,000 $287,771 $46,300 $289,000 $44,000 $290,000 $48,300 $290,190 $82,250 $294,450 $73,400 $294,990 $57,000 $299,096 $43,784 $301,500 $59,000 $305,000 $49,067 $307,373 $41,292 $307,387 $45,850 $307,663 $44,840 $309,075 $82,250 $310,100 $41,800 $310,372 $60,000 $312,898 $40,768 $318,274 $85,800 $318,523 $50,000 $319,602 $82,250 $322,920 $82,250 $323,716 $34,500 $324,266 $47,891 $324,412 $62,523 $326,570 $51,000 $329,611 $48,611 $330,486 $35,000 $330,710 $49,920 $333,158 $49,123
$335,000 $68,375 $337,374 $70,399 $337,380 $49,150 $338,065 $54,850 $340,000 $40,000 $340,730 $50,850 $342,423 $48,309 $348,744 $53,000 $350,702 $46,386 $352,781 $60,000 $354,065 $48,115 $354,117 $56,219 $355,688 $65,373 $358,162 $44,470 $359,949 $50,591 $366,990 $55,508 $367,600 $50,000 $369,101 $46,773 $371,152 $58,223 $379,000 $72,915 $379,424 $64,902 $379,575 $44,294 $385,000 $75,000 $385,942 $49,123 $387,527 $48,000 $398,651 $65,429 $400,330 $75,510 $404,510 $58,225 $407,076 $48,668 $410,810 $66,500 $417,790 $63,099 $432,426 $57,422 $444,304 $53,938 $446,507 $75,510 $492,820 $84,122 $575,120 $79,790
$600,000 $700,000
Colleges and Universities School Top 10% HS Acceptance Rate Expenditures/Student Amherst 85 22% $ 26,636 Barnard 69 53% $ 17,653 Bates 58 36% $ 17,554 Berkeley 95 37% $ 23,665 Bowdoin 78 24% $ 25,703 55 60 65 70 75 80 85 90 0% 10% 20% 30% 40% 50% 60% Expenditures/Student Top 10% HS Acceptance Rate
95 100
State Unemployment Rates State January 2013 Rate Historical High Historical Low Alabama 6.9 14.4 3.3 Alaska 6.7 11.5 5.9 Arizona 8 11.5 3.6 Arkansas 7.2 10.2 4.1 California 9.8 11 4.7 Colorado 7.3 9.1 2.5 Connecticut 8.1 10 2.1 Delaware 7.2 8.2 2.9 District of Columbia 8.6 11.4 4.8 Florida 7.8 9.7 3.3 Georgia 8.7 8.3 3.4 Hawaii 5.2 10.2 2.2 Idaho 6.3 9.4 2.7 Illinois 9 12.9 4.1 Indiana 8.6 12.8 2.6 Iowa 5 8.5 2.6 Kansas 5.5 7.4 2.9 Kentucky 7.9 12.1 4 Louisiana 5.9 12.9 3.2 Maine 7.3 9 3 Maryland 6.7 8.3 3.3 Massachusetts 6.7 10.9 2.7 Michigan 8.9 16.9 3.2 Minnesota 5.6 9 2.5 Mississippi 9.3 13.7 4.9 Missouri 6.5 10.5 2.6 Montana 5.7 8.7 3.1 Nebraska 3.8 6.8 2.2 Nevada 9.7 10.7 4.1 New Hampshire 5.8 7.7 1.9 New Jersey 9.5 10.6 3.5 New Mexico 6.6 9.9 3.1 New York 8.4 10.5 4 North Carolina 9.5 10.2 3.1 North Dakota 3.3 6.9 2.5 Ohio 7 13.8 3.9 Oklahoma 5.1 9.4 2.7 Oregon 8.4 12.1 4.7 Pennsylvania 8.2 12.9 4 A clustered column c Rhode Island 9.8 9.7 2.9 South Carolina 8.7 11.4 3.1 South Dakota 4.4 5.9 2.4 Tennessee 7.7 12.4 3.8 Texas 6.3 9.3 4.1 Utah 5.4 9.7 2.4 Vermont 4.7 9 2.2 Virginia 5.6 7.8 2.2 Washington 7.5 12.2 4.4 Alab ama Alas ka Ari zon A 0 2 4 6 8 10 12 14 16 18 20 unemployment rate
West Virginia 7.4 18.2 4.3 Wisconsin 7 11.8 2.9 Wyoming 4.9 10.1 1.9
chart is a good way to visually convey this information. The only way it could be better would be to use i zona Arka nsas California Colorado Connectcut Dela ware Dis trict of Columbia Flori da Geor gi a Hawaii Idah o Illi nois Indi ana Iow a Kansas Kentuc ky Louisi ana Maine Maryl and Massachu sets Michigan Mi nnesota Mi ssissippi Mi ssouri Mon tan a Nebr aska Nevada New H am pshire New Jersey New Mexico New Nor State Unemployment Rates January 2013 Rate Historical High Historical Low
e a bar chart so that the names of the states would be more easily readable. o ew Yo rk North Carolin a North D ak ota Ohio Okla homa Oregon Pennsylvania Rhode Island South Carolin a South Dak ota Ten ness ee Texa s Utah Vermo nt Vir gi nia Washington West Vi rginia Wisc onsin Wy oming
Store and Regional Sales Database ID Store No. Sales Region Item No. Item Description 72 6 East 8500 Laptop 71 6 East 8500 Laptop 62 6 East 2005 24" Monitor 53 5 North 3006 Wireless Keyboard 52 5 North 3006 Wireless Keyboard 70 6 East 8500 Laptop 54 5 North 3006 Wireless Keyboard 66 6

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture