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

**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/

_{}^{}

## Explanation & Answer

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.

Comments

t2

references. Answers must be recorded on the worksheet.

Comments

0%

Input your name here

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

CPI Data Link

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

CPI Data Link

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

Nothing to answer here!

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