What is best way to find out cost of iPhones, CPI, and annual inflation rate? It ranges from 1913 to 2015. However they do list the cost of iPhone in 2015 which is $649.00. Im new to excel and not understanding what formula I will need for each cell.

Consumer Price Index All Urban Consumers Original Data Value This problem unes Conoumer Price Index (C) data from she U.S Buress of Labor Stationcs (ouS) from 1913 to 2015 Note the years ay be hiden, screl to go all t wy back 0 1913 prars dollars Assuming the iPhon wthout ell phones? S Not Seasonaly Adusted tem b) Take the neie of esch year's ann ty simply dividing the twe values. Not s Period 9 Years: -1513 to 2015 Cest of 152 1447 142 14741475 1480184 5361535 14 154 4 1549 1567 4 ) 1566 156 7 tS29 1573: 157 ' 1583 1586 150 16011603 S960 1612 1616 159150 021 1615 113 1443 6451662 164 1751 175 8 162 749 777 18 177 177 178 17171774 1767 1817 1831 1042 1831837 183 9 1 619 %2 2 162 S 1028 1030 ,63 2: 163 4: 1636-1940-1610 163 9667 1671 16981T12 1731724 1728 1728 737 174 177 178 19179 1799180 1100 7 110 1813 ) anwt, the m..ntnon rate by percentnge to 2 decimal praces 1 10 345 1043 1909 1911 192ars 307198201 22029203s 2 92013 2015 201 2035 2054 207 20200203 22902 210 2135 2148 2164 218 2111 2122 127 2132 21392157 2154215s 21 2142 211 2 2.0: 210, 210, 2,4 294 , 210. 2 221 22 201 229229 2304 2314233202 2 Consumer Price Index All Urban Consumers Original Data Value This problem unes Conoumer Price Index (C) data from she U.S Buress of Labor Stationcs (ouS) from 1913 to 2015 Note the years ay be hiden, screl to go all t wy back 0 1913 prars dollars Assuming the iPhon wthout ell phones? S Not Seasonaly Adusted tem b) Take the neie of esch year's ann ty simply dividing the twe values. Not s Period 9 Years: -1513 to 2015 Cest of 152 1447 142 14741475 1480184 5361535 14 154 4 1549 1567 4 ) 1566 156 7 tS29 1573: 157 ' 1583 1586 150 16011603 S960 1612 1616 159150 021 1615 113 1443 6451662 164 1751 175 8 162 749 777 18 177 177 178 17171774 1767 1817 1831 1042 1831837 183 9 1 619 %2 2 162 S 1028 1030 ,63 2: 163 4: 1636-1940-1610 163 9667 1671 16981T12 1731724 1728 1728 737 174 177 178 19179 1799180 1100 7 110 1813 ) anwt, the m..ntnon rate by percentnge to 2 decimal praces 1 10 345 1043 1909 1911 192ars 307198201 22029203s 2 92013 2015 201 2035 2054 207 20200203 22902 210 2135 2148 2164 218 2111 2122 127 2132 21392157 2154215s 21 2142 211 2 2.0: 210, 210, 2,4 294 , 210. 2 221 22 201 229229 2304 2314233202 2