Excel - Data Analysis - DUE TONIGHT, IN 6 HOURS

profilestudent1
copy_of_unemployment.xlsx
Home>Computer Science homework help>Excel - Data Analysis - DUE TONIGHT, IN 6 HOURS

Sheet1

HOUSEHOLD DATA Source: U.S. Bureau of Labor Statistics
ANNUAL AVERAGES 
Unemployed persons by marital status, race, Hispanic or Latino ethnicity, age, and sex
Marital status, race, Hispanic Men Women
or Latino ethnicity, and age Unemployed [thousands] Unemployment rates [%] Unemployed [thousands] Unemployment rates [%]
2003 2004 2005 2006 2007 2008 2009 2010 2011 2012 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012
Total, 16 years and over 4,906 4,456 4,059 3,753 3,882 5,033 8,453 8,626 7,684 6,771 6.3 5.6 5.1 4.6 4.7 6.1 10.3 10.5 9.4 8.2 3,868 3,694 3,531 3,247 3,196 3,891 5,811 6,199 6,063 5,734 5.7 5.4 5.1 4.6 4.5 5.4 8.1 8.6 8.5 7.9
Married, spouse present 1,751 1,466 1,287 1,142 1,206 1,590 3,115 3,138 2,671 2,274 3.8 3.1 2.8 2.4 2.5 3.4 6.6 6.8 5.8 4.9 1,352 1,244 1,168 1,042 1,049 1,325 2,057 2,160 2,031 1,915 3.7 3.5 3.3 2.9 2.8 3.6 5.5 5.9 5.6 5.3
Widowed, divorced, or separated 699 608 563 545 544 739 1,326 1,352 1,186 1,005 7.3 6.3 5.6 5.2 5.3 7.1 12.8 12.8 11.1 9.4 842 828 768 709 724 849 1,330 1,397 1,420 1,286 6.1 5.9 5.4 4.9 5 5.9 9.2 9.6 9.7 8.7
Never married 2,457 2,381 2,209 2,067 2,132 2,705 4,011 4,135 3,827 3,492 11 10.5 9.5 8.6 8.8 11 16.3 16.5 15.1 13.7 1,674 1,621 1,595 1,496 1,422 1,717 2,424 2,642 2,612 2,533 9.1 8.7 8.3 7.7 7.2 8.5 12 12.8 12.5 11.8
White, 16 years and over 3,643 3,282 2,931 2,730 2,869 3,727 6,421 6,476 5,631 4,931 5.6 5 4.4 4 4.2 5.5 9.4 9.6 8.3 7.4 2,668 2,565 2,419 2,271 2,274 2,782 4,227 4,440 4,257 3,985 4.8 4.7 4.4 4 4 4.9 7.3 7.7 7.5 7
Married, spouse present 1,379 1,161 1,011 896 965 1,247 2,498 2,490 2,081 1,764 3.5 2.9 2.5 2.2 2.4 3.1 6.2 6.3 5.3 4.6 1,065 996 922 839 830 1,089 1,694 1,748 1,630 1,539 3.5 3.3 3 2.7 2.6 3.5 5.4 5.6 5.3 5.1
Widowed, divorced, or separated 541 466 415 407 421 560 1,058 1,056 903 767 6.9 5.9 5 4.7 4.9 6.5 12.4 12.2 10.3 8.8 602 600 548 523 547 624 993 1,059 1,060 947 5.6 5.5 4.9 4.7 4.9 5.6 8.8 9.3 9.2 8.3
Never married 1,723 1,655 1,505 1,428 1,483 1,920 2,864 2,929 2,648 2,399 9.7 9.1 8.2 7.5 7.8 9.9 14.8 15 13.4 12.2 1,001 969 949 909 897 1,070 1,540 1,632 1,567 1,499 7.4 7.1 6.8 6.4 6.3 7.3 10.5 11 10.5 9.9
Black or African American, 16 years and over 891 860 844 774 752 949 1,448 1,550 1,502 1,292 11.6 11.1 11 9.5 9.1 11.4 17.5 18.4 17.8 15 895 868 856 775 693 839 1,159 1,302 1,329 1,252 10.2 9.8 9.5 8.4 7.5 8.9 12.4 13.8 14.1 12.8
Married, spouse present 208 200 177 166 156 215 367 408 385 303 5.9 5.6 5.1 4.7 4.3 5.9 10.3 11.6 11.1 8.4 155 149 144 121 123 134 193 226 218 200 5.5 5.3 5.2 4.4 4.3 4.6 6.6 7.9 7.8 6.8
Widowed, divorced, or separated 118 104 119 105 92 135 205 239 217 177 9.8 8.9 9.5 8.3 7.5 10.6 16.4 17.9 16 13.3 180 179 166 155 135 178 257 246 265 252 7.8 7.8 7.3 6.4 5.7 7.7 10.9 10.7 11.8 10.9
Never married 566 556 548 502 504 599 876 903 899 812 19 18.2 16.9 15.2 15 17.5 25.3 25.5 24.8 22.1 561 540 546 499 435 527 709 830 846 800 15.2 14.4 13.9 12.5 10.8 12.6 17.3 19.3 19.3 17.5
Asian, 16 years and over 204 153 141 110 119 160 306 305 269 249 6.2 4.5 4 3 3.1 4.1 7.9 7.8 6.8 5.8 162 124 118 95 110 125 216 238 250 234 5.7 4.3 3.9 3.1 3.4 3.7 6.6 7.1 7.3 6.1
Married, spouse present 111 64 61 49 54 78 167 165 135 122 5.3 2.9 2.7 2.2 2.2 3.1 6.6 6.5 5.2 4.4 90 62 62 55 61 64 116 124 130 111 5.2 3.4 3.3 2.9 3.1 3.1 5.6 6.1 6.2 4.8
Widowed, divorced, or separated 13 14 11 11 9 17 26 20 20 25 5.4 5.8 3.6 3.5 3 5.4 8.2 6.6 6.4 7.2 28 24 23 12 12 21 30 40 42 37 6.8 6.3 5.5 2.7 2.7 4.4 6.2 8.7 9 6.3
Never married 80 75 68 49 56 65 112 120 113 102 8.5 7.8 7.2 4.9 5.2 6.2 11.2 11.5 10.9 8.5 44 39 32 29 37 39 70 73 78 86 6.2 5.6 4.5 3.8 4.4 5.2 9.4 8.6 9.2 8.9
Hispanic or Latino ethnicity, 16 years and over 809 755 647 601 695 1,007 1,670 1,711 1,527 1,383 7.2 6.5 5.4 4.8 5.3 7.6 12.5 12.7 11.2 9.9 631 587 544 480 525 672 1,036 1,132 1,102 1,130 8.4 7.6 6.9 5.9 6.1 7.7 11.5 12.3 11.8 10.9
Married, spouse present 311 275 231 201 247 373 688 683 606 498 5.1 4.4 3.6 3 3.5 5.2 9.5 9.6 8.6 6.9 267 228 202 177 191 261 410 422 421 396 7.2 6.2 5.4 4.5 4.7 6.3 9.8 10 10 8.6
Widowed, divorced, or separated 105 85 69 73 85 125 223 213 175 166 7.4 5.8 4.5 4.2 5.1 7.4 13.3 12.3 10.5 9.3 127 130 103 97 110 126 218 239 217 243 8.2 7.9 6.2 5.5 6 6.9 11.1 11.8 10.7 11
Never married 394 394 347 327 363 508 759 815 745 720 10.5 10.3 8.7 7.8 8.3 11.5 17.3 17.4 15.3 14.2 237 229 239 206 224 284 408 471 464 491 10.5 9.6 9.8 8.2 8.3 10.1 14 15.7 15.1 13.8
Total, 25 years and over 3,368 2,980 2,617 2,426 2,538 3,377 6,226 6,365 5,623 4,821 5 4.4 3.8 3.5 3.6 4.8 8.8 8.9 7.9 6.8 2,660 2,531 2,453 2,221 2,198 2,717 4,279 4,603 4,490 4,234 4.6 4.4 4.2 3.7 3.6 4.4 6.9 7.4 7.3 6.8
Married, spouse present 1,676 1,399 1,232 1,088 1,152 1,519 3,012 3,028 2,590 2,207 3.7 3.1 2.7 2.4 2.5 3.3 6.5 6.6 5.7 4.9 1,233 1,139 1,071 955 959 1,227 1,933 2,050 1,910 1,815 3.6 3.3 3.1 2.7 2.7 3.4 5.3 5.7 5.4 5.1
Widowed, divorced, or separated 675 584 538 520 515 708 1,262 1,305 1,141 961 7.3 6.2 5.5 5.1 5.1 7 12.5 12.6 10.9 9.2 792 781 730 667 683 800 1,263 1,334 1,353 1,229 5.9 5.7 5.3 4.8 4.9 5.7 8.9 9.4 9.5 8.6
Never married 1,017 997 848 819 871 1,150 1,952 2,032 1,892 1,654 8.3 8 6.6 6.1 6.3 8 13.3 13.4 12.3 10.6 634 611 651 599 556 691 1,083 1,219 1,227 1,189 6.7 6.3 6.4 5.7 5.2 6.2 9.5 10.2 10 9.4
White, 25 years and over 2,536 2,225 1,929 1,798 1,907 2,511 4,777 4,833 4,137 3,555 4.5 3.9 3.4 3.1 3.3 4.3 8.1 8.2 7.1 6.1 1,853 1,773 1,699 1,578 1,579 1,964 3,157 3,341 3,181 3,003 4 3.8 3.6 3.3 3.3 4 6.4 6.8 6.5 6.1
Married, spouse present 1,315 1,108 966 854 919 1,191 2,413 2,407 2,013 1,710 3.4 2.8 2.5 2.2 2.3 3 6.1 6.2 5.3 4.5 969 911 845 765 756 1,006 1,589 1,657 1,528 1,459 3.3 3.1 2.9 2.6 2.5 3.3 5.2 5.5 5.1 4.9
Widowed, divorced, or separated 522 447 395 389 401 537 1,007 1,021 871 737 6.8 5.7 4.9 4.6 4.8 6.5 12.1 12.1 10.2 8.6 564 563 519 494 516 586 947 1,006 1,009 904 5.4 5.3 4.8 4.5 4.7 5.4 8.6 9.1 9 8.2
Never married 698 670 567 555 587 783 1,358 1,404 1,253 1,107 7.4 7 5.7 5.3 5.5 7.1 12 12 10.6 9.4 321 299 335 320 307 373 621 677 645 640 5 4.6 4.9 4.5 4.3 4.9 8 8.4 7.8 7.7
Black or African American, 25 years and over 568 545 507 473 457 621 1,022 1,102 1,082 883 8.8 8.4 7.6 7 6.6 8.9 14.7 15.5 15.2 12.3 589 589 568 505 453 566 809 920 951 878 7.9 7.9 7.5 6.5 5.8 7.1 10.1 11.5 11.9 10.6
Married, spouse present 203 191 170 156 149 203 358 389 378 292 5.9 5.5 5 4.5 4.1 5.7 10.2 11.2 11.1 8.3 143 141 133 113 113 127 182 215 207 188 5.3 5.2 4.9 4.2 4.1 4.5 6.5 7.8 7.6 6.6
Widowed, divorced, or separated 114 101 113 102 85 128 197 228 208 167 9.7 8.8 9.2 8.2 7.3 10.3 16.2 17.5 15.7 13 171 172 160 145 129 168 239 239 254 242 7.6 7.7 7.2 6.1 5.5 7.5 10.4 10.6 11.5 10.7
Never married 251 253 223 214 222 289 467 485 496 424 13.9 13.5 11.1 10.6 10.5 13.4 20.8 20.9 20.9 17.9 275 276 275 247 211 271 388 466 490 448 11.2 11.1 10.4 9.2 7.7 9.3 13.6 15.6 15.9 14.2
Asian, 25 years and over 157 117 102 80 92 128 253 249 217 198 5.4 3.9 3.3 2.4 2.7 3.7 7.2 7 6 5 131 93 102 75 87 101 176 197 209 187 5.2 3.7 3.8 2.7 3 3.3 5.9 6.5 6.8 5.4
Married, spouse present 109 63 61 48 53 78 163 162 132 121 5.3 2.9 2.7 2.1 2.2 3.1 6.5 6.4 5.1 4.4 85 55 60 53 59 61 113 120 127 108 5 3.1 3.3 2.8 3 2.9 5.6 6 6.1 4.7
Widowed, divorced, or separated 13 13 11 11 9 16 26 19 19 24 5.4 5.7 3.6 3.4 2.8 5.4 8.1 6.5 6.2 7 28 21 23 10 12 21 29 39 41 35 6.9 5.9 5.5 2.3 2.7 4.4 6.2 8.6 9 6.1
Never married 35 41 30 21 30 34 65 67 65 53 5.8 6.6 5 3.1 4 4.7 9.2 9.2 9 6.4 18 17 19 13 17 19 34 38 41 44 4.3 4.2 4.5 2.7 3.1 4 6.7 6.6 7.3 6.9
Hispanic or Latino ethnicity, 25 years and over 536 477 401 387 455 672 1,218 1,226 1,068 941 5.9 5.1 4.1 3.8 4.2 6.1 10.9 10.8 9.5 8.1 439 408 372 330 355 448 737 816 788 805 7.2 6.6 5.8 4.9 5.1 6.2 9.9 10.7 10.2 9.5
Married, spouse present 284 253 214 189 234 345 655 648 582 476 4.9 4.2 3.5 3 3.5 5 9.4 9.5 8.6 6.9 231 202 174 154 166 234 374 390 386 367 6.8 5.9 5 4.2 4.3 6 9.5 9.8 9.6 8.4
Widowed, divorced, or separated 96 75 63 67 77 117 201 201 163 153 7.2 5.5 4.4 4.1 4.9 7.3 12.7 12.1 10.2 8.9 118 121 98 91 100 118 201 222 203 222 7.9 7.8 6.1 5.3 5.7 6.8 10.7 11.4 10.5 10.5
Never married 156 149 124 131 144 210 362 377 324 312 7.7 7.4 5.7 5.7 5.8 8.1 13.8 13.3 11.4 10.6 90 84 99 85 89 96 161 204 200 216 7.7 6.8 7.7 6.4 6.1 6.1 9.9 12 11.4 10.8
NOTE: Estimates for the above race groups (white, black or African American, and Asian) do not sum to totals because data are not presented for all races. Persons whose ethnicity is identified as Hispanic or Latino may be of any race.