Hi, When using excel would I be using this formula for the Slope on this assignment =SLOPE(G29:G34,I29:I34) and for the intercept =INTERCEPT(G29:G34,F29:F34). I feel like I have it backward or I am doing it wrong. I added the picture of the excel spreadsheet.

G H Budget Cost Projection 3 a Below, you will generate a 5-year projected cost for your budget, starting with your budget total. You will base your projection on CPI values that you look up. Use this procedure to look up the CPI value: 1. Go to Bureau of Labor Statistics page link https://data.bls.gov/cgi-bin/surveymost?cu (CPI Values) 2. Check the box to the left of text "U.S. city average, All items - CUUROOOOSAO" 3. Press the "Retrieve Data" button at the bottom of the list. This should take you to a CPI table for about the last 10 years. First, fill in the CPI value for the given month and year. Then, fill in the CPI values for the next 6 years, advancing exactly one year for each value. For example, if you start in February 2011, your next CPI value will come from February 2012. Format your CPI values as Numbers Year Number CPI Value Month Year 1 223.467 3 2011 229.392 2012 W N 232.773 2013 4 236.293 3 2014 5 236.119 3 2015 6 238.132 2016 3 b Now, from the year number and CPI values, find the slope and y-intercept of the best-fit line for your CPI values. Slope (m) 2.772171429 Y-Intercept (0, b) 222.9934