# MATH 144 Grand Canyon University Assignment 2 Worksheet Assignment

User Generated

Puevfglenira

MATH 144 COLLEGE MATH

gcu

## Description

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.

Attachments Major Assignment 2.xlsx
MAT 144 ConfidenceIntervalExplanation.xlsx

Attempt Start Date: 01-Apr-2019 at 12:00:00 AM

Due Date:

07-Apr-2019 at 11:59:59 PM

Check out this article to see the impact of understanding math had to do with the recent housing crisis.

Hello Class,

Check out this article to see the impact of understanding math had to do with the recent housing crisis.

http://money.cnn.com/2013/06/25/real_estate/mortgage-math/

User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

The solution is attached. Please, give me feedback.

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.

t2
references. Answers must be recorded on the worksheet.

0%

Joe Lope

Unadjusted CPI, all items for 5 years ago
Unadjusted CPI, all items for last month
What is the 5 year inflation rate, that is
percent increase in your CPI values?
If something cost \$1.00 five years ago, what
would it cost now?
Total budget from Worksheet 1
5 year projected budget total

Month
Feb
Feb

Year
2014
2019

You should just use information from Major
CPI
234.781 retrieve fresh CPI data, here are the instrruc
252.776 Step 1: Go to the Bureau of Labor Statistics w
Step 2: Check U.S. All items, 1982-84=100
Step 3: Click "Retrieve Data"
8%
Use the most recent CPI value and the CPI fo
earlier to estimate the price of your trip in fi
\$1.08 rate.
number
formula

Like Topic 4 DQ 1

just use information from Major Assignment 2, but if you want to
esh CPI data, here are the instrructions again.
to the Bureau of Labor Statistics website at the link below.
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
stimate the price of your trip in five years and the five year inflation

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 Millions of
E.Coli per ml
52
3
35
44
49
35
38
10
32
52
17
37
26
0
44
40
30
42
34
33
50
40
38
43
52
0
3
35
44
49
35
38
10
32
52
17
37
26
0

Joe Lope

Before
min = 21
max = 73
mean= 54.28
SD = 13.55
# of wells tested = 100
# of wells with 0 E coli = 0
Ratio
Percent Clean
Conversions
ml
29.5735
In 24 ounces
E.coli before
16324.5883 million

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
60
57
59
60
61
57
71
57
63
64
63
23
21
64
54
72
50
52
49
55
73
55

44
40
30
42
34
33
50
40
38
43
52
0
3
35
44
49
35
38
10
32
52
17
37
26
0
44
40
30
42
34
33
50
40
38
43
52
0
3
35
44
49
35
38
10
32
52
17

51
38
28
60
57
59
60
61
57
71
57
63
64
63

37
26
0
44
40
30
42
34
33
50
40
38
43
52

After
min =
max =
mean=
SD =
# of wells tested =
# of wells with 0 E coli =
Before
0

versions
oz
1

4 ounces
E. coli after
36907.7649 million

Part 2 – Data Analysis:
Enter your name in cell F1 to generate data
You have just completed a mission to Sierra
quality of water in 100 wells in a certain reg
well before and after your mission. You nee
for that you need to perform some statistic
from different perspectives to determine if
0
52
33.48
15.04
100.00
7
After
0.075268817

Recall Topic 1 DQ 2

1. Calculate descriptive statistics for your da
the statistics including mean, max and sta
there has been improvement in water qual
statistics to obtain full marks. (Fill in the b
descriptive statistics. The data has been nam
formulas.)

Answer Question 1 here: There appear to b
E.Coli concentration (E.Coli per ml) after tr
(54.28). Also, before treatment, no well ha
wells had E.Col concentration of 0.

2. The water quality is “good” if the count o
Calculate the proportion of wells with “goo
measure does it appear that the quality of
you calculated. (In G11 and H11 calculate th

Answer Question 2 here: Yes, it appears th
ratio of wells with "good" water to wells w
this ration increased to 0.075. Thus, it does

3. Look at well #1 (B2 and C2) in your data.
ingest if you drank from the well before the
how many E.coli would you ingest if you dra
after the mission.)

ata Analysis:
r name in cell F1 to generate data.
ust completed a mission to Sierra Leone. The goal of the mission was to improve the
water in 100 wells in a certain region. You collected data on the E. coli count from each
e and after your mission. You need to write a report on the success of the mission and
ou need to perform some statistical analysis on the data. You will be looking at the data
rent perspectives to determine if the water quality has improve.

e descriptive statistics for your data in the table provided in the Excel spreadsheet. Use
ics including mean, max and standard deviations of the data to decide if it appears if
been improvement in water quality? This requires a thorough discussion of these
o obtain full marks. (Fill in the before (F3:F8) and after (H3:H8) tables to the left for the
e statistics. The data has been named before and after for your convenience in creating

uestion 1 here: There appear to be improvement in the water quality. The average
centration (E.Coli per ml) after treatment (33.48) is less than that before treatment
lso, before treatment, no well had zero (0) E.Coli concentration but after treatment 7
E.Col concentration of 0.

er quality is “good” if the count of E coli is 0; otherwise, the water quality is still bad.
the proportion of wel...

### Review

Anonymous
This is great! Exactly what I wanted.

Studypool
4.7
Indeed
4.5
Sitejabber
4.4