NEED STATISTICS HELP ASAP-Statistical Analysis Report

HM-Deliverable07-Spreadsheet.xlsx

Descriptive Statistics & C.I.

Patient #	Infectious Disease	Age	Descriptive Statistics of Age
1	Yes	67	Mean	61.25
2	Yes	38	Median	62
3	Yes	58	Mode	52
4	Yes	52	Range	39
5	Yes	46	Standard Deviation	9.0696457801
6	Yes	61	Variance	82.2584745763
7	Yes	74
8	Yes	69	Confidence Interval for the Mean
9	Yes	67	Mean, µ =	61.25
10	Yes	70	Standard Deviation, σ =	9.0696457801
11	Yes	65	Sample Size, n =	60
12	Yes	69	Critical Value, z (α/2) =	1.9599639845
13	Yes	72	Margin of Error	2.2948948514
14	Yes	69	Lower Confidence Limit	58.9551051486
15	Yes	45	Upper Confidence Limit	63.5448948514
16	Yes	49
17	Yes	72
18	Yes	52
19	Yes	46
20	Yes	57
21	Yes	70
22	Yes	67
23	Yes	77
24	Yes	59
25	Yes	59
26	Yes	61
27	Yes	72
28	Yes	71
29	Yes	52
30	Yes	58
31	Yes	73
32	Yes	52
33	Yes	47
34	Yes	68
35	Yes	55
36	Yes	45
37	Yes	59
38	Yes	58
39	Yes	47
40	Yes	62
41	Yes	62
42	Yes	64
43	Yes	62
44	Yes	56
45	Yes	62
46	Yes	52
47	Yes	70
48	Yes	51
49	Yes	70
50	Yes	69
51	Yes	69
52	Yes	60
53	Yes	57
54	Yes	68
55	Yes	64
56	Yes	64
57	Yes	56
58	Yes	72
59	Yes	70
60	Yes	67

Null Hypothesis:	H0: μ ≤ 60
Alternative Hypothesis:	H1: μ > 60
Analysis Plan:	As the sample size, n >> 30 and the population is normally distributed, we shall use z-test to test the given hypothesis.
	As the alternative hypothesis is H1: μ > 60, the given test is an upper-tailed test.
Critical Value:	Significance Level, α =	0.05
	z - critical for lower-tailed z-test for α = 0.05 is given as:			1.644853627
Decision Rule:	Reject H0, if z-statistic	≥	1.644853627
Calculation of Test Statistic:	Sample Size, n	60
	Sample Mean, x	61.25
	Standard Deviation, σ	9.0696457801
	Hypothesized Mean, μ	60
	Test Statistic, z =	1.0675674222
p-value:	p-value	0.1428578427
Decision:	Fail to reject H0.
Conclusion:	There is no evidence to support the claim that the mean age of patients suffering from this disease is greater than 60 years, at α = 0.05 significance.