Here is one sample from the before data. Hit to get a new sample. Before 25 20 15 Samples from the after data mean is found. This is repea sampling distribution. The n mean equal to the mean of t deviation equal to the stand divided by the square root o is the SE, is shown in the ba confidence interval is indicat normal distribution, this is (m 1.96*SE). The meaning shou sampling distribution should 10 5 0 1000 mean counts fo Here is one sample from the after data. Hit to get a new sample. 1 0.9 0.8 0.7 0.6 After 25 0.5 0.4 0.3 0.2 20 0.1 0 15 10 Mean of sampling d Standard Deviation of Sam 5 0 Here is another perspective. 100 samples were drawn from the After Data. A 95% should expect 95% of these CI's to contain the true population mean. Hit t 100 CI's computed from Samples of size 100 from the After Da 72 67 62 57 52 Population Mean 72 67 62 57 52 Population Mean %CI's that contain the mean: 0% Each CI is formed by finding the me then the standard deviation of the as SD/sqrt(# of samples). The CI is + 1.96*SE) A good intuition for the CI: The mean is a point estimate. You take a sample of the pop mean and use this as an estimate for the population mean. Why should this estimate be a have one random sample. The CI is an interval estimate, a 95% CI is an interval obtained interpret this as: "I am 95% certain that the actual population mean is in the interval." You mean for the population, instead you are finding an interval of possible values for the pop able to quantify how certain you are that the true population mean is inside that interval. from the after data of size 100 are taken and the found. This is repeated 1000 times to get a g distribution. The normal distribution which has ual to the mean of the after data and standard n equal to the standard deviation of the after data by the square root of the number of samples, this , is shown in the background. The 95% ce interval is indicated by the red coloring on the istribution, this is (mean - 1.96*SE, mean + . The meaning should be clear, about 95% of the g distribution should occur in this interval. 000 mean counts for samples of size 100 Mean of sampling distribution: #REF! ard Deviation of Sampling Dist: #DIV/0! he After Data. A 95% CI was created for each. We n mean. Hit to regenerate. 0 from the After Data ed by finding the mean (M) of the sample and ard deviation of the sample (SD). SE is computed samples). The CI is computed as (M - 1.96*SE, M a sample of the population, take the sample d this estimate be any good, after all, you just n interval obtained from a sample and you in the interval." You are not predicting a specific e values for the population mean and you are nside that interval. Input your name here Natalie Robinson 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 CPI number number formula formula number formula Part 1 - Budget Projection: Your friends have decided to delay your years, and you need to estimate what th Bureau of Labor Statistics website at http download the most current CPI Detailed document, locate the table \"U.S. City Ave present.\" (usually this is table 24 in the d and the CPI for the same month but five trip in five years and the five year inflatio - Budget Projection: iends have decided to delay your dream vacation from Worksheet 1 for five and you need to estimate what the cost of your trip will be by then. Go to the u of Labor Statistics website at http://www.bls.gov/cpi/tables.htm and oad the most current CPI Detailed Report (complete text and tables). In this ent, locate the table \"U.S. City Average - Historical - All Items 1913 - t.\" (usually this is table 24 in the document). Use the most recent CPI value e CPI for the same month but five years earlier to estimate the price of your five years and the five year inflation rate. Before wells After wells were dug - were dug Millions of Millions of E.Coli per ml E.Coli per ml 23 52 21 3 64 35 54 44 72 49 50 35 52 38 49 10 55 32 73 52 55 17 51 37 38 26 28 0 60 44 57 40 59 30 60 42 61 34 57 33 71 50 57 40 63 38 64 43 63 52 23 0 21 3 64 35 54 44 72 49 50 35 52 38 49 10 55 32 73 52 55 17 51 37 38 26 YOUR NAME: Joe Lope Before min = formula max = formula mean= formula SD = formula sample size = formula/number 0 count = formula/number Ratio Percent Clean After min = formula max = formula mean= formula SD = formula sample size = formula/number 0 count = formula/number Before formula Conversions ml 29.5735 oz 1 In 24 ounces E.coli before formula E. coli after formula After 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 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 55 73 55 51 38 28 60 57 59 60 61 57 71 57 63 64 63 32 52 17 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 G19 and H19 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.) Answer here: e quality of efore and eed to rspectives Use the ement in statistics. . Calculate re does it d. (In G19 you ingest w many the 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 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 63 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 39 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 73 84 78 77 88 83 70 65 74 73 79 87 79 77 66 73 85 77 45 57 53 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 8 1 63 24 3 17 4 110 5 38 6 53 70 8 91 9 23 10 21 11 0 12 2 13 28 14 8 15 17 16 34 17 21 18 0 19 18 20 43 21 60 22 67 23 65 24 55 25 64 26 58 27 61 28 57 29 57 30 55 31 69 32 66 33 54 34 70 35 85 36 55 37 59 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 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 13 21 29 37 45 53 61 69 77 85 93 1 9 17 25 33 41 49 57 38 48 39 61 40 63 41 72 42 56 43 68 44 56 45 60 46 61 47 48 48 55 49 50 50 68 51 61 52 63 53 61 54 53 55 62 56 60 57 52 58 59 59 71 60 70 61 57 62 58 63 44 64 57 65 49 66 52 67 64 68 49 69 71 70 59 71 68 72 66 73 55 74 56 75 53 76 61 77 57 78 56 79 71 80 71 81 73 82 63 24 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 65 73 81 89 97 5 13 21 29 37 45 53 61 69 77 85 93 1 83 58 84 69 85 63 86 62 87 73 88 68 89 55 90 50 91 59 92 58 93 64 94 72 95 64 96 62 97 51 98 58 99 70 100 62 30 42 38 42 53 46 17 33 37 38 43 44 42 40 37 43 48 40 Before wells were After wells dug were dug Millions of Millions of Improvement E.Coli per E.Coli per Level: ml ml Before - After 23 52 21 3 64 35 54 44 72 49 50 35 52 38 49 10 55 32 73 52 55 17 51 37 38 26 28 0 60 44 57 40 59 30 60 42 61 34 57 33 71 50 57 40 63 38 64 43 63 52 23 0 21 3 64 35 54 44 72 49 50 35 52 38 49 10 55 32 73 52 55 17 51 37 38 26 IMPROVEMENTS min = formula max = formula mean= formula SD = formula SE = formula Frequency Distribution Low High Title Formula/NumberFormula/N words or formula Formula/NumberFormula/N words or formula Formula/NumberFormula/N words or formula Formula/NumberFormula/N words or formula Formula/NumberFormula/N words or formula Formula/NumberFormula/N words or formula Formula/NumberFormula/N words or formula Formula/NumberFormula/N words or formula Formula/NumberFormula/N words or formula Formula/NumberFormula/N words or formula Formula/NumberFormula/N words or formula (remember to create the Histogram, too). 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 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 55 73 55 51 38 28 60 57 59 60 61 57 71 57 63 64 63 32 52 17 37 26 0 44 40 30 42 34 33 50 40 38 43 52 ncy Distribution Cumulative FrequeFrequency Formula Formula Formula Formula Formula Formula Formula Formula Formula Formula Formula 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 improv in 100 wells in a certain region. You collected data on the E. coli count from each well bef mission (Q2). You need to write a report on the success of the mission and for that you ne statistical analysis on the data. You will be looking at the data from different perspectives water quality has improved. 4. Since you collected water from the same source twice it makes sense to analyze the am well's water quality improved. Calculate a data set that would measure the improvemen 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 his (Calculate the improvement in the water quality of each well in column D. (Difference in L fill out the two tables to the left and make a histogram of the improvement levels. (NOTE deviation of this data set is not the same as the standard error. Use the formulas from sec calculate the standard error of the means.)) 5. You have calculated one sample of 100 wells and their improvement levels. If you could samples of 100 wells, the distribution of all of those sample means would be a normal dis 3.5). Find the 95% confidence interval of that distribution, using your sample mean as t and the standard error of your sample as the population standard deviation. (Calculate interval of the sampling distribution in cells F24 and H24.) 6. Suppose that 0 was inside of the 95% confidence interval. From that measure, could y water became cleaner? Why or why not? Suppose that 0 was outside the 95% confidence measure, could you conclude that the water became cleaner? Why or why not? Answer here: the mission was to improve the quality of water count from each well before (Q 1) after your mission and for that you need to perform some om different perspectives to determine if the es sense to analyze the amount by which each measure the improvement level of each well, the standard deviation and standard error (SE) uency distribution and histogram for your data. column D. (Difference in Level of e. Coli.) Then, mprovement levels. (NOTE: The Standard Use the formulas from section 3.5 of the text to vement levels. If you could take all possible ans would be a normal distribution. (see section ng your sample mean as the population mean dard deviation. (Calculate the 95% confidence om that measure, could you conclude that the utside the 95% confidence interval. From that Why or why not? Part 1 Requirements: Answer each question fully. Use Excel formulas with cell references. Answers must be recorded on 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 on Possible points Points earned Descriptive Statistics 16 Interpret Descriptive Statistics 14 Conversion of before well 5 Conversion of after well 5 Proportion calculations 10 Interpretation of proportions 10 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 1 references. Answers must be recorded on the worksheet. Comments 2 references. Answers must be recorded on the worksheet. Comments 0% To prepare for the final project: This part of the assignment is not graded, and your final Mission Trip project. Your Mission Trip will occur in 5 years, so you be able to do the 5 year projections of your M You should also be filling in the details of your questions from the Mission Trip assignment: An overview of your project: Where are go cannot be the sole purpose of your trip. Cultural and social aspects of the country a How your choice of project works toward f yourself: How does your personal worldvie plans for the trip? Information about your target population: the population of the country as a whole? Aspects of the country that make it a suita The economic situation in your cou Possible concerns that you need to could be safety from violence or fr travel to the country) e final project: ssignment is not graded, and you will not hand it in at this time. It is here to help you stay on track for n Trip project. will occur in 5 years, so you will need to make budget projections into the future. By now, you should 5 year projections of your Mission Trip budget. e filling in the details of your narrative. If asked, you should be able to answer the following he Mission Trip assignment: f your project: Where are going, and what service will you be providing? Remember, evangelism sole purpose of your trip. ocial aspects of the country and its population that led you to choose this area of the world. ce of project works toward fulfillment of the Judeo-Christian-Islamic ideal to love your neighbor as does your personal worldview and the possible worldviews of your target population influence your rip? bout your target population: Who are you planning to serve? How does this population compare to n of the country as a whole? country that make it a suitable location for your trip. In particular, include information about onomic situation in your country and how your project will improve this. le concerns that you need to keep in mind to keep your team and your target population safe. This be safety from violence or from health problems (for example, will your team need inoculations to to the country)