# Mathematics

 Part 1 Requirements: Answer each question fully. Use Excel formulas with cell references. Answers must be recorded on the worksheet. Possible points Points earned Comments Five year inflation rate 10 Projection of expenses in Worksheet 1 10 Part 1 total 20 0 Part 2 Requirements: Answer each question fully. Use Excel formulas with cell references. Answers must be recorded on the worksheet. Possible points Points earned Comments Descriptive Statistics 16 Interpret Descriptive Statistics 14 Proportion calculations 10 Interpretation of proportions 10 Conversion of before well 5 Conversion of after well 5 Improvement level data set 5 Descriptive Statistics for improvement levels 10 Histogram 5 Standard error of the mean 5 Confidence interval 10 Discussion of the placement of 0 10 Part 2 total 105 0 Total of Worksheet 2 125 0 0%

## Part 1 Inflation

 Input your name here name You should just use information from Major Assignment 2, but if you want to retrieve fresh CPI data, here are the instrructions again. Step 1: Go to the Bureau of Labor Statistics website at the link below. Step 2: Check U.S. All items, 1982-84=100 Step 3: Click “Retrieve Data” Use the most recent CPI value and the CPI for the same month but five years earlier to estimate the price of your trip in five years and the five year inflation rate. Month Year CPI Unadjusted CPI, all items for 5 years ago number number number Unadjusted CPI, all items for last month number number number What is the 5 year inflation rate, that is percent increase in your CPI values? formula If something cost \$1.00 five years ago, what would it cost now? formula Total budget from Worksheet 1 number 5 year projected budget total formula CPI Data Link Like Topic 4 DQ 1

https://data.bls.gov/cgi-bin/surveymost?cu