for exceptional proff only
daehan199f
problemsetdata.xlsxQuestion 1
| County | unemployment daniel macdonald: daniel macdonald: Source: BLS LAU database | percent_welfare dept_hh Microsoft Office User: Microsoft Office User: Percent of households that received SSI, Cash assistance, or food stamps/SNAP in past year |
| Alameda | 7.2 | 21.8166884231 |
| Alpine | 9.7 | 25.9574468085 |
| Amador | 10.3 | 30.0122142733 |
| Butte | 10.3 | 31.2765486726 |
| Calaveras | 9.9 | 22.1232546943 |
| Colusa | 18.9 | 23.7354722541 |
| Contra Costa | 7.5 | 16.3877742185 |
| Del Norte | 11.8 | 35.9332884097 |
| El Dorado | 8.5 | 14.0336177128 |
| Fresno | 13.3 | 45.653827985 |
| Glenn | 12.1 | 32.0858414028 |
| Humboldt | 8.1 | 29.8091661557 |
| Imperial | 25 | 35.4531532239 |
| Inyo | 7.8 | 24.6970868781 |
| Kern | 11.7 | 37.9607535322 |
| Kings | 13.4 | 30.9266030927 |
| Lake | 10.9 | 29.3920972644 |
| Lassen | 10.6 | 28.0460699131 |
| Los Angeles | 9.7 | 26.7522663125 |
| Madera | 12.6 | 41.5261777653 |
| Marin | 5.2 | 10.9589562174 |
| Mariposa | 10.5 | 30.1556420233 |
| Mendocino | 8.4 | 33.3771560791 |
| Merced | 14.5 | 43.2466248764 |
| Modoc | 12.3 | 34.0710241894 |
| Mono | 8.5 | 9.3412338794 |
| Monterey | 10.3 | 19.9391902704 |
| Napa | 6.9 | 16.3697249496 |
| Nevada | 8.1 | 18.8842631141 |
| Orange | 6.6 | 19.0866611834 |
| Placer | 7.7 | 12.4594160601 |
| Plumas | 13.8 | 26.402640264 |
| Riverside | 9.9 | 26.9825530455 |
| Sacramento | 8.9 | 33.0440724671 |
| San Benito | 11.1 | 25.7720844695 |
| San Bernardino | 9.8 | 33.8405896469 |
| San Diego | 7.8 | 19.2429109132 |
| San Francisco | 5.5 | 19.2914633373 |
| San Joaquin | 12.3 | 31.7691186924 |
| San Luis Obispo | 6.8 | 17.3259383975 |
| San Mateo | 5.3 | 11.0625918781 |
| Santa Barbara | 7.2 | 23.6690691675 |
| Santa Clara | 6.5 | 15.7428597794 |
| Santa Cruz | 10.3 | 21.3466498381 |
| Shasta | 11.8 | 30.2519713354 |
| Sierra | 12.8 | 11.7764471058 |
| Siskiyou | 13.1 | 38.9639141023 |
| Solano | 9.1 | 23.2562350976 |
| Sonoma | 7.1 | 18.3201337896 |
| Stanislaus | 12.9 | 33.4473738556 |
| Sutter | 14.6 | 30.7493337514 |
| Tehama | 11.6 | 38.5964912281 |
| Trinity | 11.9 | 28.5233487589 |
| Tulare | 14.4 | 48.365794998 |
| Tuolumne | 10.8 | 27.4915217153 |
| Ventura | 7.9 | 19.9738934835 |
| Yolo | 9 | 24.0466407551 |
| Yuba | 13.2 | 37.4221578566 |
Question 2
| Year | Unemployment rate | NAIRU | Unemployment rate - NAIRU | Average weekly hours (Production and Nonsupervisory Employees) |
| 1964 | 5.2 | 5.6 | 38.5 | |
| 1965 | 4.5 | 5.7 | 38.6 | |
| 1966 | 3.8 | 5.8 | 38.5 | |
| 1967 | 3.8 | 5.8 | 37.9 | |
| 1968 | 3.6 | 5.8 | 37.7 | |
| 1969 | 3.5 | 5.9 | 37.5 | |
| 1970 | 5.0 | 5.9 | 37.0 | |
| 1971 | 6.0 | 6.0 | 36.8 | |
| 1972 | 5.6 | 6.1 | 36.9 | |
| 1973 | 4.9 | 6.1 | 36.9 | |
| 1974 | 5.6 | 6.2 | 36.4 | |
| 1975 | 8.5 | 6.2 | 36.0 | |
| 1976 | 7.7 | 6.2 | 36.1 | |
| 1977 | 7.1 | 6.2 | 35.9 | |
| 1978 | 6.1 | 6.3 | 35.7 | |
| 1979 | 5.9 | 6.3 | 35.6 | |
| 1980 | 7.2 | 6.2 | 35.2 | |
| 1981 | 7.6 | 6.2 | 35.2 | |
| 1982 | 9.7 | 6.1 | 34.7 | |
| 1983 | 9.6 | 6.1 | 34.9 | |
| 1984 | 7.5 | 6.1 | 35.1 | |
| 1985 | 7.2 | 6.0 | 34.9 | |
| 1986 | 7.0 | 6.0 | 34.7 | |
| 1987 | 6.2 | 6.0 | 34.8 | |
| 1988 | 5.5 | 5.9 | 34.6 | |
| 1989 | 5.3 | 5.9 | 34.5 | |
| 1990 | 5.6 | 5.9 | 34.3 | |
| 1991 | 6.9 | 5.8 | 34.1 | |
| 1992 | 7.5 | 5.7 | 34.2 | |
| 1993 | 6.9 | 5.5 | 34.3 | |
| 1994 | 6.1 | 5.4 | 34.5 | |
| 1995 | 5.6 | 5.3 | 34.3 | |
| 1996 | 5.4 | 5.2 | 34.3 | |
| 1997 | 4.9 | 5.1 | 34.5 | |
| 1998 | 4.5 | 5.1 | 34.5 | |
| 1999 | 4.2 | 5.0 | 34.4 | |
| 2000 | 4.0 | 5.0 | 34.3 | |
| 2001 | 4.7 | 5.0 | 34.0 | |
| 2002 | 5.8 | 5.0 | 33.9 | |
| 2003 | 6.0 | 5.0 | 33.7 | |
| 2004 | 5.5 | 5.0 | 33.7 | |
| 2005 | 5.1 | 5.0 | 33.7 | |
| 2006 | 4.6 | 5.0 | 33.9 | |
| 2007 | 4.6 | 4.9 | 33.8 | |
| 2008 | 5.8 | 4.9 | 33.6 | |
| 2009 | 9.3 | 5.0 | 33.1 | |
| 2010 | 9.6 | 5.1 | 33.4 | |
| 2011 | 8.9 | 5.2 | 33.6 | |
| 2012 | 8.1 | 5.1 | 33.7 | |
| 2013 | 7.4 | 5.0 | 33.7 | |
| 2014 | 6.2 | 4.9 | 33.7 |
