WHO CAN DO THIS BY 9:30 TONIGHT

profileLynette89
Deliverable_07_Datarev21.xlsx
Home>Business & Finance homework help>Accounting homework help>WHO CAN DO THIS BY 9:30 TONIGHT

Names

Patient # Infectious Disease Age
1 Yes 68 mean 63
2 Yes 41 mode 67
3 Yes 59 median 66
4 Yes 55 maximum 78
5 Yes 45 minimum 41
6 Yes 78 midrange 59.5
7 Yes 75 range 37
8 Yes 67 variance 95.6370056497
9 Yes 65 standard deviation 9.7794174494
10 Yes 71
11 Yes 67 sample mean 61
12 Yes 66 12.1448374227
13 Yes 70
14 Yes 71
15 Yes 44 mean
16 Yes 46 number of patients Sum of the ages average
17 Yes 73 60 3775 .=( sum of age)/ number of patient
18 Yes 54 62.9166666667
19 Yes 43
20 Yes 56 mode
21 Yes 67 this is the most common number below is the data arranged from the samllest to the largest
22 Yes 67
23 Yes 75 41 54 62 67 72
24 Yes 77 43 55 63 67 72
25 Yes 62 44 55 64 68 72
26 Yes 61 45 56 64 69 73
27 Yes 72 46 58 64 69 73
28 Yes 74 46 58 65 70 74
29 Yes 54 48 59 66 70 75
30 Yes 61 49 60 66 70 75
31 Yes 73 49 61 67 70 75
32 Yes 49 49 61 67 70 76
33 Yes 48 54 62 67 71 77
34 Yes 69 54 62 67 71 78
35 Yes 72
36 Yes 76
37 Yes 62 mode = 67 it is repeated 7 times as seen int the above data
38 Yes 58
39 Yes 46
40 Yes 62 median
41 Yes 63 this is middle number when the data is arranged. Below is the data arranged fron from the smallemst to the largest
42 Yes 66
43 Yes 64 44 55 64 68 72
44 Yes 55 45 56 64 69 73
45 Yes 64 46 58 64 69 73
46 Yes 49 46 58 65 70 74
47 Yes 72 48 59 66 70 75
48 Yes 49 49 60 66 70 75
49 Yes 70 49 61 67 70 75
50 Yes 70 49 61 67 70 76
51 Yes 70 54 62 67 71 77
52 Yes 58 54 62 67 71 78
53 Yes 60
54 Yes 70
55 Yes 67 the two middle number are 66 and 66
56 Yes 67 the mdian is therefore 66
57 Yes 54
58 Yes 75 median = 66
59 Yes 69
60 Yes 64
maximum and minimum
the data is arranged from largest to smallest
78 71 67 62 54
77 71 67 62 54
76 70 67 61 49
75 70 67 61 49
75 70 66 60 49
75 70 66 59 48
74 70 65 58 46
73 69 64 58 46
73 69 64 56 45
72 68 64 55 44
72 67 63 55 43
72 67 62 54 41
from the table above;
maximum 78
minimum 41
midrange
midrange = (maximum + minimum)/2
maximum 78
minimum 41
midrange 59.5
variance
variance = (x-x_bar)^2
N
where x is the age,
x_bar is the mean of ages
and N is the number of patiants
x x_bar (x-x_bar)^2 x x_bar (x-x_bar)^2 x_bar (x-x_bar)^2
68 62.91666667 25.8403 67 62.91666667 16.6736 64 62.91666667 1.1736
41 62.91666667 480.3403 75 62.91666667 146.0069 55 62.91666667 62.6736
59 62.91666667 15.3403 77 62.91666667 198.3403 64 62.91666667 1.1736
55 62.91666667 62.6736 62 62.91666667 0.8403 49 62.91666667 193.6736
45 62.91666667 321.0069 61 62.91666667 3.6736 72 62.91666667 82.5069
78 62.91666667 227.5069 72 62.91666667 82.5069 49 62.91666667 193.6736
75 62.91666667 146.0069 74 62.91666667 122.8403 70 62.91666667 50.1736
67 62.91666667 16.6736 54 62.91666667 79.5069 70 62.91666667 50.1736
65 62.91666667 4.3403 61 62.91666667 3.6736 70 62.91666667 50.1736
71 62.91666667 65.3403 73 62.91666667 101.6736 58 62.91666667 24.1736
67 62.91666667 16.6736 49 62.91666667 193.6736 60 62.91666667 8.5069
66 62.91666667 9.5069 48 62.91666667 222.5069 70 62.91666667 50.1736
70 62.91666667 50.1736 69 62.91666667 37.0069 67 62.91666667 16.6736
71 62.91666667 65.3403 72 62.91666667 82.5069 67 62.91666667 16.6736
44 62.91666667 357.8403 76 62.91666667 171.1736 54 62.91666667 79.5069
46 62.91666667 286.1736 62 62.91666667 0.8403 75 62.91666667 146.0069
73 62.91666667 101.6736 58 62.91666667 24.1736 69 62.91666667 37.0069
54 62.91666667 79.5069 46 62.91666667 286.1736 64 62.91666667 1.1736
43 62.91666667 396.6736 62 62.91666667 0.8403
56 62.91666667 47.8403 63 62.91666667 0.0069
67 62.91666667 16.6736 66 62.91666667 9.5069
(x-x_bar)^2 = 5642.5833
variance = 5642.5833
60
variance = 94.043055
standard deviation
standard deviation = (variance)^0.5
.= 9.6975798527