Question

1 Approved Answer

Posted on Sep 10, 2024

gtq1eU 2.4 cpixisx-Excel ALeyto, Frances Jihan-0 A Leyro, Frances Jihan AutoS Insert Draw Page Layout Formulas Data Review ViewHelp Tell me what you want to

image text in transcribed

gtq1eU 2.4 cpixisx-Excel ALeyto, Frances Jihan-0 A Leyro, Frances Jihan AutoS Insert Draw Page Layout Formulas Data Review ViewHelp Tell me what you want to do AutoSum A Cut Copy . Format Painter General : Conditional Format as Cell Formatting Table Styles Insert Delete Format Sort &Find & B | u . m. | FEE Merge & Center . $ . % , ClearFilter Select Clipboard Font Alignment Number Cells Editing 012 1 Consumer Price Index All Urban Consumers 2 Original Data Value 4 Series ld: CUUR0000SA0 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 a.) Use the annual CPI val every other years' dollars. people communicate Not Seasonally Adjusted 6 Area: 7 Item: U.S. city average Base 1982-84-100 8 Period: b.] Take the ratio of each quantity to 1 by simply d 1913 to 2015 Years: 10 Cost of 11 Year Jan Feb Mar AprMayJunJ Aug Sep Oct No Dec Annual iPhone 6s This Year CPI: Previous Year CP Annual Inflation Rate 12 1913 13 1914 9.8 0.0 9.9 9.9 9.8 9.9 9.9 10.0 10010210.1 0.1 10.0 9.9 10.0 10.1 10.1 10.1 10.1 10.1 10.2 10.3 10.3 10.1 10.4 10.4 10.5 10.6 10.7 10. 10.810.9 11.1 11.3 115 11.6 10.9 11.7 12.02.022. 3.0 2.8 3.0 13.3 13.5 13.5 13.712.8 40 14.1 14.0 14.2 14.5147151 15.4 6.5 16.2 16.4 16.7 16.9 169 17.4 17.7 17.8 18.1 18.5 18.9 17.3 9.3 19.5 19.7 20.3 20.6 20.9 20.820 20.0199 19.8 19.4 19.0 18.48.18. 7 7. 7.7 17.7 175 17.5 17.4 17.317.9 6.9 16.9 16.7 16.7 16.7 16.7 68616.6 167 16.8 16.9 16.8 16.8 168 16.9 16.9.0 72 17. 172 7.3 717. 17.3 17.2 7.170 7.07.0 17.1 17.0 17.1 17. 72 17.3 17. 7.3 17.2 17.3 17.2 17.3 17.5 17.7 17.7 17.7 17.7 18.0 179 17.5 17.9 17.97879777 17.5 17.4 17.5 17.6 177 17.7 17.7 9.8 9.8 9.8 9.7 9.8 9.9 9.9 10.00.0 1010.0 9.9 15 1916 16 1917 17 1918 18 1919 19 1920 20 1921 21 1922 15.7 16.0 16.3 16.5 15.1 23 1924 24 1925 25 1926 #4 CPI Ready +90% 9:37 PM 3/9/2019 0V AutoS gtq1eU 2.4cpi.xlsx-Exce A Leyro, Frances Jihan -0 Insert Draw Page Layout Formulas Data Review ViewHelp Tell me what you want to do AutoSum , A Fill Cut 1A A | . . Wrap Text General Paste Copy % , | conditional Fommatas Cell Insert Delete Format Sort &Find & 1 u . Merge & Certer. $. ClearFilter Select Format Painter Formatting Table Styles Styles Clipboard Font Alignment Number Cells Editing 012 x9.8-9.8)/9.8 Ul 1 sConsumer Price Index (CPI) data from the U.S. Bureau of Labor om 1913 to 2015. Note the years may be hidden, scroll to go all the way a.) Use the annual CPI values to convert the given cost of an iPhone 6s in 2015$ into every other years' dollars. Assuming people communicate without cell phones? the iPhone 6s existed back then of course. How did 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 c-e below! 10 Cost of 11 Nov Dec Annual iPhone 6s This Year CPI: Previous Year CPI Annual Inflation Rate 12 10.1 10.0 13 1 10.0 14 10.310.310.1 15 11.5 11.610.9 16 17 16.3 16.5 15.1 9.9 0.2 10.1 13.5 13.7 2.8 18.5 18.97.3 19 19.8 19.4 20.0 20 17.417.317.9 2116.8 16.9168 17.317.317.1 23 17.2 17.3 17.1 24 18.0 17 17.5 25 17.717.7 17.7 #4 CPI Ready +90% 9:37 PM 3/9/2019 gtq1eU 2.4 cpixisx-Excel ALeyto, Frances Jihan-0 A Leyro, Frances Jihan AutoS Insert Draw Page Layout Formulas Data Review ViewHelp Tell me what you want to do AutoSum A Cut Copy . Format Painter General : Conditional Format as Cell Formatting Table Styles Insert Delete Format Sort &Find & B | u . m. | FEE Merge & Center . $ . % , ClearFilter Select Clipboard Font Alignment Number Cells Editing 012 1 Consumer Price Index All Urban Consumers 2 Original Data Value 4 Series ld: CUUR0000SA0 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 a.) Use the annual CPI val every other years' dollars. people communicate Not Seasonally Adjusted 6 Area: 7 Item: U.S. city average Base 1982-84-100 8 Period: b.] Take the ratio of each quantity to 1 by simply d 1913 to 2015 Years: 10 Cost of 11 Year Jan Feb Mar AprMayJunJ Aug Sep Oct No Dec Annual iPhone 6s This Year CPI: Previous Year CP Annual Inflation Rate 12 1913 13 1914 9.8 0.0 9.9 9.9 9.8 9.9 9.9 10.0 10010210.1 0.1 10.0 9.9 10.0 10.1 10.1 10.1 10.1 10.1 10.2 10.3 10.3 10.1 10.4 10.4 10.5 10.6 10.7 10. 10.810.9 11.1 11.3 115 11.6 10.9 11.7 12.02.022. 3.0 2.8 3.0 13.3 13.5 13.5 13.712.8 40 14.1 14.0 14.2 14.5147151 15.4 6.5 16.2 16.4 16.7 16.9 169 17.4 17.7 17.8 18.1 18.5 18.9 17.3 9.3 19.5 19.7 20.3 20.6 20.9 20.820 20.0199 19.8 19.4 19.0 18.48.18. 7 7. 7.7 17.7 175 17.5 17.4 17.317.9 6.9 16.9 16.7 16.7 16.7 16.7 68616.6 167 16.8 16.9 16.8 16.8 168 16.9 16.9.0 72 17. 172 7.3 717. 17.3 17.2 7.170 7.07.0 17.1 17.0 17.1 17. 72 17.3 17. 7.3 17.2 17.3 17.2 17.3 17.5 17.7 17.7 17.7 17.7 18.0 179 17.5 17.9 17.97879777 17.5 17.4 17.5 17.6 177 17.7 17.7 9.8 9.8 9.8 9.7 9.8 9.9 9.9 10.00.0 1010.0 9.9 15 1916 16 1917 17 1918 18 1919 19 1920 20 1921 21 1922 15.7 16.0 16.3 16.5 15.1 23 1924 24 1925 25 1926 #4 CPI Ready +90% 9:37 PM 3/9/2019 0V AutoS gtq1eU 2.4cpi.xlsx-Exce A Leyro, Frances Jihan -0 Insert Draw Page Layout Formulas Data Review ViewHelp Tell me what you want to do AutoSum , A Fill Cut 1A A | . . Wrap Text General Paste Copy % , | conditional Fommatas Cell Insert Delete Format Sort &Find & 1 u . Merge & Certer. $. ClearFilter Select Format Painter Formatting Table Styles Styles Clipboard Font Alignment Number Cells Editing 012 x9.8-9.8)/9.8 Ul 1 sConsumer Price Index (CPI) data from the U.S. Bureau of Labor om 1913 to 2015. Note the years may be hidden, scroll to go all the way a.) Use the annual CPI values to convert the given cost of an iPhone 6s in 2015$ into every other years' dollars. Assuming people communicate without cell phones? the iPhone 6s existed back then of course. How did 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 c-e below! 10 Cost of 11 Nov Dec Annual iPhone 6s This Year CPI: Previous Year CPI Annual Inflation Rate 12 10.1 10.0 13 1 10.0 14 10.310.310.1 15 11.5 11.610.9 16 17 16.3 16.5 15.1 9.9 0.2 10.1 13.5 13.7 2.8 18.5 18.97.3 19 19.8 19.4 20.0 20 17.417.317.9 2116.8 16.9168 17.317.317.1 23 17.2 17.3 17.1 24 18.0 17 17.5 25 17.717.7 17.7 #4 CPI Ready +90% 9:37 PM 3/9/2019