Description
Answer directly on the worksheet.
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.
Unformatted Attachment Preview
Purchase answer to see full attachment
Explanation & Answer
Please find the final version of the document attached above and let me know whether all is well with the work.
Part 1
Requirements: Answer each question fully. Use Excel formulas with cell references. Answers must be recorded o
Possible points
Points earned
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 o
Possible points
Points earned
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
t1
references. Answers must be recorded on the worksheet.
Comments
t2
references. Answers must be recorded on the worksheet.
Comments
0%
Input your name here
name
Part 1 – Budget Projection:
Your friends have decided to delay your dre
Month
Year
CPI
Unadjusted CPI, all items for 5 years ago
December
2013
251.233 and you need to estimate what the cost of y
Unadjusted CPI, all items for last month
December
2018
233.049 Step 1: Go to the Bureau of Labor Statistics
bin/surveymost?cu.
Step 2: Check U.S. All items, 1982-84=100
Inflation rate: something that cost $1.00 five
$
1.07
Step 3: Click "Retrieve Data"
years ago would cost what now?
What percent increase is this?
7% Use the most recent CPI value and the CPI f
Total budget from Worksheet 1
$7,500 estimate the price of your trip in five years
5 year projected budget total
$8,085.20
dget Projection:
s have decided to delay your dream vacation from Worksheet 1 for five years,
ed to estimate what the cost of your trip will be by then.
to the Bureau of Labor Statistics website at https://data.bls.gov/cgimost?cu.
eck U.S. All items, 1982-84=100
k "Retrieve Data"
ost recent CPI value and the CPI for the same month but five years earlier to
he price of your trip in five years and the five year inflation rate.
Before wells
were dug Millions of
E.Coli per ml
23
21
64
54
72
50
52
49
55
73
55
51
38
28
60
57
59
60
61
57
71
57
63
64
63
23
21
64
54
72
50
52
49
55
73
55
51
38
28
After wells
were dug Mill...