# STA 3215 Rasmussen University Statistics and Analytics Worksheet

Hello, I just need someone to help me correct a few things in my Excel spreadsheet that has to do with statistics. I am struggling on this. I would like someone to make sure the critical value, margin of error, test statistic and p-value are all correct.

Patient #
Infectious Disease
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Age
70
41
58
58
45
59
71
71
72
67
60
65
73
73
42
45
65
66
44
51
71
66
84
56
61
59
68
73
50
55
77
57
48
71
58
49
65
60
44
61
57
63
61
60
62
*Note: Refer to the Word document in th
Slide 6: Find the following statistical calcu
Age Calculations
Mean
Median
Mode
Midrange
Range
Variance
Standard Deviation
Maximum
Minimum
Slide 8: Construct a 95%
Critical Value
Margin of Error
Lower Limit
Upper Limit
alpha
Sample size
Slide 9, 10, 11: Perform the following hyp
Test Statistic
Critical Value
P-value
Degree of freedom
55
66
50
77
66
69
65
57
69
59
70
53
76
75
68
55
61
81
48
67
59
83
69
68
75
95% confide
70.00
60.00
50.00
40.00
Age
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
30.00
20.00
10.00
0.00
-10.00
120.00
100.00
80.00
Age
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
60.00
40.00
20.00
0.00
Critical Value
efer to the Word document in the deliverable instructions for a breakdown of requirements for each slide.
nd the following statistical calculations. In your PPT, include your interpretation of the calculations and the correct uni
62.47
62.50
59.00
71.00
65.00
66.00
61.00
62.50
43.00
102.19
10.11
84.00
41.00
=AVERAGE(C2:C71)
=MEDIAN(C2:C71)
=MODE.MULT(C2:C71)
=(MAX(C2:C71)+MIN(C2:C71))/2
=MAX(C2:C71)-MIN(C2:C71)
=VAR.S(C2:C71)
=STDEV.S(C2:C71)
=MAX(C2:C71)
=MIN(C2:C71)
onstruct a 95% confidence interval for the population mean ages of the patients. Assume that your data is normally distributed and σ is un
-1.67
-2.01
60.46
64.49
=T.INV(0.05,70)
=G31*(G21/SQRT(G37))
=G7+G35
=G7-G35
0.05
70.00
=(100-95)%
Perform the following hypothesis test based on the claim that the average age of all patients admitted to the hospital with i
-1.27
-1.67
0.11
=T.INV(F36,F46)
69.00
=F37-1
Variance
Observations
Hypothesized Mean Difference
df
t Stat
P(T

Don't use plagiarized sources. Get Your Custom Essay on
STA 3215 Rasmussen University Statistics and Analytics Worksheet
Just from \$13/Page

## Calculate the price of your order

550 words
We'll send you the first draft for approval by September 11, 2018 at 10:52 AM
Total price:
\$26
The price is based on these factors:
Number of pages
Urgency
Basic features
• Free title page and bibliography
• Unlimited revisions
• Plagiarism-free guarantee
• Money-back guarantee
On-demand options
• Writer’s samples
• Part-by-part delivery
• Overnight delivery
• Copies of used sources
Paper format
• 275 words per page
• 12 pt Arial/Times New Roman
• Double line spacing
• Any citation style (APA, MLA, Chicago/Turabian, Harvard)

## Our guarantees

Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.

### Money-back guarantee

You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.

### Zero-plagiarism guarantee

Each paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.

### Free-revision policy

Thanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.