# MATH144 CGU Confidence Interval & Standard Deviation Presentation

User Generated

njnyqra6

Mathematics

math144

Grand Canyon University

Professor Bauman

## 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
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

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

t2
references. Answers must be recorded on the worksheet.

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
\$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

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

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

### Review

Anonymous
Awesome! Perfect study aid.

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4