AutoSave Off Topic_2_DQ 2 Saved to this PC Search File Home Insert Draw Page Layout Formulas Data Review View Help Baguet Script 11 A A = Wrap Text Paste B I U v A Merge & Center General $ Clipboard Font Alignment Asayyad hira fatima Comments 0 Share AutoSum T T Fill Conditional Format as Cell Formatting Table Styles Insert Delete Format Sort & Find & Add-ins Analyze Clear Filter Select Data Styles Cells Editing Add-ins % 4000 Number C2 fx Your Name Here A D 1 2 E F G Enter your name in C2 Your name Here At least five letters. 3 4 5 Part 1: Using the CPI values from the website below, find the inflation rates for the indicated time period. 6 1. Go to Bureau of Labor Statistics page link https://data.bls.gov/cgi-bin/surveymost?cu CPI Values 7 2. Check the box to the left of text "U.S. city average, All items - CUUR0000SA0" 8 3. Press the "Retrieve Data" button at the bottom of the list and a table of CPI values will appear. 9 4. Record your CPI values in the green cells. 10 5. Find the 3-Year and 1-Year Inflation Rates based on the CPI values. 11 6. Format CPI values as Numbers with 3 decimal places and the inflation rates as a percentage with 2 decimal places. 12 13 14 15 Enter Your Name in C2 16 Enter Your Name in C2 Enter Your Name in C2 Enter Your Name in C2 Enter Your Name in C2 New/Original - 1 Enter Your Name in C2 New/Original - 1 17 18 Video Explanation Enter Your Name in C2 19 19 20 20 March 2017 Hourly Rate (P) Enter Your Name in C2 21 22 Projected Weekly Income 23 P*(1+r) Enter Your Name in C2 P*(1+r) Projected Weekly Income Goals and Instructions Inflation Rate & Projection + Ready ux 1 31F Accessibility: Investigate Sunny Q Search H Legend If a cell is shaded Blue Green You should Enter a text Enter a number Gold Any other color Enter an Excel Make no changes (DELL) to. K L M N 2 + 100% 11:17 AM 1/25/2024