Math 144 worksheet 2

Grading Sheet
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
Part 2 Questions 1-3
Before wells were dug - Millions of E.Coli per ml After wells were dug - Millions of E.Coli per ml YOUR NAME: Joe Lope Part 2 – Data Analysis: Enter your name in cell F1 to generate data. You have just completed a mission to Sierra Leone. The goal of the mission was to improve the quality of water in 100 wells in a certain region. You collected data on the E. coli count from each well before and after your mission. You need to write a report on the success of the mission and for that you need to perform some statistical analysis on the data. You will be looking at the data from different perspectives to determine if the water quality has improve. Original Before Data Original After Data Random n