Deliverable 7 Analysis

profileJustcarmel
Deliverable7-StatisticalAnalysisReport.xlsx

Data and Calculations

Patient # Infectious Disease Age
1 Yes 70
2 Yes 43
3 Yes 59
4 Yes 58
5 Yes 43 Age Calculations Formulas/Answers
6 Yes 60 Mean
7 Yes 71 Median
8 Yes 71 Mode
9 Yes 72
10 Yes 67
11 Yes 60
12 Yes 65
13 Yes 73
14 Yes 73
15 Yes 42
16 Yes 45
17 Yes 65 Midrange
18 Yes 67 Range
19 Yes 44 Variance
20 Yes 51 Standard Deviation
21 Yes 71
22 Yes 66 Maximum
23 Yes 84 Minimum
24 Yes 56
25 Yes 61
26 Yes 59
27 Yes 68
28 Yes 73
29 Yes 50
30 Yes 55 Critical Value
31 Yes 77 Margin of Error
32 Yes 57 Lower Limit
33 Yes 48 Upper Limit
34 Yes 71
35 Yes 58
36 Yes 49
37 Yes 65
38 Yes 60
39 Yes 44
40 Yes 61
41 Yes 57 Test Statistic
42 Yes 63 Critical Value
43 Yes 61 P-value
44 Yes 60
45 Yes 62
46 Yes 55
47 Yes 66
48 Yes 50
49 Yes 77
50 Yes 66
51 Yes 69
52 Yes 65
53 Yes 57
54 Yes 69
55 Yes 59
56 Yes 70
57 Yes 53
58 Yes 76
59 Yes 75
60 Yes 68
61 Yes 55
62 Yes 61
63 Yes 81
64 Yes 48
65 Yes 67
66 Yes 59
67 Yes 83
68 Yes 70
69 Yes 68
70 Yes 82

Slide 6: Find the following statistical calculations. In your PPT, include your interpretation of the calculations and the correct units.

*Note: Refer to the Word document in the deliverable instructions for a breakdown of requirements for each slide.

Slide 8: Construct a 95% confidence interval for the population mean ages of the patients. Assume that your data is normally distributed and σ is unknown.

Slide 9, 10, 11: Perform the following hypothesis test based on the claim that the average age of all patients admitted to the hospital with infectious diseases is less than 65 years of age.