# MAT 144 Major Assignment 2

Question # 00796208 Posted By: 95 Updated on: 03/01/2021 06:50 AM Due on: 03/27/2021
Subject Mathematics Topic General Mathematics Tutorials:
Question

This  assignment uses a scoring guide. Review the scoring guide on the last  tab of the spreadsheet prior to beginning the assignment to become  familiar with the expectations for successful completion.

Please note that the Confidence Interval Explanation document is provided for reference and assistance with Major Assignment 2.

 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