## Description

I am required to 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.

Please note that the Confidence Interval Explanation document is provided for reference and assistance with Major Assignment 2.

The Powerpoint is a step-by-step to help with completion.

### Unformatted Attachment Preview

Purchase answer to see full attachment

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

Alicia Fitts

name

Month

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

Year

5

5

You should just use information from Majo

2014

237,9 retrieve fresh CPI data, here are the instrru

2019

256,092 Step 1: Go to the Bureau of Labor Statistic

Step 2: Check U.S. All items, 1982-84=100

Step 3: Click "Retrieve Data"

7,65%

Use the most recent CPI value and the CPI

earlier to estimate the price of your trip in

$1,08 rate.

$4.975

CPI Data Link

$5.355,43

CPI

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

8

61

63

61

52

71

58

38

0

69

56

52

59

58

62

23

67

85

55

57

56

73

62

28

58

61

63

49

56

59

110

21

55

68

60

71

63

64

91

After wells

were dug Millions of

E.Coli per ml

52

39

60

34

33

62

38

26

6

39

41

38

38

30

40

0

48

54

23

33

39

53

40

0

51

45

44

10

40

37

95

3

38

52

43

50

44

42

64

YOUR NAME:

Alicia Fitts

Before

min = 0

max = 110

mean= 54,37

SD = 19,57

# of wells tested = 100,00

# of wells with 0 E coli = 3

Ratio

Percent Clean

Conversions

ml

29,5735

In 24 ounces

E.coli before

5.678.112.000

60

70

48

70

55

62

70

2

64

48

61

57

57

50

17

34

57

56

62

49

73

72

0

43

54

61

71

66

63

58

0

55

59

68

44

61

55

4

17

57

72

53

64

71

64

53

21

44

37

24

52

32

42

48

0

35

24

33

40

40

33

8

13

40

26

36

18

52...