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
Formulas/Answers
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