Macro-Econometrics Homework Assignment

profileyenomrah
HW_Data_Period_4.xlsx
Home>Business & Finance homework help>Economics homework help>Macro-Econometrics Homework Assignment

Quarterly Data

CPI-All Urban Consumers (Current Series)
Not Seasonally Adjusted
Series Title: All items less food and energy in U.S. city average, all urban consumers, not seasonally adjusted
Area: U.S. city average
Item: All items less food and energy
Base Period: 1982-84=100
Years: 1957 to 2017
Annualized
Year Quarter CPI ln(CPI) %Δ
1957 Q1 28.57 3.352
Q2 28.83 3.362 3.72
Q3 29.00 3.367 2.31
Q4 29.33 3.379 4.57
1958 Q1 29.43 3.382 1.36
Q2 29.50 3.384 0.90
Q3 29.60 3.388 1.35
Q4 29.83 3.396 3.14
1959 Q1 29.93 3.399 1.34
Q2 30.07 3.403 1.78
Q3 30.23 3.409 2.21
Q4 30.50 3.418 3.51
1960 Q1 30.57 3.420 0.87
Q2 30.60 3.421 0.44
Q3 30.60 3.421 0.00
Q4 30.80 3.428 2.61
1961 Q1 30.80 3.428 0.00
Q2 30.90 3.431 1.30
Q3 31.03 3.435 1.72
Q4 31.20 3.440 2.14
1962 Q1 31.23 3.441 0.43
Q2 31.37 3.446 1.70
Q3 31.43 3.448 0.85
Q4 31.60 3.453 2.12
1963 Q1 31.53 3.451 -0.84
Q2 31.73 3.457 2.53
Q3 31.87 3.462 1.68
Q4 32.07 3.468 2.50
1964 Q1 32.13 3.470 0.83
Q2 32.23 3.473 1.24
Q3 32.27 3.474 0.41
Q4 32.47 3.480 2.47
1965 Q1 32.60 3.484 1.64
Q2 32.70 3.487 1.23
Q3 32.73 3.488 0.41
Q4 32.93 3.494 2.44
1966 Q1 33.00 3.497 0.81
Q2 33.40 3.509 4.82
Q3 33.70 3.517 3.58
Q4 34.07 3.528 4.33
1967 Q1 34.20 3.532 1.56
Q2 34.50 3.541 3.49
Q3 34.83 3.551 3.85
Q4 35.30 3.564 5.32
1968 Q1 35.63 3.573 3.76
Q2 36.03 3.584 4.47
Q3 36.53 3.598 5.51
Q4 37.07 3.613 5.80
1969 Q1 37.53 3.625 5.00
Q2 38.20 3.643 7.04
Q3 38.67 3.655 4.86
Q4 39.30 3.671 6.50
1970 Q1 39.83 3.685 5.39
Q2 40.53 3.702 6.97
Q3 41.07 3.715 5.23
Q4 41.87 3.734 7.72
1971 Q1 42.13 3.741 2.54
Q2 42.57 3.751 4.09
Q3 42.97 3.760 3.74
Q4 43.30 3.768 3.09
1972 Q1 43.50 3.773 1.84
Q2 43.87 3.781 3.36
Q3 44.23 3.789 3.33
Q4 44.60 3.798 3.30
1973 Q1 44.73 3.801 1.19
Q2 45.27 3.813 4.74
Q3 45.73 3.823 4.10
Q4 46.60 3.842 7.51
1974 Q1 47.13 3.853 4.55
Q2 48.43 3.880 10.88
Q3 50.10 3.914 13.53
Q4 51.70 3.945 12.57
1975 Q1 52.57 3.962 6.65
Q2 53.50 3.980 7.04
Q3 54.27 3.994 5.69
Q4 55.23 4.012 7.06
1976 Q1 56.03 4.026 5.75
Q2 56.97 4.042 6.61
Q3 57.93 4.059 6.73
Q4 58.80 4.074 5.94
1977 Q1 59.53 4.087 4.96
Q2 60.63 4.105 7.32
Q3 61.53 4.120 5.89
Q4 62.40 4.134 5.59
1978 Q1 63.30 4.148 5.73
Q2 64.73 4.170 8.96
Q3 66.20 4.193 8.96
Q4 67.70 4.215 8.96
1979 Q1 69.00 4.234 7.61
Q2 70.80 4.260 10.30
Q3 72.70 4.286 10.59
Q4 74.93 4.317 12.10
1980 Q1 77.40 4.349 12.96
Q2 80.20 4.385 14.21
Q3 81.47 4.400 6.27
Q4 84.07 4.432 12.57
1981 Q1 85.70 4.451 7.70
Q2 87.77 4.475 9.53
Q3 90.83 4.509 13.74
Q4 92.67 4.529 7.99
1982 Q1 93.47 4.538 3.44
Q2 95.40 4.558 8.19
Q3 97.03 4.575 6.79
Q4 97.50 4.580 1.92
1983 Q1 97.87 4.584 1.50
Q2 98.83 4.593 3.93
Q3 100.10 4.606 5.09
Q4 101.67 4.622 6.21
1984 Q1 102.63 4.631 3.79
Q2 103.87 4.643 4.78
Q3 105.17 4.656 4.98
Q4 106.50 4.668 5.04
1985 Q1 107.40 4.677 3.37
Q2 108.53 4.687 4.20
Q3 109.47 4.696 3.43
Q4 111.07 4.710 5.80
1986 Q1 111.93 4.718 3.11
Q2 112.90 4.727 3.44
Q3 113.93 4.736 3.64
Q4 115.33 4.748 4.89
1987 Q1 116.23 4.756 3.11
Q2 117.57 4.767 4.56
Q3 118.67 4.776 3.73
Q4 120.33 4.790 5.58
1988 Q1 121.27 4.798 3.09
Q2 122.70 4.810 4.70
Q3 123.93 4.820 4.00
Q4 125.77 4.834 5.87
1989 Q1 126.97 4.844 3.80
Q2 128.27 4.854 4.07
Q3 129.43 4.863 3.62
Q4 131.23 4.877 5.52
1990 Q1 132.90 4.890 5.05
Q2 134.47 4.901 4.69
Q3 136.37 4.915 5.61
Q4 138.10 4.928 5.05
1991 Q1 140.20 4.943 6.04
Q2 141.30 4.951 3.13
Q3 142.70 4.961 3.94
Q4 144.23 4.971 4.28
1992 Q1 145.63 4.981 3.86
Q2 146.73 4.989 3.01
Q3 147.70 4.995 2.63
Q4 149.17 5.005 3.95
1993 Q1 150.70 5.015 4.09
Q2 151.73 5.022 2.73
Q3 152.50 5.027 2.02
Q4 153.77 5.035 3.31
1994 Q1 155.03 5.044 3.28
Q2 156.03 5.050 2.57
Q3 156.97 5.056 2.39
Q4 158.03 5.063 2.71
1995 Q1 159.57 5.072 3.86
Q2 160.80 5.080 3.08
Q3 161.60 5.085 1.99
Q4 162.83 5.093 3.04
1996 Q1 164.17 5.101 3.26
Q2 165.10 5.107 2.27
Q3 165.90 5.111 1.93
Q4 167.07 5.118 2.80
1997 Q1 168.27 5.126 2.86
Q2 169.30 5.132 2.45
Q3 169.70 5.134 0.94
Q4 170.77 5.140 2.51
1998 Q1 171.97 5.147 2.80
Q2 173.03 5.153 2.47
Q3 173.77 5.158 1.69
Q4 174.77 5.163 2.30
1999 Q1 175.73 5.169 2.21
Q2 176.67 5.174 2.12
Q3 177.23 5.177 1.28
Q4 178.30 5.183 2.40
2000 Q1 179.60 5.191 2.91
Q2 180.93 5.198 2.96
Q3 181.77 5.203 1.84
Q4 182.87 5.209 2.41
2001 Q1 184.40 5.217 3.34
Q2 185.67 5.224 2.74
Q3 186.63 5.229 2.08
Q4 187.83 5.236 2.56
2002 Q1 189.07 5.242 2.62
Q2 190.20 5.248 2.39
Q3 190.87 5.252 1.40
Q4 191.67 5.256 1.67
2003 Q1 192.43 5.260 1.60
Q2 193.10 5.263 1.38
Q3 193.43 5.265 0.69
Q4 193.93 5.268 1.03
2004 Q1 195.00 5.273 2.19
Q2 196.53 5.281 3.13
Q3 196.93 5.283 0.81
Q4 198.03 5.288 2.23
2005 Q1 199.53 5.296 3.02
Q2 200.77 5.302 2.46
Q3 201.03 5.303 0.53
Q4 202.23 5.309 2.38
2006 Q1 203.70 5.317 2.89
Q2 205.70 5.326 3.91
Q3 206.70 5.331 1.94
Q4 207.57 5.335 1.67
2007 Q1 209.01 5.342 2.78
Q2 210.37 5.349 2.58
Q3 211.17 5.353 1.51
Q4 212.37 5.358 2.28
2008 Q1 213.96 5.366 2.98
Q2 215.26 5.372 2.44
Q3 216.46 5.377 2.22
Q4 216.60 5.378 0.26
2009 Q1 217.68 5.383 1.98
Q2 219.18 5.390 2.75
Q3 219.69 5.392 0.93
Q4 220.38 5.395 1.25
2010 Q1 220.58 5.396 0.37
Q2 221.21 5.399 1.13
Q3 221.57 5.401 0.66
Q4 221.98 5.403 0.74
2011 Q1 222.96 5.407 1.75
Q2 224.51 5.414 2.78
Q3 225.78 5.420 2.24
Q4 226.78 5.424 1.78
2012 Q1 227.95 5.429 2.05
Q2 229.59 5.436 2.88
Q3 230.29 5.439 1.21
Q4 231.19 5.443 1.56
2013 Q1 232.37 5.448 2.03
Q2 233.45 5.453 1.86
Q3 234.28 5.457 1.42
Q4 235.14 5.460 1.46
2014 Q1 236.12 5.464 1.67
Q2 237.90 5.472 3.00
Q3 238.43 5.474 0.88
Q4 239.15 5.477 1.21
2015 Q1 240.13 5.481 1.65
Q2 242.09 5.489 3.25
Q3 242.82 5.492 1.19
Q4 243.95 5.497 1.86
2016 Q1 245.52 5.503 2.58
Q2 247.44 5.511 3.12
Q3 248.25 5.514 1.30
Q4 249.19 5.518 1.51
2017 Q1 250.84 5.525 2.63
Q2 251.83 5.529 1.58

Monthly Data

CPI-All Urban Consumers (Current Series)
Original Data Value
Series Id: CUUR0000SA0L1E
Not Seasonally Adjusted
Series Title: All items less food and energy in U.S. city average, all urban consumers, not seasonally adjusted
Area: U.S. city average
Item: All items less food and energy
Base Period: 1982-84=100
Years: 1957 to 2017
Year Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec HALF1 HALF2
1957 28.5 28.5 28.7 28.8 28.8 28.9 28.9 29.0 29.1 29.2 29.4 29.4
1958 29.4 29.4 29.5 29.5 29.5 29.5 29.6 29.6 29.6 29.7 29.9 29.9
1959 29.9 29.9 30.0 30.0 30.1 30.1 30.2 30.2 30.3 30.5 30.5 30.5
1960 30.5 30.6 30.6 30.6 30.6 30.6 30.6 30.6 30.6 30.8 30.8 30.8
1961 30.8 30.8 30.8 30.9 30.9 30.9 31.0 31.0 31.1 31.2 31.2 31.2
1962 31.2 31.2 31.3 31.3 31.4 31.4 31.4 31.4 31.5 31.6 31.6 31.6
1963 31.5 31.5 31.6 31.7 31.7 31.8 31.8 31.9 31.9 32.0 32.1 32.1
1964 32.1 32.1 32.2 32.2 32.2 32.3 32.3 32.2 32.3 32.4 32.5 32.5
1965 32.6 32.6 32.6 32.7 32.7 32.7 32.7 32.7 32.8 32.9 32.9 33.0
1966 32.9 33.0 33.1 33.3 33.4 33.5 33.6 33.7 33.8 34.0 34.1 34.1
1967 34.1 34.2 34.3 34.4 34.5 34.6 34.7 34.8 35.0 35.2 35.3 35.4
1968 35.5 35.6 35.8 35.9 36.0 36.2 36.4 36.5 36.7 36.9 37.1 37.2
1969 37.3 37.5 37.8 38.1 38.2 38.3 38.5 38.6 38.9 39.1 39.3 39.5
1970 39.6 39.8 40.1 40.3 40.5 40.8 40.9 41.0 41.3 41.6 41.9 42.1
1971 42.1 42.1 42.2 42.3 42.6 42.8 42.9 42.9 43.1 43.2 43.3 43.4
1972 43.4 43.5 43.6 43.7 43.9 44.0 44.1 44.3 44.3 44.5 44.6 44.7
1973 44.6 44.7 44.9 45.1 45.3 45.4 45.5 45.7 46.0 46.4 46.6 46.8
1974 46.8 47.1 47.5 47.9 48.4 49.0 49.5 50.1 50.7 51.3 51.8 52.0
1975 52.2 52.6 52.9 53.3 53.5 53.7 54.0 54.2 54.6 54.9 55.3 55.5
1976 55.7 56.0 56.4 56.7 57.0 57.2 57.6 57.9 58.3 58.6 58.9 58.9
1977 59.2 59.5 59.9 60.3 60.6 61.0 61.2 61.5 61.9 62.1 62.4 62.7
1978 63.0 63.2 63.7 64.2 64.7 65.3 65.7 66.1 66.8 67.3 67.8 68.0
1979 68.4 69.0 69.6 70.2 70.8 71.4 72.0 72.7 73.4 74.1 75.0 75.7
1980 76.6 77.3 78.3 79.3 80.2 81.1 80.9 81.3 82.2 83.2 84.1 84.9
1981 85.3 85.7 86.1 86.8 87.8 88.7 89.9 90.7 91.9 92.3 92.7 93.0
1982 93.2 93.5 93.7 94.5 95.4 96.3 96.7 97.1 97.3 97.7 97.6 97.2
1983 97.6 97.9 98.1 98.6 98.8 99.1 99.6 100.0 100.7 101.3 101.8 101.9
1984 102.3 102.6 103.0 103.5 103.9 104.2 104.6 105.1 105.8 106.3 106.5 106.7 103.2 105.8
1985 106.9 107.4 107.9 108.2 108.6 108.8 109.0 109.4 110.0 110.7 111.2 111.3 108.0 110.3
1986 111.6 111.9 112.3 112.7 112.9 113.1 113.5 113.8 114.5 115.1 115.4 115.5 112.4 114.7
1987 115.8 116.1 116.8 117.4 117.6 117.7 118.0 118.6 119.4 120.1 120.5 120.4 116.9 119.5
1988 120.8 121.1 121.9 122.4 122.7 123.0 123.3 123.8 124.7 125.5 125.8 126.0 122.0 124.9
1989 126.4 126.9 127.6 128.0 128.3 128.5 129.0 129.3 130.0 130.9 131.3 131.5 127.6 130.3
1990 132.0 132.8 133.9 134.2 134.4 134.8 135.5 136.4 137.2 137.8 138.2 138.3 133.7 137.2
1991 139.4 140.3 140.9 141.1 141.3 141.5 142.0 142.7 143.4 143.9 144.4 144.4 140.8 143.5
1992 144.9 145.6 146.4 146.6 146.7 146.9 147.3 147.7 148.1 149.0 149.3 149.2 146.2 148.4
1993 149.9 150.8 151.4 151.7 151.7 151.8 152.0 152.6 152.9 153.5 153.9 153.9 151.2 153.1
1994 154.3 155.0 155.8 155.9 156.0 156.2 156.4 157.0 157.5 158.0 158.2 157.9 155.5 157.5
1995 158.7 159.6 160.4 160.7 160.8 160.9 161.1 161.6 162.1 162.8 163.0 162.7 160.2 162.2
1996 163.4 164.2 164.9 165.0 165.1 165.2 165.5 165.8 166.4 167.0 167.2 167.0 164.6 166.5
1997 167.5 168.3 169.0 169.4 169.3 169.2 169.5 169.6 170.0 170.8 170.8 170.7 168.8 170.2
1998 171.2 172.1 172.6 173.0 173.1 173.0 173.3 173.8 174.2 174.7 174.8 174.8 172.5 174.3
1999 175.3 175.7 176.2 176.8 176.6 176.6 176.9 177.1 177.7 178.3 178.4 178.2 176.2 177.8
2000 178.8 179.5 180.5 180.9 180.9 181.0 181.3 181.7 182.3 182.8 183.0 182.8 180.3 182.3
2001 183.5 184.4 185.3 185.6 185.5 185.9 186.2 186.6 187.1 187.6 188.1 187.8 185.0 187.2
2002 188.2 189.2 189.8 190.3 190.2 190.1 190.3 191.0 191.3 191.8 191.8 191.4 189.6 191.3
2003 191.8 192.5 193.0 193.1 193.2 193.0 193.2 193.5 193.6 194.3 193.9 193.6 192.8 193.7
2004 194.0 194.9 196.1 196.5 196.5 196.6 196.6 196.8 197.4 198.2 198.1 197.8 195.8 197.5
2005 198.4 199.5 200.7 200.9 200.8 200.6 200.8 201.0 201.3 202.3 202.3 202.1 200.2 201.6
2006 202.6 203.6 204.9 205.5 205.7 205.9 206.2 206.7 207.2 207.8 207.6 207.3 204.7 207.1
2007 208.009 209.112 209.923 210.311 210.316 210.474 210.756 211.111 211.628 212.318 212.435 212.356 209.691 211.767
2008 213.138 213.866 214.866 215.059 215.180 215.553 216.045 216.476 216.862 217.023 216.690 216.100 214.610 216.533
2009 216.719 217.685 218.639 219.143 219.128 219.283 219.350 219.596 220.137 220.731 220.384 220.025 218.433 220.037
2010 220.086 220.602 221.059 221.166 221.193 221.265 221.258 221.551 221.907 222.079 222.077 221.795 220.895 221.778
2011 222.177 223.011 223.690 224.118 224.534 224.891 225.164 225.874 226.289 226.743 226.859 226.740 223.737 226.278
2012 227.237 227.865 228.735 229.303 229.602 229.879 229.893 230.196 230.780 231.276 231.263 231.033 228.770 230.740
2013 231.612 232.432 233.052 233.236 233.462 233.640 233.792 234.258 234.782 235.162 235.243 235.000 232.906 234.706
2014 235.367 236.075 236.913 237.509 238.029 238.157 238.138 238.296 238.841 239.413 239.248 238.775 237.008 238.785
2015 239.248 240.083 241.067 241.802 242.119 242.354 242.436 242.651 243.359 243.985 244.075 243.779 241.112 243.381
2016 244.528 245.680 246.358 246.992 247.544 247.794 247.744 248.278 248.731 249.218 249.227 249.134 246.483 248.722
2017 250.083 251.143 251.290 251.642 251.835 252.014 251.936 251.335

Bureau of Labor Statistics

Source: Bureau of Labor Statistics Generated on: September 11, 2017 (12:42:32 PM)