Wk3 Homework.xlsx - House Sales Selling Price Lot Cost...

This preview shows page 1 - 21 out of 55 pages.

House Sales Selling Price Lot Cost To produce Chart $85,145 $17,030 Select columns $112,740 $20,700 Go to Insert above $115,350 $18,030 Select Scatter Chart $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,0 $0 $10,000 $20,000 $30,000 $40,000 $50,000 $60,000 $70,000 $80,000 $90,000 $100,000 House Sales Selling Pr Lot Cost ($10K)
$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
000 $400,000 $500,000 $600,000 $700,000 s rice ($100K)
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 To produce Chart Select columns Go to Insert above Select Bubble Chart 55 60 65 70 75 80 85 90 95 100 0% 10% 20% 30% 40% 50% 60% Colleges and Universities Colleges and Universities Top 10% HS Acceptance Rate (%)
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 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 West Virginia 7.4 18.2 4.3 Wisconsin 7 11.8 2.9 Wyoming 4.9 10.1 1.9
Yes, a line chart is more suited to represent the relationships between this data. The reason is that Bar Charts w chart can become quite busy and hard to focus on the message it is trying to present. A line chart will display the relationships between the multiple categories. That is why the New York Stock Exchange displays the changes in charts, you will notice that the line chart is half the length of the Bar Chart while still having the X-Axis Labels rep 0 2 4 6 8 10 12 14 16 18 20 2 4 6 8 10 12 14 16 18 20 USA UNEMPLOYM
0 January 2013 Rate Histor
ENT RATES h Historical Low
Store and Regional Sales Database ID Store No. Sales Region Item No. Item Description Unit Price Units Sold 72 6 East 8500 Laptop $849.95 99 71 6 East 8500 Laptop $849.95 88 62 6 East 2005 24" Monitor $229.00 85 53 5 North 3006 Wireless Keyboard $19.95 82 52 5 North 3006 Wireless Keyboard $19.95 80 70 6 East 8500 Laptop $849.95 78 54 5 North 3006 Wireless Keyboard $19.95 75 66 6 East 3006 Wireless Keyboard $19.95 69 55 5 North 6050 PC Mouse $8.95 65 65 6 East 3006

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture