Essay Grade

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%
To prepare for the final project:
This part of the assignment is not graded, an
your final Mission Trip project.
Your Mission Trip will occur in 5 years, so yo
be able to do the 5 year projections of your M
You should also be filling in the details of you
from the Mission Trip assignment:
• An overview of your project: Where are g
be the sole purpose of your trip.
• Cultural and social aspects of the country
• How your choice of project works toward
yourself: How does your personal worldv
plans for the trip?
• Information about your target population
population of the country as a whole?
• Aspects of the country that make it a suit
• The economic situation in your co
• Possible concerns that you need t
could be safety from violence or f
final project:
ignment is not graded, and you will not hand it in at this time. It is here to help you stay on track for
Trip project.
will occur in 5 years, so you will need to make budget projections into the future. By now, you should
year projections of your Mission Trip budget.
filling in the details of your narrative. If asked, you should be able to answer the following questions
rip assignment:
your project: Where are going, and what service will you be providing? Remember, evangelism cannot
pose of your trip.
cial aspects of the country and its population that led you to choose this area of the world.
e of project works toward fulfillment of the Judeo-Christian-Islamic ideal to love your neighbor as
oes your personal worldview and the possible worldviews of your target population influence your
out your target population: Who are you planning to serve? How does this population compare to the
he country as a whole?
ountry that make it a suitable location for your trip. In particular, include information about
nomic situation in your country and how your project will improve this.
e concerns that you need to keep in mind to keep your team and your target population safe. This
e safety from violence or from health problems (for example, will your team need inoculations to
Input your name here
name
Unadjusted CPI, all items for 5 years ago
Unadjusted CPI, all items for last month
Inflation rate: something that cost $1.00 five
years ago would cost what now?
What percent increase is this?
Total budget from Worksheet 1
5 year projected budget total
Month
number
number
Year
number
number
Part 1 – Budget Projection:
Your friends have decided to delay your drea
years, and you need to estimate what the cos
Step 1: Go to the Bureau of Labor Statistics w
bin/surveymost?cu.
Step 2: Check U.S. All items, 1982-84=100
formula
Step 3: Click “Retrieve Data”
formula Use the most recent CPI value and the CPI for
number estimate the price of your trip in five years an
formula
CPI
number
number
ction:
cided to delay your dream vacation from Worksheet 1 for five
o estimate what the cost of your trip will be by then.
eau of Labor Statistics website at https://data.bls.gov/cgi-
l items, 1982-84=100
e Data”
CPI value and the CPI for the same month but five years earlier to
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 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
YOUR NAME:
Joe Lope
Before
min = formula
max = formula
mean= formula
SD = formula
sample size = formula/number
0 count = formula/number
Ratio
Percent Clean
min =
max =
mean=
SD =
sample size =
0 count =
Before
formula
Conversions
ml
29.5735
oz
1
In 24 ounces
E.coli before
formula
E. coli after
formula
After
formula
formula
formula
formula
formula/number
formula/number
After
formula
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
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.
1. Calculate descriptive statistics for your data in the table provided in the Excel spreadsheet. Use the
means and standard deviations of the data to decide if it appears that there has been improvement in
water quality? (Fill in the before (F3:F8) and after (H3:H8) tables to the left for the descriptive statistics.
The data has been named before and after for your convenience in creating formulas.)
Answer here:
2. The water quality is “good” if the count of E coli is 0; otherwise, the water quality is still bad. Calculate
the proportion of wells with “good” water to wells whose water is not good. From this measure does it
appear that the quality of water improved? Explain and use the proportions that you calculated. (In G11
and H11 calculate the percent Clean for before and after.)
Answer here:
.
3. Look at well #1 (B2 and C2) in your data. If you drank 24oz of water how many E.coli would you ingest if
you drank from the well before the mission? After the mission? (In E19 and G19 calculate how many E.coli
would you ingest if you drank 24 oz. of water from Well 1 before the mission and after the mission.)
ou ingest if
many E.coli
Original
Before
Data
78
19
32
125
53
68
4
106
38
36
4
17
43
23
32
49
36
2
33
58
75
82
80
70
79
73
76
72
72
70
84
81
69
85
100
70
74
63
Original
After
Data
67
4
23
110
41
42
10
79
6
16
14
5
9
3
8
28
18
21
22
25
59
63
60
52
50
66
54
42
55
53
54
62
59
52
69
57
45
39
76
78
87
71
83
71
75
76
63
70
65
83
76
78
76
68
77
75
67
74
86
85
72
73
59
72
64
67
79
64
86
74
83
81
70
71
68
76
72
71
86
86
88
78
73
84
78
60
75
64
41
67
56
57
58
39
38
50
59
48
59
49
47
51
58
53
45
58
67
48
65
43
55
25
48
55
33
65
53
61
55
47
54
54
64
55
55
77
62
67
59
45
57
53
77
88
83
70
65
74
73
79
87
79
77
66
73
85
77
57
68
61
32
48
52
53
58
59
57
55
52
58
63
55
Random
seed
numbers
9
17
25
33
41
49
57
65
73
81
89
97
5
13
21
29
37
45
53
61
69
77
85
93
1
9
17
25
33
41
49
57
65
73
81
89
97
5
8
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
63
4
17
110
38
53
0
91
23
21
0
2
28
8
17
34
21
0
18
43
60
67
65
55
64
58
61
57
57
55
69
66
54
70
85
55
59
48
52
0
8
95
26
27
0
64
0
1
0
0
0
0
0
13
3
6
7
10
44
48
45
37
35
51
39
27
40
38
39
47
44
37
54
42
30
24
13
21
29
37
45
53
61
69
77
85
93
1
9
17
25
33
41
49
57
65
73
81
89
97
5
13
21
29
37
45
53
61
69
77
85
93
1
9
17
25
33
41
49
57
65
73
81
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
61
63
72
56
68
56
60
61
48
55
50
68
61
63
61
53
62
60
52
59
71
70
57
58
44
57
49
52
64
49
71
59
68
66
55
56
53
61
57
56
71
71
73
63
58
69
63
45
60
49
26
52
41
42
43
24
23
35
44
33
44
34
32
36
43
38
30
43
52
33
50
28
40
10
33
40
18
50
38
46
40
32
39
39
49
40
40
62
47
52
44
30
42
38
89
97
5
13
21
29
37
45
53
61
69
77
85
93
1
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
62
73
68
55
50
59
58
64
72
64
62
51
58
70
62
42
53
46
17
33
37
38
43
44
42
40
37
43
48
40
Before
After
wells
wells
were dug – were dug Millions Millions of Improvement
of E.Coli E.Coli per Level:
per ml
ml
Before – After
23
21
64
54
72
50
52
49
55
52
3
35
44
49
35
38
10
32
IMPROVEMENTS
min =
formula
max =
formula
mean=
formula
SD =
formula
SE =
formula
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
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
Low
High
Bins
Formula/NumberFormula/Number
words or formula
Formula/NumberFormula/Number
words or formula
Formula/NumberFormula/Number
words or formula
Formula/NumberFormula/Number
words or formula
Formula/NumberFormula/Number
words or formula
Formula/NumberFormula/Number
words or formula
Formula/NumberFormula/Number
words or formula
Formula/NumberFormula/Number
words or formula
Formula/NumberFormula/Number
words or formula
Formula/NumberFormula/Number
words or formula
Formula/NumberFormula/Number
words or formula
(remember to create the Histogram, too).
Frequency Distribution
95% Confidence Interval
Lower number
to
Higher number
formula
to
formula
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
60
57
59
60
61
57
71
57
63
64
63
23
21
64
54
72
50
52
49
55
73
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
44
40
30
42
34
33
50
40
38
43
52
0
3
35
44
49
35
38
10
32
52
55
51
38
28
60
57
59
60
61
57
71
57
63
64
63
17
37
26
0
44
40
30
42
34
33
50
40
38
43
52
ncy Distribution
Cumulative
Frequency
Formula
Formula
Formula
Formula
Formula
Formula
Formula
Formula
Formula
Formula
Formula
eate the Histogram, too).
Part 2 – Data Analysis:
You have just completed a mission to Sierra Leone. The goal of the mission was to impro
water in 100 wells in a certain region. You collected data on the E. coli count from each w
your mission (Q2). You need to write a report on the success of the mission and for that y
some statistical analysis on the data. You will be looking at the data from different persp
if the water quality has improved.
Frequency
Formula
Formula
Formula
Formula
Formula
Formula
Formula
Formula
Formula
Formula
Formula
4. Since you collected water from the same source twice it makes sense to analyze the a
well’s water quality improved. Calculate a data set that would measure the improveme
and the descriptive statistics for that data set, including both the standard deviation an
for the data set. (see section 3.5 of the textbook). Make a frequency distribution and hi
data. (Calculate the improvement in the water quality of each well in column D. (Differe
Then, fill out the two tables to the left and make a histogram of the improvement levels.
deviation of this data set is not the same as the standard error. Use the formulas from se
to calculate the standard error of the means.))
5. You have calculated one sample of 100 wells and their improvement levels. If you cou
samples of 100 wells, the distribution of all of those sample means would be a normal di
section 3.5). Find the 95% confidence interval of that distribution, using your sample m
population mean and the standard error of your sample as the population standard de
the 95% confidence interval of the sampling distribution in cells F24 and H24.)
6. Suppose that 0 was inside of the 95% confidence interval. From that measure,
water became cleaner? Why or why not? Suppose that 0 was outside the 95% confidenc
measure, could you conclude that the water became cleaner? Why or why not?
Answer here:
f the mission was to improve the quality of
he E. coli count from each well before (Q1) after
f the mission and for that you need to perform
e data from different perspectives to determine
akes sense to analyze the amount by which each
d measure the improvement level of each well,
h the standard deviation and standard error (SE)
quency distribution and histogram for your
well in column D. (Difference in Level of e. Coli.)
of the improvement levels. (NOTE: The Standard
r. Use the formulas from section 3.5 of the text
ovement levels. If you could take all possible
means would be a normal distribution. (see
ution, using your sample mean as the
he population standard deviation. (Calculate
ells F24 and H24.)
rom that measure, could you conclude that the
outside the 95% confidence interval. From that
? Why or why not?

Purchase answer to see full
attachment