Calibri WI 29 Wrap Text Paste ID Copy Format Painter BIU V A Merge & Cen Clipboard Font Alignment 0114 fax 649 A F G H 1 B D E Consumer Price Index - All Urban Consumers 2 Original Data Value K M This problem uses Consumer Price In (BUS) from 1913 to 2015. Note the ye 1913. 4 Series Id: CUUR0000SAO 5 Not Seasonally Adjusted 6 Area: U.S. city average Item: All items Base 1982-84=100 8 Period: 9 Years: 1913 to 2015 10 Jan Feb Mar Jul 11 Year 12 1913 13 1914 14 1915 15 1916 16 1917 17 1918 18 1919 19 1920 20 1921 21 1922 9.8 10.0 10.1 10.4 11.7 14.0 16.5 19.3 19.0 16.9 9.8 9.9 10.0 10.4 120 14.1 16.2 19.5 18.4 16.9 9.8 9.9 9.9 10.5 120 14.0 16.4 19.7 18.3 16 Apr 9.8 9.8 10.0 10.6 12.6 14.2 16.7 20.3 18 1 May 9.7 9.9 10.1 10.7 12.8 14.5 16.9 20.6 177 Jun 9.8 9.9 10.1 10.8 13 0 14.7 16.9 20.9 17.6 9.9 10.0 10.1 10.8 12.8 15.1 17.4 20.8 17.7 Aug 9.9 10.2 10.1 10.9 13.0 15.4 17.7 20.3 17.7 Sep 10.0 10.2 10.1 11.1 13.3 15.7 17.8 20.0 17.5 Oct 10.0 10.1 10.2 11.3 13.5 16.0 18.1 19 9 17.5 Nov 10.1 10.2 10.3 11.5 13.5 16.3 18.5 19.8 17.4 168 Dec 10.0 10.11 10.3 11.6 13.7 16.5 18.9 19.4 173 16.9 H 1 B 1 Consumer Price Index - An Urban Consumers Original Data Value P M N This problem uses Consumer Price Index (CPIdata from the US. Bureau of Labor Statistics (US) from 1913 to 2015. Note the years may be hidden scroll to go all the way back to 1913. 4 Series Id:CUUROOODSAD 5 Not Seasonally Adjusted Areas U.S. city Live Item Allems Base 1982-84 100 Period Years: 1913 to 2015 Mar Apr Oct 10.0 10.1 102 Nov 10.1 107 10.3 115 135 153 18.5 198 169 1 Year 2 1913 3 1914 4 1915 5 1916 6 1917 7 1918 1919 9 1920 50 1921 21 1922 22 1923 3 1924 24 1925 5 1926 6 1927 27 1928 ER 1979 29 1930 30 1931 SE 1932 32 1933 33 1934 34 | 1935 35 1936 36 1937 Jan Feb 98 98 10.0 99 10.1 10.0 104 104 11.7 120 140 14.1 16.5 162 193 19.5 19.0 184 16.9 16.8 168 17.2 17.3 172 179 17.5 174 17.3 171 17.1 17 1 17.1 170 15,9 157 143 14 1 12.9 127 132 133 13.6 137 13.8 138 141 #4 CPI 173 May 9.7 9.9 10.1 10.7 12.8 14.5 16.9 206 177 16.7 169 170 173 178 174 172 17.0 16.9 15.3 13.7 126 133 138 137 144 9.8 100 106 126 142 16.7 20.3 18.1 16.7 16.9 17.0 172 17.9 173 17.1 16.9 17.0 155 139 126 13.3 138 13.7 99 10.5 120 14.0 16.4 197 183 167 16.8 17.1 173 17.8 173 17.1 17.0 16.9 15.6 14.0 126 133 13.7 137 142 Jun 9.8 99 10.1 10.8 13.0 14.7 16.9 20.9 17.6 16.7 17.0 17.0 17.5 17.7 176 17.1 17.1 16.8 15.1 13.6 127 13.4 13.7 13.8 144 Jul 9.9 10.0 10.1 10 8 12.8 15.1 174 208 177 168 172 171 177 175 17.3 17.1 17.3 166 15.1 13.6 13.1 134 13.7 Aug 99 102 10.1 10.9 13.0 154 17.2 20.3 17.7 16.6 17.1 17.0 17.7 174 172 171 173 16.5 15.1 13.5 13.2 13.4 13.7 14.0 145 Sep 100 102 101 111 13.3 15.7 178 20.0 175 156 172 17.1 17.7 17.5 173 173 173 166 150 173 174 16,8 173 172 18.0 177 173 Ratio Cost of Dec Annual IPhone 6s This Year CPT: Previous Year CPI Annual Inflation Rate 100 9.9 10.1 10 0 10.3 10.1 11.6 109 137 12.8 16.5 15.1 183 173 19.4 200 173 17.9 1691 16.8 173 17.1 171 179 175 177 177 173 17.4 171 17.1 172 17.1 16.1 16.7 14.6 152 13.1 137 132 13.0 13.4 134 138 13.7 14 0 139 14.4 14,4 135 16.0 18.1 19.9 17.5 16.7 173 172 177 17.6 17.4 172 173 165 149 13.3 132 135 13.7 179 132 136 13.7 140 146 173 16.4 147 132 132 135 138 14.0 14.5 13.9 140 145 14.6 Type here to search o E P18 H B 1 Consumer Price Index - All Urban Consumers 2 Original Data Value K M N This problem uses Consumer Price Index (CP) data from the U.S. Bureau of Labor Statistics (5) from 1913 to 2015. Note the years may be hidden scroll to go all the way back to 1913 4 Series Id: CUUROOOOSAO 5 Not Seasonally Adjusted 6 Area US city average 7 Item: All items 198284100 8 Period 9 Year: 1913 to 2015 10 Bese Jan Nov 142 Mar 141 13.9 May 141 13.8 14.0 140 14.0 141 138 140 139 Aug 14.1 138 14.0 14.9 165 173 141 147 14.0 14.0 154 168 15.7 11 Year 37 1938 1999 30 140 40 141 41 142 42 19413 43 1944 44 1945 45 1946 46 1947 47 1948 48 149 49 1950 50 1951 159 Feb 14.1 139 140 141 15.8 16.9 174 178 181 21.5 235 238 23.5 25.7 263 Oct 14.0 14.0 14.0 15.3 16.7 174 177 181 20.3 230 178 182 21.5 Sep 14.1 14.1 140 15.1 165 174 177 181 204 23.0 24.5 23.9 24.4 215 237 142 160 172 17.4 178 18.3 21.9 23.4 23.8 236 25.8 26.3 266 26.5 26.7 26.8 278 288 289 Apr 14.2 13.8 140 14.3 161 17.4 17.5 17.8 18.4 21.9 23.8 23.9 23.6 25.8 26.4 26.6 26.8 26.7 269 273 289 290 29.5 298 302 240 235 254 265 266 26.9 267 268 Jun 14.1 13.8 14.1 14.7 16.3 17.5 17.6 18.1 18.7 220 24.1 23.9 238 259 265 26.8 26.9 26.7 272 28.1 28.9 29.1 296 29.8 302 18.1 20 2 225 245 238 24.3 163 17.5 175 179 18.5 21.9 23.9 238 23.7 259 264 26.7 26.9 267 270 28.0 28.9 29.0 295 29.0 302 16.4 174 177 18.1 198 222 24.4 237 24.1 25.5 26.7 26.8 26.9 263 274 283 290 292 29.6 30.0 303 51 1952 52 1953 53 1954 54 1955 55 1956 56 1957 57 1958 58 1959 59 1960 60 1961 265 Rato Cost of Dec Annual IPhone 6s This Year CPI: Previous Year CP Annual Indiation Rate 14.0 14.1 140 139 14,1 14.0 15 5 147 16.9 163 174 173 170 176 18.2 18.0 19.5 234 24.1 24,1 23.5 238 25.0 241 265 260 267 265 26.9 26 26.7 269 26.8 26 276 272 284 281 289 28 29.4 29.1 29.8 29,6 30.0 29.9 3041 2021 269 26.7 26.8 26.7 26.9 26.9 26.8 273 283 289 292 29.6 17.7 181 213 231 242 23.8 24.7 264 26.7 26.9 268 269 27,5 28.4 29.0 29.4 29.8 30.0 304 23.7 24,6 26.2 26.7 270 268 269 275 283 28.9 29.4 29.8 300 304 276 21.1 26.9 26.8 269 274 28.3 289 293 29.6 30.0 304 28.6 290 286 28.9 29.4 29.8 30.1 29.9 298 30.0 #4 CPI 301 30.3 + Type here to search O IT lije G H Consumer Price Index - All Urban Consumers 2 Original Data Value M N 0 This problem uses Consumer Price Index (CPI) data from the 0.5 Bureau of Labor Statistics (BLS from 1913 to 2015. Note the years may be hidden scroll to go all the way back to 1913 4 Series Id: CUURDOOSAD 5 Not Seasonally Adjusted 6 Area: U S city average 7 Item: All Rems Base 198284-100 8 Period: 9 Years: 1913 to 2015 10 Ratio Dec Annual Inflatt May 30.5 30.9 31.4 32.9 11 Year 62 1963 63 1964 64 1965 65 1966 66 1967 67 1968 68 1969 69 1970 70 1971 71 1972 72 1973 23 1974 74 1975 75 1976 76 1977 7.1978 78 1979 79 1980 80 1981 81 1982 82 1983 83 1984 84 1985 RS 1986 86 1987 Jan Feb 30.4 304 30.9 309 312 312 31:8 320 32.9 34.1 342 35.6 35 8 378 380 39,8 39.9 41.1 42.6 42.9 466 472 52.1 52.5 55.6 558 58 5 591 625 629 683 69.1 77.8 78.9 870 879 94.3 946 978 97.9 101.9 105.5 1060 109.3 1112 1116 #4 CPI Mar 305 30.9 31.3 32.1 33.0 343 361 382 40.0 41.4 433 478 527 55.9 59.5 634 69 8 801 Apr 30.5 30.9 31.4 323 33.1 344 363 38.5 40.1 415 43.6 48.0 529 332 345 36.4 386 40.3 416 43.9 486 53.2 56.5 60.3 Jun 30.6 31.0 31.6 32.4 33.3 34.7 36.6 38.8 406 41.7 442 49.0 536 568 607 65.2 723 827 90 6 Jul 30.7 31.1 31.6 325 33.4 349 368 39.0 40.7 41.9 443 49.4 542 571 610 65.7 444 Aug 30.7 31.0 316 327 33.5 35.0 37.0 39.0 40.8 420 45.1 500 543 574 612 66 0 738 83.3 923 97.7 1002 104.5 108.0 1097 1144 Sep 30.7 31.1 316 327 33.6 35.1 37.1 392 40.8 421 452 506 54.6 57.6 614 66.5 Oct 30.8 31.1 31.7 32.9 33.7 353 373 39.4 40.9 423 456 51.1 54.9 57.9 616 67.1 752 84.8 934 98.2 1010 105.3 1067 1103 1153 Nov 30 8 312 317 329 338 35.4 375 39.6 409 424 459 515 55.3 58.0 61.9 67.4 75.9 855 93.7 98.0 1012 1053 109.0 110.4 115.4 Cost of Annual iPhone 6s This Year CPI: Previous Year CPL 30.9 30.6 312 31.0 31.8 31.5 329 32.4 339 334 35.5 34,8 37.7 367 39.8 38.8 41.1 40.5 425 41.8 462 51.9 493 56.5 538 582 56.9 62.1 606 677 65.2 76.7 726 86.3 824 940 90.9 976 96.5 101.3 99.6 105.3 1039 1093 107.6 1105 109.6 115.4 561 645 73.1 746 885 600 63.9 70.6 81.0 89.1 94.9 98.6 103.1 1069 108.6 1127 970 94.5 97.9 1026 106.4 1088 112.1 715 81.8 89.8 95.8 992 103 4 107.3 108 9 827 91.6 975 99.9 1041 1024 99.5 1037 1076 1095 1135 84.0 932 979 100.7 105.0 108.3 1102 115.0 1018 1096 1095 113.8 A Type here to search O M o This problem uses Consumer Price Index (C) data from the US. Bureau of Labor Statistics (85) from 1913 to 2015. Note the years may be hidden scroll to go all the way back to 1913, 1 Consumer Price Index - All Urban Consumers 2 Original Data Value 3 4 Series Id:CUUROOOOSAO 5 Not Seasonally adjusted 6 Area: US city 7 Items All items Base 1982 81-100 8 Period 9 Years 1913 to 2015 10 Des 13 Year 87 1988 88 1989 89 1990 90 1991 91 1992 92 1993 93 1994 Mar 1165 1223 128.7 Jun 1180 1241 1299 136.0 140.2 Jul 118.5 1244 1304 1362 1405 1444 1350 148 4 1586 944 1995 95 1996 95 1997 97 1998 98 1999 99 2000 100 2001 101 2002 102 2003 103 2004 104.2005 105 2006 106 2007 107 2008 108 2009 100 2010 110 2011 111 7012 Jan Feb 115.7 116.0 121.1 121.6 127.4 1280 1346 1348 138.1 1386 1426 1431 1462 1467 1503 150.9 154.4 154.9 1591 159.6 1616 1619 1643 164.5 1688 1698 175 1 175.8 1771 177.8 1817 183.1 1852 1862 190.7 1918 1983 198.7 202.4 2035 2111 211.7 211,1 2122 2167 2167 220.2 2213 2267 2277 N4 CPI 1393 143.6 1472 1514 155.7 160.0 1622 1650 1712 1752 1788 1842 1874 1933 1998 205.4 213.5 212.7 2176 2235 Apr 117.1 123.1 128.9 1352 139.5 144.0 1474 151.9 156.3 1602 1525 1662 1713 1769 1798 1838 188.0 1946 2015 2067 2148 2132 218.0 2249 2301 May 117.5 1238 1292 1356 139.7 1442 147.5 1522 156.6 160.1 162.8 1662 1715 177.7 179.8 183,5 1891 1944 2025 2074 2166 213.9 2182 2260 229.8 148.0 152.5 1567 160.3 1630 1662 172.4 1780 1799 183.7 189.7 1945 2029 208.4 218.8 2157 2180 1525 1570 160.5 1632 1667 1728 1775 1801 1839 1894 1954 Aug 1190 1246 1316 136.6 140.9 1448 1490 1529 157.3 1608 163.4 167.1 1728 1775 1807 184.6 1895 196.4 203.9 207.9 219.1 2158 2183 2265 2304 Sep 119,8 1250 1327 1372 1413 145.1 1494 1532 1578 1612 1636 1679 1737 178.3 181.0 1852 1899 1988 2029 208.5 2188 2160 2184 226.9 2314 Oct 120 2 1256 133.5 1374 141.8 1457 149.5 1537 1583 1616 1640 1682 1740 1777 1813 185.0 190.9 1992 2018 2009 216.6 2162 218.7 226.4 2313 Nov 120.3 125.9 1338 1378 142.0 145.8 149.7 153.6 1586 1615 1640 1683 174.1 1774 181.3 1845 191.0 1976 2015 2102 2124 216.3 218.8 226.2 2302 Ratio Cost of Annual IPhone 6s This Year CP1 : Previous Year CPI Annual Inflation R 120.5 118.3 1261 1240 133.8 130 1379 136.2 1419 1403 145.8 1445 149.7 1482 1535 1524 156.9 161.3 160.5 163.9 163.0 168 166.6 174.0 1722 176.7 1721 1803 179 1843 1840 190.3 188.9 1953 2018 2016 2100 2073 2102 2153 2159 214.5 219 2 2181 225.7 224.9 2296 2296 1968 2035 2083 2200 215 4 2180 225.9 229.1 229.5 Type here to search DI O This problem uses Consumer Price Index (CPI) data from the U.S. Bureau of Labor Statistics (BLS) from 1913 to 2015. Note the years may be hidden scroll to go all the way back to 1913. LUNSUNel Plce ex-All Urban Consumers 2 Original Data Value 3 4 Series Id: CUUROOOOSAO 5 Not Seasonally Adjusted 6 Area: US city average 7 Item: All items Base 1982-84 100 8 Period: 9 Years: 1913 to 2015 10 Anne Aug 177.5 180.7 1946 11 Year 100 2001 101 2002 102 2003 103 2004 104/2005 105 2006 106 2007 107 2008 108 2009 109 2010 110 2011 111 2012 112 2013 113 2014 114 2015 115 116 117 Jan 175.1 177.1 181.7 1852 190.7 1983 202.4 211.1 211.1 216.7 220.2 2267 2303 2339 2337 Feb 175.8 1778 183.1 1862 191.8 1987 2035 211.7 2122 216.7 2213 2277 2322 2348 234.7 Mar 1762 178.8 1842 1874 1933 199.8 2054 2135 2127 2176 2235 2294 232.8 2363 236 1 Apr 176 9 1798 1838 1880 1946 2015 2067 2148 213.2 218.0 224.9 230.1 232.5 237.1 236.6 May 177.7 179.8 183.5 189 1 194.4 202.5 207.9 216.6 213.9 2182 2260 229 8 2329 2379 2378 Jun 178.0 1799 183.7 189.7 194.5 202.9 2084 218.8 215.7 218.0 225.7 229.5 233.5 238.3 238.6 Jul 1775 180.1 183.9 189.4 1954 203.5 208 3 220.0 215.4 218.0 225.9 229.1 233.6 238.3 238.7 189.5 1964 2039 207.9 219.1 2158 2183 226.5 2304 233.9 2379 2383 Sep 178.3 181.0 1852 1899 1988 202.9 208 5 218.8 216.0 218.4 226.9 231.4 234 1 2380 2379 Oct 1777 1813 1850 1909 1992 201.8 2089 2166 2162 2187 2264 2313 233.5 2374 237.8 Nov 1774 181.3 184.5 191.0 1976 2015 2102 212.4 216.3 218 8 2262 230 2 233.1 2362 2373 Dec 176.7 180.9 184.3 190.3 1968 201.8 210.0 210.2 2159 219 2 2257 229.6 233.0 2348 236.51 Ratio Cost of Annual iPhone 6s This Year CP1 : Previous Year CPI 1771 179.9 184 0 188.9 195.3 2016 2073 215.3 214.5 218.1 224.9 229.6 233.0 236.7 237.05 649.00 118 119 120 121 122 123 124 4 CPI Type here to search O vid General Sha AutoSum Merge Center $ % 4 O 4 Insert Delete Format Conditional Format as Cell Formatting Table Styles Styles Alignment Clear Sort Find & Filter Select Ideas Number Cels Editing Ideas B W AR AC AD AE AF AG AH y Z AA a.) Use the annual CPI values to convert the given cost of an Phone 6s in 2015$ into every other years' dollars. Assuming the iPhone 6s existed back then of course. How did people communicate without cell phones? A AJ b.) Take the ratio of each year's annual CPI to the previous value and scale the second quantity to 1 by simply dividing the two values. Note: parts ce below! annual Inflation Rate c.) Compute the annual inflation rate by subtracting 1 from the ratio from partc. Formatas percentage to 2 decimal places. Max Inflation year: d.) In what year did inflation increase the most? Note there is a way to get Excel to do this for you. First find MAX annual inflation rate. Then use MATCH to find which value this is in the column for inflation rates: 1,2,3... Then you can use INDEX to pull the year from this row, or just find it yourself! Always up? e.) Does inflation always increase from year to year? Answer should be yes or no. Calibri WI 29 Wrap Text Paste ID Copy Format Painter BIU V A Merge & Cen Clipboard Font Alignment 0114 fax 649 A F G H 1 B D E Consumer Price Index - All Urban Consumers 2 Original Data Value K M This problem uses Consumer Price In (BUS) from 1913 to 2015. Note the ye 1913. 4 Series Id: CUUR0000SAO 5 Not Seasonally Adjusted 6 Area: U.S. city average Item: All items Base 1982-84=100 8 Period: 9 Years: 1913 to 2015 10 Jan Feb Mar Jul 11 Year 12 1913 13 1914 14 1915 15 1916 16 1917 17 1918 18 1919 19 1920 20 1921 21 1922 9.8 10.0 10.1 10.4 11.7 14.0 16.5 19.3 19.0 16.9 9.8 9.9 10.0 10.4 120 14.1 16.2 19.5 18.4 16.9 9.8 9.9 9.9 10.5 120 14.0 16.4 19.7 18.3 16 Apr 9.8 9.8 10.0 10.6 12.6 14.2 16.7 20.3 18 1 May 9.7 9.9 10.1 10.7 12.8 14.5 16.9 20.6 177 Jun 9.8 9.9 10.1 10.8 13 0 14.7 16.9 20.9 17.6 9.9 10.0 10.1 10.8 12.8 15.1 17.4 20.8 17.7 Aug 9.9 10.2 10.1 10.9 13.0 15.4 17.7 20.3 17.7 Sep 10.0 10.2 10.1 11.1 13.3 15.7 17.8 20.0 17.5 Oct 10.0 10.1 10.2 11.3 13.5 16.0 18.1 19 9 17.5 Nov 10.1 10.2 10.3 11.5 13.5 16.3 18.5 19.8 17.4 168 Dec 10.0 10.11 10.3 11.6 13.7 16.5 18.9 19.4 173 16.9 H 1 B 1 Consumer Price Index - An Urban Consumers Original Data Value P M N This problem uses Consumer Price Index (CPIdata from the US. Bureau of Labor Statistics (US) from 1913 to 2015. Note the years may be hidden scroll to go all the way back to 1913. 4 Series Id:CUUROOODSAD 5 Not Seasonally Adjusted Areas U.S. city Live Item Allems Base 1982-84 100 Period Years: 1913 to 2015 Mar Apr Oct 10.0 10.1 102 Nov 10.1 107 10.3 115 135 153 18.5 198 169 1 Year 2 1913 3 1914 4 1915 5 1916 6 1917 7 1918 1919 9 1920 50 1921 21 1922 22 1923 3 1924 24 1925 5 1926 6 1927 27 1928 ER 1979 29 1930 30 1931 SE 1932 32 1933 33 1934 34 | 1935 35 1936 36 1937 Jan Feb 98 98 10.0 99 10.1 10.0 104 104 11.7 120 140 14.1 16.5 162 193 19.5 19.0 184 16.9 16.8 168 17.2 17.3 172 179 17.5 174 17.3 171 17.1 17 1 17.1 170 15,9 157 143 14 1 12.9 127 132 133 13.6 137 13.8 138 141 #4 CPI 173 May 9.7 9.9 10.1 10.7 12.8 14.5 16.9 206 177 16.7 169 170 173 178 174 172 17.0 16.9 15.3 13.7 126 133 138 137 144 9.8 100 106 126 142 16.7 20.3 18.1 16.7 16.9 17.0 172 17.9 173 17.1 16.9 17.0 155 139 126 13.3 138 13.7 99 10.5 120 14.0 16.4 197 183 167 16.8 17.1 173 17.8 173 17.1 17.0 16.9 15.6 14.0 126 133 13.7 137 142 Jun 9.8 99 10.1 10.8 13.0 14.7 16.9 20.9 17.6 16.7 17.0 17.0 17.5 17.7 176 17.1 17.1 16.8 15.1 13.6 127 13.4 13.7 13.8 144 Jul 9.9 10.0 10.1 10 8 12.8 15.1 174 208 177 168 172 171 177 175 17.3 17.1 17.3 166 15.1 13.6 13.1 134 13.7 Aug 99 102 10.1 10.9 13.0 154 17.2 20.3 17.7 16.6 17.1 17.0 17.7 174 172 171 173 16.5 15.1 13.5 13.2 13.4 13.7 14.0 145 Sep 100 102 101 111 13.3 15.7 178 20.0 175 156 172 17.1 17.7 17.5 173 173 173 166 150 173 174 16,8 173 172 18.0 177 173 Ratio Cost of Dec Annual IPhone 6s This Year CPT: Previous Year CPI Annual Inflation Rate 100 9.9 10.1 10 0 10.3 10.1 11.6 109 137 12.8 16.5 15.1 183 173 19.4 200 173 17.9 1691 16.8 173 17.1 171 179 175 177 177 173 17.4 171 17.1 172 17.1 16.1 16.7 14.6 152 13.1 137 132 13.0 13.4 134 138 13.7 14 0 139 14.4 14,4 135 16.0 18.1 19.9 17.5 16.7 173 172 177 17.6 17.4 172 173 165 149 13.3 132 135 13.7 179 132 136 13.7 140 146 173 16.4 147 132 132 135 138 14.0 14.5 13.9 140 145 14.6 Type here to search o E P18 H B 1 Consumer Price Index - All Urban Consumers 2 Original Data Value K M N This problem uses Consumer Price Index (CP) data from the U.S. Bureau of Labor Statistics (5) from 1913 to 2015. Note the years may be hidden scroll to go all the way back to 1913 4 Series Id: CUUROOOOSAO 5 Not Seasonally Adjusted 6 Area US city average 7 Item: All items 198284100 8 Period 9 Year: 1913 to 2015 10 Bese Jan Nov 142 Mar 141 13.9 May 141 13.8 14.0 140 14.0 141 138 140 139 Aug 14.1 138 14.0 14.9 165 173 141 147 14.0 14.0 154 168 15.7 11 Year 37 1938 1999 30 140 40 141 41 142 42 19413 43 1944 44 1945 45 1946 46 1947 47 1948 48 149 49 1950 50 1951 159 Feb 14.1 139 140 141 15.8 16.9 174 178 181 21.5 235 238 23.5 25.7 263 Oct 14.0 14.0 14.0 15.3 16.7 174 177 181 20.3 230 178 182 21.5 Sep 14.1 14.1 140 15.1 165 174 177 181 204 23.0 24.5 23.9 24.4 215 237 142 160 172 17.4 178 18.3 21.9 23.4 23.8 236 25.8 26.3 266 26.5 26.7 26.8 278 288 289 Apr 14.2 13.8 140 14.3 161 17.4 17.5 17.8 18.4 21.9 23.8 23.9 23.6 25.8 26.4 26.6 26.8 26.7 269 273 289 290 29.5 298 302 240 235 254 265 266 26.9 267 268 Jun 14.1 13.8 14.1 14.7 16.3 17.5 17.6 18.1 18.7 220 24.1 23.9 238 259 265 26.8 26.9 26.7 272 28.1 28.9 29.1 296 29.8 302 18.1 20 2 225 245 238 24.3 163 17.5 175 179 18.5 21.9 23.9 238 23.7 259 264 26.7 26.9 267 270 28.0 28.9 29.0 295 29.0 302 16.4 174 177 18.1 198 222 24.4 237 24.1 25.5 26.7 26.8 26.9 263 274 283 290 292 29.6 30.0 303 51 1952 52 1953 53 1954 54 1955 55 1956 56 1957 57 1958 58 1959 59 1960 60 1961 265 Rato Cost of Dec Annual IPhone 6s This Year CPI: Previous Year CP Annual Indiation Rate 14.0 14.1 140 139 14,1 14.0 15 5 147 16.9 163 174 173 170 176 18.2 18.0 19.5 234 24.1 24,1 23.5 238 25.0 241 265 260 267 265 26.9 26 26.7 269 26.8 26 276 272 284 281 289 28 29.4 29.1 29.8 29,6 30.0 29.9 3041 2021 269 26.7 26.8 26.7 26.9 26.9 26.8 273 283 289 292 29.6 17.7 181 213 231 242 23.8 24.7 264 26.7 26.9 268 269 27,5 28.4 29.0 29.4 29.8 30.0 304 23.7 24,6 26.2 26.7 270 268 269 275 283 28.9 29.4 29.8 300 304 276 21.1 26.9 26.8 269 274 28.3 289 293 29.6 30.0 304 28.6 290 286 28.9 29.4 29.8 30.1 29.9 298 30.0 #4 CPI 301 30.3 + Type here to search O IT lije G H Consumer Price Index - All Urban Consumers 2 Original Data Value M N 0 This problem uses Consumer Price Index (CPI) data from the 0.5 Bureau of Labor Statistics (BLS from 1913 to 2015. Note the years may be hidden scroll to go all the way back to 1913 4 Series Id: CUURDOOSAD 5 Not Seasonally Adjusted 6 Area: U S city average 7 Item: All Rems Base 198284-100 8 Period: 9 Years: 1913 to 2015 10 Ratio Dec Annual Inflatt May 30.5 30.9 31.4 32.9 11 Year 62 1963 63 1964 64 1965 65 1966 66 1967 67 1968 68 1969 69 1970 70 1971 71 1972 72 1973 23 1974 74 1975 75 1976 76 1977 7.1978 78 1979 79 1980 80 1981 81 1982 82 1983 83 1984 84 1985 RS 1986 86 1987 Jan Feb 30.4 304 30.9 309 312 312 31:8 320 32.9 34.1 342 35.6 35 8 378 380 39,8 39.9 41.1 42.6 42.9 466 472 52.1 52.5 55.6 558 58 5 591 625 629 683 69.1 77.8 78.9 870 879 94.3 946 978 97.9 101.9 105.5 1060 109.3 1112 1116 #4 CPI Mar 305 30.9 31.3 32.1 33.0 343 361 382 40.0 41.4 433 478 527 55.9 59.5 634 69 8 801 Apr 30.5 30.9 31.4 323 33.1 344 363 38.5 40.1 415 43.6 48.0 529 332 345 36.4 386 40.3 416 43.9 486 53.2 56.5 60.3 Jun 30.6 31.0 31.6 32.4 33.3 34.7 36.6 38.8 406 41.7 442 49.0 536 568 607 65.2 723 827 90 6 Jul 30.7 31.1 31.6 325 33.4 349 368 39.0 40.7 41.9 443 49.4 542 571 610 65.7 444 Aug 30.7 31.0 316 327 33.5 35.0 37.0 39.0 40.8 420 45.1 500 543 574 612 66 0 738 83.3 923 97.7 1002 104.5 108.0 1097 1144 Sep 30.7 31.1 316 327 33.6 35.1 37.1 392 40.8 421 452 506 54.6 57.6 614 66.5 Oct 30.8 31.1 31.7 32.9 33.7 353 373 39.4 40.9 423 456 51.1 54.9 57.9 616 67.1 752 84.8 934 98.2 1010 105.3 1067 1103 1153 Nov 30 8 312 317 329 338 35.4 375 39.6 409 424 459 515 55.3 58.0 61.9 67.4 75.9 855 93.7 98.0 1012 1053 109.0 110.4 115.4 Cost of Annual iPhone 6s This Year CPI: Previous Year CPL 30.9 30.6 312 31.0 31.8 31.5 329 32.4 339 334 35.5 34,8 37.7 367 39.8 38.8 41.1 40.5 425 41.8 462 51.9 493 56.5 538 582 56.9 62.1 606 677 65.2 76.7 726 86.3 824 940 90.9 976 96.5 101.3 99.6 105.3 1039 1093 107.6 1105 109.6 115.4 561 645 73.1 746 885 600 63.9 70.6 81.0 89.1 94.9 98.6 103.1 1069 108.6 1127 970 94.5 97.9 1026 106.4 1088 112.1 715 81.8 89.8 95.8 992 103 4 107.3 108 9 827 91.6 975 99.9 1041 1024 99.5 1037 1076 1095 1135 84.0 932 979 100.7 105.0 108.3 1102 115.0 1018 1096 1095 113.8 A Type here to search O M o This problem uses Consumer Price Index (C) data from the US. Bureau of Labor Statistics (85) from 1913 to 2015. Note the years may be hidden scroll to go all the way back to 1913, 1 Consumer Price Index - All Urban Consumers 2 Original Data Value 3 4 Series Id:CUUROOOOSAO 5 Not Seasonally adjusted 6 Area: US city 7 Items All items Base 1982 81-100 8 Period 9 Years 1913 to 2015 10 Des 13 Year 87 1988 88 1989 89 1990 90 1991 91 1992 92 1993 93 1994 Mar 1165 1223 128.7 Jun 1180 1241 1299 136.0 140.2 Jul 118.5 1244 1304 1362 1405 1444 1350 148 4 1586 944 1995 95 1996 95 1997 97 1998 98 1999 99 2000 100 2001 101 2002 102 2003 103 2004 104.2005 105 2006 106 2007 107 2008 108 2009 100 2010 110 2011 111 7012 Jan Feb 115.7 116.0 121.1 121.6 127.4 1280 1346 1348 138.1 1386 1426 1431 1462 1467 1503 150.9 154.4 154.9 1591 159.6 1616 1619 1643 164.5 1688 1698 175 1 175.8 1771 177.8 1817 183.1 1852 1862 190.7 1918 1983 198.7 202.4 2035 2111 211.7 211,1 2122 2167 2167 220.2 2213 2267 2277 N4 CPI 1393 143.6 1472 1514 155.7 160.0 1622 1650 1712 1752 1788 1842 1874 1933 1998 205.4 213.5 212.7 2176 2235 Apr 117.1 123.1 128.9 1352 139.5 144.0 1474 151.9 156.3 1602 1525 1662 1713 1769 1798 1838 188.0 1946 2015 2067 2148 2132 218.0 2249 2301 May 117.5 1238 1292 1356 139.7 1442 147.5 1522 156.6 160.1 162.8 1662 1715 177.7 179.8 183,5 1891 1944 2025 2074 2166 213.9 2182 2260 229.8 148.0 152.5 1567 160.3 1630 1662 172.4 1780 1799 183.7 189.7 1945 2029 208.4 218.8 2157 2180 1525 1570 160.5 1632 1667 1728 1775 1801 1839 1894 1954 Aug 1190 1246 1316 136.6 140.9 1448 1490 1529 157.3 1608 163.4 167.1 1728 1775 1807 184.6 1895 196.4 203.9 207.9 219.1 2158 2183 2265 2304 Sep 119,8 1250 1327 1372 1413 145.1 1494 1532 1578 1612 1636 1679 1737 178.3 181.0 1852 1899 1988 2029 208.5 2188 2160 2184 226.9 2314 Oct 120 2 1256 133.5 1374 141.8 1457 149.5 1537 1583 1616 1640 1682 1740 1777 1813 185.0 190.9 1992 2018 2009 216.6 2162 218.7 226.4 2313 Nov 120.3 125.9 1338 1378 142.0 145.8 149.7 153.6 1586 1615 1640 1683 174.1 1774 181.3 1845 191.0 1976 2015 2102 2124 216.3 218.8 226.2 2302 Ratio Cost of Annual IPhone 6s This Year CP1 : Previous Year CPI Annual Inflation R 120.5 118.3 1261 1240 133.8 130 1379 136.2 1419 1403 145.8 1445 149.7 1482 1535 1524 156.9 161.3 160.5 163.9 163.0 168 166.6 174.0 1722 176.7 1721 1803 179 1843 1840 190.3 188.9 1953 2018 2016 2100 2073 2102 2153 2159 214.5 219 2 2181 225.7 224.9 2296 2296 1968 2035 2083 2200 215 4 2180 225.9 229.1 229.5 Type here to search DI O This problem uses Consumer Price Index (CPI) data from the U.S. Bureau of Labor Statistics (BLS) from 1913 to 2015. Note the years may be hidden scroll to go all the way back to 1913. LUNSUNel Plce ex-All Urban Consumers 2 Original Data Value 3 4 Series Id: CUUROOOOSAO 5 Not Seasonally Adjusted 6 Area: US city average 7 Item: All items Base 1982-84 100 8 Period: 9 Years: 1913 to 2015 10 Anne Aug 177.5 180.7 1946 11 Year 100 2001 101 2002 102 2003 103 2004 104/2005 105 2006 106 2007 107 2008 108 2009 109 2010 110 2011 111 2012 112 2013 113 2014 114 2015 115 116 117 Jan 175.1 177.1 181.7 1852 190.7 1983 202.4 211.1 211.1 216.7 220.2 2267 2303 2339 2337 Feb 175.8 1778 183.1 1862 191.8 1987 2035 211.7 2122 216.7 2213 2277 2322 2348 234.7 Mar 1762 178.8 1842 1874 1933 199.8 2054 2135 2127 2176 2235 2294 232.8 2363 236 1 Apr 176 9 1798 1838 1880 1946 2015 2067 2148 213.2 218.0 224.9 230.1 232.5 237.1 236.6 May 177.7 179.8 183.5 189 1 194.4 202.5 207.9 216.6 213.9 2182 2260 229 8 2329 2379 2378 Jun 178.0 1799 183.7 189.7 194.5 202.9 2084 218.8 215.7 218.0 225.7 229.5 233.5 238.3 238.6 Jul 1775 180.1 183.9 189.4 1954 203.5 208 3 220.0 215.4 218.0 225.9 229.1 233.6 238.3 238.7 189.5 1964 2039 207.9 219.1 2158 2183 226.5 2304 233.9 2379 2383 Sep 178.3 181.0 1852 1899 1988 202.9 208 5 218.8 216.0 218.4 226.9 231.4 234 1 2380 2379 Oct 1777 1813 1850 1909 1992 201.8 2089 2166 2162 2187 2264 2313 233.5 2374 237.8 Nov 1774 181.3 184.5 191.0 1976 2015 2102 212.4 216.3 218 8 2262 230 2 233.1 2362 2373 Dec 176.7 180.9 184.3 190.3 1968 201.8 210.0 210.2 2159 219 2 2257 229.6 233.0 2348 236.51 Ratio Cost of Annual iPhone 6s This Year CP1 : Previous Year CPI 1771 179.9 184 0 188.9 195.3 2016 2073 215.3 214.5 218.1 224.9 229.6 233.0 236.7 237.05 649.00 118 119 120 121 122 123 124 4 CPI Type here to search O vid General Sha AutoSum Merge Center $ % 4 O 4 Insert Delete Format Conditional Format as Cell Formatting Table Styles Styles Alignment Clear Sort Find & Filter Select Ideas Number Cels Editing Ideas B W AR AC AD AE AF AG AH y Z AA a.) Use the annual CPI values to convert the given cost of an Phone 6s in 2015$ into every other years' dollars. Assuming the iPhone 6s existed back then of course. How did people communicate without cell phones? A AJ b.) Take the ratio of each year's annual CPI to the previous value and scale the second quantity to 1 by simply dividing the two values. Note: parts ce below! annual Inflation Rate c.) Compute the annual inflation rate by subtracting 1 from the ratio from partc. Formatas percentage to 2 decimal places. Max Inflation year: d.) In what year did inflation increase the most? Note there is a way to get Excel to do this for you. First find MAX annual inflation rate. Then use MATCH to find which value this is in the column for inflation rates: 1,2,3... Then you can use INDEX to pull the year from this row, or just find it yourself! Always up? e.) Does inflation always increase from year to year? Answer should be yes or no