Case Study and Lab work

Shrikaa
C03_04.xlsx
Home>Computer Science homework help>Case Study and Lab work

Source

Bureau of Labor Statistics at https://www.bls.gov/cps/tables.htm#nempstat_m U.S. Customs and Border Protection at https://www.bls.gov/cps/tables.htm#nempstat_m

Yearly Data

Year SW Border Apprehensions Unemployment Rate
1981 749808 7.6
1982 745820 9.7
1983 1033974 9.6
1984 1058276 7.5
1985 1183351 7.2
1986 1615844 7.0
1987 1122067 6.2
1988 942561 5.5
1989 852506 5.3
1990 1049321 5.6
1991 1077876 6.8
1992 1145574 7.5
1993 1212886 6.9
1994 979101 6.1
1995 1271390 5.6
1996 1507020 5.4
1997 1368707 4.9
1998 1516680 4.5
1999 1537000 4.2
2000 1643679 4.0
2001 1235718 4.7
2002 929809 5.8
2003 905065 6.0
2004 1139282 5.5
2005 1171396 5.1
2006 1071972 4.6
2007 858638 4.6
2008 705005 5.8
2009 540865 9.3
2010 447731 9.6
2011 327577 8.9
2012 356873 8.1
2013 414397 7.4
2014 479371 6.2
2015 331333 5.3
2016 408870 4.9
2017 303916 4.4

Monthly Data

Month SW Border Apprehensions Unemployment Rate
Chris Albright: Seasonally adjusted
Jan-2000 185979 4.0
Feb-2000 211328 4.1
Mar-2000 220063 4.0
Apr-2000 180050 3.8
May-2000 166296 4.0
Jun-2000 115093 4.0
Jul-2000 113956 4.0
Aug-2000 114312 4.1
Sep-2000 97744 3.9
Oct-2000 82632 3.9
Nov-2000 67709 3.9
Dec-2000 55081 3.9
Jan-2001 125090 4.2
Feb-2001 152229 4.2
Mar-2001 170580 4.3
Apr-2001 142813 4.4
May-2001 122927 4.3
Jun-2001 89131 4.5
Jul-2001 83602 4.6
Aug-2001 84648 4.9
Sep-2001 59276 5.0
Oct-2001 37812 5.3
Nov-2001 32506 5.5
Dec-2001 31501 5.7
Jan-2002 79793 5.7
Feb-2002 95724 5.7
Mar-2002 126992 5.7
Apr-2002 121921 5.9
May-2002 97424 5.8
Jun-2002 78655 5.8
Jul-2002 76661 5.8
Aug-2002 82557 5.7
Sep-2002 68263 5.7
Oct-2002 61792 5.7
Nov-2002 47731 5.9
Dec-2002 37824 6.0
Jan-2003 86925 5.8
Feb-2003 96869 5.9
Mar-2003 98399 5.9
Apr-2003 75359 6.0
May-2003 88690 6.1
Jun-2003 75530 6.3
Jul-2003 79284 6.2
Aug-2003 84486 6.1
Sep-2003 72176 6.1
Oct-2003 65391 6.0
Nov-2003 57894 5.8
Dec-2003 43614 5.7
Jan-2004 92521 5.7
Feb-2004 110669 5.6
Mar-2004 154981 5.8
Apr-2004 135468 5.6
May-2004 118726 5.6
Jun-2004 94590 5.6
Jul-2004 92165 5.5
Aug-2004 93246 5.4
Sep-2004 80017 5.4
Oct-2004 75913 5.5
Nov-2004 65135 5.4
Dec-2004 48406 5.4
Jan-2005 93020 5.3
Feb-2005 113775 5.4
Mar-2005 143048 5.2
Apr-2005 140062 5.2
May-2005 115823 5.1
Jun-2005 90786 5.0
Jul-2005 94954 5.0
Aug-2005 96733 4.9
Sep-2005 93741 5.0
Oct-2005 83557 5.0
Nov-2005 70975 5.0
Dec-2005 52673 4.9
Jan-2006 101195 4.7
Feb-2006 125046 4.8
Mar-2006 160696 4.7
Apr-2006 126538 4.7
May-2006 105450 4.6
Jun-2006 68366 4.6
Jul-2006 59641 4.7
Aug-2006 59751 4.7
Sep-2006 58084 4.5
Oct-2006 60713 4.4
Nov-2006 51594 4.5
Dec-2006 40527 4.4
Jan-2007 71934 4.6
Feb-2007 79268 4.5
Mar-2007 114137 4.4
Apr-2007 104465 4.5
May-2007 88504 4.4
Jun-2007 71338 4.6
Jul-2007 66782 4.7
Aug-2007 59795 4.6
Sep-2007 49581 4.7
Oct-2007 51339 4.7
Nov-2007 42209 4.7
Dec-2007 31802 5.0
Jan-2008 59028 5.0
Feb-2008 73483 4.9
Mar-2008 89770 5.1
Apr-2008 91566 5.0
May-2008 69233 5.4
Jun-2008 53854 5.6
Jul-2008 49472 5.8
Aug-2008 48541 6.1
Sep-2008 44708 6.1
Oct-2008 42938 6.5
Nov-2008 32780 6.8
Dec-2008 25947 7.3
Jan-2009 44502 7.8
Feb-2009 49211 8.3
Mar-2009 67342 8.7
Apr-2009 58493 9.0
May-2009 50884 9.4
Jun-2009 46044 9.5
Jul-2009 43843 9.5
Aug-2009 43522 9.6
Sep-2009 35359 9.8
Oct-2009 40890 10.0
Nov-2009 32815 9.9
Dec-2009 25034 9.9
Jan-2010 34784 9.8
Feb-2010 42790 9.8
Mar-2010 61361 9.9
Apr-2010 55237 9.9
May-2010 47045 9.6
Jun-2010 32955 9.4
Jul-2010 25609 9.4
Aug-2010 26415 9.5
Sep-2010 22796 9.5
Oct-2010 26165 9.4
Nov-2010 22405 9.8
Dec-2010 19429 9.3
Jan-2011 23926 9.1
Feb-2011 28786 9.0
Mar-2011 42014 9.0
Apr-2011 36251 9.1
May-2011 31236 9.0
Jun-2011 27166 9.1
Jul-2011 23170 9.0
Aug-2011 24166 9.0
Sep-2011 22863 9.0
Oct-2011 25612 8.8
Nov-2011 23368 8.6
Dec-2011 18983 8.5
Jan-2012 25714 8.3
Feb-2012 31579 8.3
Mar-2012 42218 8.2
Apr-2012 40628 8.2
May-2012 36966 8.2
Jun-2012 30669 8.2
Jul-2012 26978 8.2
Aug-2012 27567 8.1
Sep-2012 26591 7.8
Oct-2012 28929 7.8
Nov-2012 27636 7.7
Dec-2012 23243 7.9
Jan-2013 26921 8.0
Feb-2013 35042 7.7
Mar-2013 47293 7.5
Apr-2013 48212 7.6
May-2013 43856 7.5
Jun-2013 34436 7.5
Jul-2013 33230 7.3
Aug-2013 33797 7.2
Sep-2013 31802 7.2
Oct-2013 35312 7.2
Nov-2013 31896 6.9
Dec-2013 29528 6.7
Jan-2014 28668 6.6
Feb-2014 36403 6.7
Mar-2014 49596 6.7
Apr-2014 51502 6.3
May-2014 60683 6.3
Jun-2014 57862 6.1
Jul-2014 40708 6.2
Aug-2014 31388 6.2
Sep-2014 25825 5.9
Oct-2014 26450 5.7
Nov-2014 24641 5.8
Dec-2014 25019 5.6
Jan-2015 21514 5.7
Feb-2015 24376 5.5
Mar-2015 29791 5.5
Apr-2015 29750 5.4
May-2015 31576 5.5
Jun-2015 29303 5.3
Jul-2015 28388 5.2
Aug-2015 30239 5.1
Sep-2015 30286 5.0
Oct-2015 32724 5.0
Nov-2015 32838 5.0
Dec-2015 37014 5.0
Jan-2016 23758 4.9
Feb-2016 26072 4.9
Mar-2016 33316 5.0
Apr-2016 38089 5.0
May-2016 40337 4.7
Jun-2016 34450 4.9
Jul-2016 33723 4.9
Aug-2016 37048 4.9
Sep-2016 39501 5.0
Oct-2016 46184 4.9
Nov-2016 47211 4.6
Dec-2016 43251 4.7
Jan-2017 31576 4.8
Feb-2017 18754 4.7
Mar-2017 12195 4.5
Apr-2017 11127 4.4
May-2017 14519 4.3
Jun-2017 16087 4.3
Jul-2017 18187 4.3
Aug-2017 22288 4.4
Sep-2017 22537 4.2