Home>Applied Sciences homework help>Math 144  ssignment 2

Grading Sheet

Part 1
Requirements: Answer each question fully. Use Excel formulas with cell references. Answers must be recorded on the worksheet.
Possible pointsPoints earnedComments
Five year inflation rate10
Projection of expenses in Worksheet 110
Part 1 total200
Part 2
Requirements: Answer each question fully. Use Excel formulas with cell references. Answers must be recorded on the worksheet.
Possible pointsPoints earnedComments
Descriptive Statistics16
Interpret Descriptive Statistics14
Proportion calculations10
Interpretation of proportions10
Conversion of before well5
Conversion of after well5
Improvement level data set5
Descriptive Statistics for improvement levels10
Histogram5
Standard error of the mean5
Confidence interval10
Discussion of the placement of 010
Part 2 total1050
Total of Worksheet 212500%

Part 1 Inflation

Input your name here
name
Part 1 – Budget Projection: Your friends have decided to delay your dream vacation from Worksheet 1 for five years, and you need to estimate what the cost of your trip will be by then. Step 1: Go to the Bureau of Labor Statistics website at https://data.bls.gov/cgi-bin/surveymost?cu. 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.
MonthYearCPI
Unadjusted CPI, all items for 5 years agonumbernumbernumber
Unadjusted CPI, all items for last monthnumbernumbernumber
Inflation rate: something that cost $1.00 five years ago would cost what now?formula
What percent increase is this?formula
Total budget from Worksheet 1number
5 year projected budget totalformula

Part 2 Questions 1-3

Before wells were dug – Millions of E.Coli per mlAfter wells were dug – Millions of E.Coli per mlYOUR NAME:Joe LopeOriginal Before DataOriginal After DataRandom numbersseed
2352BeforeAfter8
213min =formulamin =formula7867916352
6435max =formulamax =formula19417240
5444mean=formulamean=formula3223253178
7249SD =formulaSD =formula12511033411095
5035sample size =formula/numbersample size =formula/number53414153826
52380 count =formula/number0 count =formula/number68424965327
491041057700
5532RatioBeforeAfter106796589164
7352Percent Cleanformulaformula386739230
551736168110211
5137Conversions414891100
3826mloz175971220
28029.57351439513280
6044233131480
5740In 24 ounces3282115170
5930E.coli beforeE. coli after492829163413
6042formulaformula36183717213
6134221451806
573333225319187
7150582561204310
5740755969216044
6338826377226748
6443806085236545
6352705293245537
23079501256435
21373669265851
6435765417276139
5444724225285727
7249725533295740
5035705341305538
5238845449316939
4910816257326647
5532695965335444
7352855273347037
55171006981358554
5137705789365542
3826744597375930
28063395384824
6044766013396145
5740787521406360
5930876429417249
6042714137425626
6134836745436852
5733715653445641
7150755761456042
5740765869466143
6338633977474824
6443703885485523
6352655093495035
23083591506844
21376489516133
6435785917526344
5444764925536134
7249684733545332
5035775141556236
5238755849566043
4910675357575238
5532744565585930
7352865873597143
5517856781607052
5137724889615733
3826736597625850
28059435634428
6044725513645740
5740642521654910
5930674829665233
6042795537676440
6134643345684918
5733866553697150
7150745361705938
5740836169716846
6338815577726640
6443704785735532
6352715493745639
23068541755339
21376649766149
6435725517775740
5444715525785640
7249867733797162
5035866241807147
5238886749817352
4910785957826344
5532734565835830
7352845773846942
5517785381856338
5137775789866242
3826886897877353
28083615886846
6044703213895517
5740654821905033
5930745229915937
6042735337925838
6134795845936443
5733875953947244
7150795761956442
5740775569966240
6338665277975137
6443735885985843
6352856393997048
775511006240

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.)

Part 2 Questions 4-6

Before wells were dug – Millions of E.Coli per mlAfter wells were dug – Millions of E.Coli per mlImprovement Level: Before – After
2352IMPROVEMENTS
213min =formula
6435max =formula
5444mean=formula
7249SD =formula
5035SE =formula
5238
4910
5532Frequency Distribution
7352LowHighBinsCumulative FrequencyFrequency
5517Formula/NumberFormula/Numberwords or formulaFormulaFormula
5137Formula/NumberFormula/Numberwords or formulaFormulaFormula
3826Formula/NumberFormula/Numberwords or formulaFormulaFormula
280Formula/NumberFormula/Numberwords or formulaFormulaFormula
6044Formula/NumberFormula/Numberwords or formulaFormulaFormula
5740Formula/NumberFormula/Numberwords or formulaFormulaFormula
5930Formula/NumberFormula/Numberwords or formulaFormulaFormula
6042Formula/NumberFormula/Numberwords or formulaFormulaFormula
6134Formula/NumberFormula/Numberwords or formulaFormulaFormula
5733Formula/NumberFormula/Numberwords or formulaFormulaFormula
7150Formula/NumberFormula/Numberwords or formulaFormulaFormula
5740(remember to create the Histogram, too).
6338
6443
6352
23095% Confidence Interval
213Lower numbertoHigher number
6435formulatoformula
5444
7249
5035
5238
4910
5532
7352
5517
5137
3826
280
6044
5740
5930
6042
6134
5733
7150
5740
6338
6443
6352
230
213
6435
5444
7249
5035
5238
4910
5532
7352
5517
5137
3826
280
6044
5740
5930
6042
6134
5733
7150
5740
6338
6443
6352
230
213
6435
5444
7249
5035
5238
4910
5532
7352
5517
5137
3826
280
6044
5740
5930
6042
6134
5733
7150
5740
6338
6443
6352

Part 2 – Data Analysis: 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 (Q1) after your mission (Q2). 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 improved. 4. Since you collected water from the same source twice it makes sense to analyze the amount by which each well’s water quality improved. Calculate a data set that would measure the improvement level of each well, and the descriptive statistics for that data set, including both the standard deviation and standard error (SE) for the data set. (see section 3.5 of the textbook). Make a frequency distribution and histogram for your data. (Calculate the improvement in the water quality of each well in column D. (Difference in Level of e. Coli.) Then, fill out the two tables to the left and make a histogram of the improvement levels. (NOTE: The Standard deviation of this data set is not the same as the standard error. Use the formulas from section 3.5 of the text to calculate the standard error of the means.)) 5. You have calculated one sample of 100 wells and their improvement levels. If you could take all possible samples of 100 wells, the distribution of all of those sample means would be a normal distribution. (see section 3.5). Find the 95% confidence interval of that distribution, using your sample mean as the population mean and the standard error of your sample as the population standard deviation. (Calculate 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, could you conclude that the water became cleaner? Why or why not? Suppose that 0 was outside the 95% confidence interval. From that measure, could you conclude tha  t the water became cleaner? Why or why not? Answer here:

 

Purchase the answer to view it

blurred-text

 

"Order a similar paper and get 15% discount on your first order with us
Use the following coupon
"FIRST15"

Order Now