Homework 3

profilenancy2014
chpt_10-1.xls
Home>Mathematics homework help>Homework 3

Costs

ID Hosp Cost
1 Albemarle $5,342.61
2 Albemarle $7,237.59
3 Albemarle $11,801.95
4 Albemarle $1,082.36
5 Albemarle $2,379.59
6 Albemarle $8,469.39
7 Albemarle $4,453.55
8 Albemarle $4,745.26
9 Albemarle $11,963.80
10 Albemarle $5,294.96
11 Albemarle $2,965.55
12 Albemarle $3,896.16
13 Albemarle $6,074.21
14 Albemarle $7,217.18
15 Albemarle $3,730.40
16 Albemarle $1,248.14
17 Albemarle $14,258.95
18 Albemarle $19,475.78
19 Albemarle $3,384.80
20 Albemarle $6,680.14
21 Albemarle $1,871.78
22 Albemarle $4,655.22
23 Albemarle $7,899.41
24 Albemarle $12,005.57
25 Albemarle $3,117.39
26 Albemarle $10,750.39
27 Albemarle $5,097.72
28 Albemarle $2,280.30
29 Albemarle $16,611.95
30 Albemarle $3,237.47
31 Beaufort $6,844.89
32 Beaufort $6,283.80
33 Beaufort $5,206.09
34 Beaufort $22,030.51
35 Beaufort $5,372.86
36 Beaufort $2,197.14
37 Beaufort $13,472.69
38 Beaufort $8,486.18
39 Beaufort $2,447.01
40 Beaufort $19,182.24
41 Beaufort $10,021.34
42 Beaufort $1,594.57
43 Beaufort $4,412.80
44 Beaufort $7,000.21
45 Beaufort $1,221.58
46 Beaufort $6,956.35
47 Beaufort $2,568.13
48 Beaufort $2,257.24
49 Beaufort $3,946.68
50 Beaufort $9,546.52
51 Beaufort $9,321.12
52 Beaufort $4,278.73
53 Beaufort $3,720.09
54 Beaufort $2,314.85
55 Beaufort $2,741.32
56 Beaufort $3,489.61
57 Beaufort $9,916.19
58 Beaufort $2,793.26
59 Beaufort $4,394.15
60 Beaufort $3,598.72
61 Catawba $5,455.73
62 Catawba $4,448.48
63 Catawba $8,996.80
64 Catawba $4,734.98
65 Catawba $13,055.10
66 Catawba $10,194.42
67 Catawba $16,229.83
68 Catawba $7,099.69
69 Catawba $5,948.36
70 Catawba $4,155.38
71 Catawba $14,470.90
72 Catawba $4,957.09
73 Catawba $5,040.75
74 Catawba $4,113.04
75 Catawba $18,527.78
76 Catawba $7,272.11
77 Catawba $10,481.06
78 Catawba $3,156.14
79 Catawba $14,447.60
80 Catawba $6,412.51
81 Catawba $13,480.78
82 Catawba $18,847.52
83 Catawba $15,593.65
84 Catawba $10,049.19
85 Catawba $9,632.61
86 Catawba $18,571.33
87 Catawba $4,513.67
88 Catawba $6,049.84
89 Catawba $6,716.69
90 Catawba $8,768.23
91 Dare $1,035.75
92 Dare $6,130.58
93 Dare $2,584.28
94 Dare $2,635.85
95 Dare $5,371.03
96 Dare $14,433.99
97 Dare $2,283.88
98 Dare $3,630.39
99 Dare $4,775.36
100 Dare $6,084.66
101 Dare $1,414.80
102 Dare $6,630.33
103 Dare $5,139.11
104 Dare $16,346.71
105 Dare $5,068.54
106 Dare $1,810.36
107 Dare $5,881.90
108 Dare $4,149.18
109 Dare $3,597.68
110 Dare $10,679.39
111 Dare $5,249.46
112 Dare $10,377.23
113 Dare $3,063.96
114 Dare $3,580.55
115 Dare $10,516.46
116 Dare $6,082.93
117 Dare $960.28
118 Dare $3,118.49
119 Dare $12,919.48
120 Dare $5,933.54

Education

Person Intervention Knowledge
1 Nothing 15
2 Nothing 11
3 Nothing 12
4 Nothing 11
5 Nothing 11
6 Nothing 10
7 Nothing 15
8 Nothing 14
9 Nothing 13
10 Nothing 13
11 Nothing 13
12 Nothing 14
13 Nothing 10
14 Nothing 11
15 Nothing 14
16 Pamphlet 14
17 Pamphlet 16
18 Pamphlet 15
19 Pamphlet 10
20 Pamphlet 15
21 Pamphlet 15
22 Pamphlet 11
23 Pamphlet 11
24 Pamphlet 10
25 Pamphlet 18
26 Pamphlet 15
27 Pamphlet 10
28 Pamphlet 14
29 Pamphlet 17
30 Pamphlet 14
31 Face to Face 15
32 Face to Face 13
33 Face to Face 17
34 Face to Face 16
35 Face to Face 14
36 Face to Face 19
37 Face to Face 16
38 Face to Face 14
39 Face to Face 17
40 Face to Face 17
41 Face to Face 17
42 Face to Face 18
43 Face to Face 14
44 Face to Face 16
45 Face to Face 16

Readmit

Person Admt Cost
1 1 $2,319.69
1 2 $2,898.01
1 3 $5,139.02
2 1 $4,193.34
2 2 $3,243.61
2 3 $5,556.94
3 1 $2,508.31
3 2 $4,244.97
3 3 $8,355.07
4 1 $7,088.50
4 2 $4,932.22
4 3 $4,452.37
5 1 $1,786.17
5 2 $3,140.76
5 3 $3,517.98
6 1 $4,413.98
6 2 $1,599.82
6 3 $2,006.57
7 1 $6,767.15
7 2 $2,713.24
7 3 $9,685.02
8 1 $2,519.60
8 2 $7,210.54
8 3 $3,782.60
9 1 $6,934.29
9 2 $4,571.02
9 3 $9,792.65
10 1 $3,281.44
10 2 $6,397.57
10 3 $7,438.65
11 1 $2,275.54
11 2 $1,954.76
11 3 $5,813.72
12 1 $2,698.68
12 2 $4,216.57
12 3 $3,034.14

LOS

Hospital Sex LOS
Albemarle Male 4
Albemarle Male 3
Albemarle Male 5
Albemarle Male 4
Albemarle Male 8
Albemarle Male 6
Albemarle Male 3
Albemarle Male 1
Albemarle Male 1
Albemarle Male 1
Beaufort Male 3
Beaufort Male 1
Beaufort Male 3
Beaufort Male 1
Beaufort Male 1
Beaufort Male 2
Beaufort Male 4
Beaufort Male 7
Beaufort Male 13
Beaufort Male 5
Catawba Male 2
Catawba Male 7
Catawba Male 3
Catawba Male 14
Catawba Male 3
Catawba Male 15
Catawba Male 8
Catawba Male 12
Catawba Male 4
Catawba Male 3
Dare Male 8
Dare Male 3
Dare Male 5
Dare Male 3
Dare Male 4
Dare Male 4
Dare Male 9
Dare Male 2
Dare Male 9
Dare Male 3
Albemarle Female 4
Albemarle Female 6
Albemarle Female 2
Albemarle Female 2
Albemarle Female 4
Albemarle Female 12
Albemarle Female 2
Albemarle Female 18
Albemarle Female 1
Albemarle Female 2
Beaufort Female 7
Beaufort Female 13
Beaufort Female 3
Beaufort Female 5
Beaufort Female 2
Beaufort Female 2
Beaufort Female 12
Beaufort Female 8
Beaufort Female 3
Beaufort Female 5
Catawba Female 10
Catawba Female 7
Catawba Female 16
Catawba Female 3
Catawba Female 11
Catawba Female 9
Catawba Female 15
Catawba Female 19
Catawba Female 13
Catawba Female 5
Dare Female 7
Dare Female 17
Dare Female 5
Dare Female 6
Dare Female 3
Dare Female 6
Dare Female 3
Dare Female 2
Dare Female 2
Dare Female 11

Hb1Ac

Person Measure HbA1c
1 1 7.97
1 2 8.10
1 3 7.54
1 4 7.04
2 1 8.53
2 2 7.77
2 3 7.73
2 4 8.21
3 1 8.27
3 2 8.20
3 3 8.05
3 4 8.28
4 1 8.40
4 2 8.67
4 3 8.71
4 4 8.53
5 1 8.23
5 2 7.72
5 3 7.47
5 4 7.21
6 1 7.90
6 2 7.91
6 3 8.34
6 4 7.33
7 1 8.63
7 2 8.12
7 3 7.35
7 4 7.93
8 1 8.56
8 2 7.48
8 3 7.81
8 4 7.13
9 1 8.36
9 2 7.90
9 3 8.25
9 4 7.89
10 1 7.92
10 2 8.84
10 3 8.17
10 4 8.04

Wait

Shift Emerg Wait Shift 1 Shift 2 Shift 3
1 Emerg 22 Emerg Other Emerg Other Emerg Other
1 Emerg 32 1 21.8093197822 28.0653228704 21.2752463034 29.1304503055 36.3351109374 41.2172631614
1 Emerg 32 2 31.8291046773 34.3170985009 22.2570185491 34.6030982048 32.9986660037 40.712898327
1 Emerg 26 3 31.8409462983 30.7689322956 23.2769804774 32.6660654839 34.9490501068 39.3529172571
1 Emerg 30 4 26.4266970538 29.1392178345 23.9559955793 32.9406965041 44.1549009085 42.5893677957
1 Emerg 25 5 30.3577878134 27.8551659296 19.1635724099 24.1475471132 37.2037147573 39.540459612
1 Emerg 27 6 25.286499926 34.68718099 24.289589141 32.2562562663 33.4931173458 45.9570629674
1 Emerg 25 7 27.300162123 32.0573679649 27.8650447348 31.8815353542 32.5748778525 41.3691260392
1 Emerg 19 8 25.0928775989 27.9016592988 23.8192212186 37.3327464634 36.722014531 41.7809543351
1 Emerg 34 9 19.3129478197 30.5338552 26.4839133655 29.4652171154 34.1486129147 48.1858161138
1 Emerg 26 10 33.521383279 29.1839467839 17.4223084236 33.2961042962 37.2433505364 42.4085966288
1 Emerg 27 11 26.065232027 40.7838422991 22.5009131958 29.8269049684 36.7085949366 36.1971207085
1 Other 28 12 27.1973028197 24.4072078506 21.8286283547 29.2460288922 33.4463647706 36.6092946124
1 Other 34 27.1700217682 30.8083998182 22.8448693128 31.3993875806 35.8315313001 41.3267397965
1 Other 31
1 Other 29
1 Other 28
1 Other 35
1 Other 32
1 Other 28
1 Other 31
1 Other 29
1 Other 41
1 Other 24
2 Emerg 21
2 Emerg 22
2 Emerg 23
2 Emerg 24
2 Emerg 19
2 Emerg 24
2 Emerg 28
2 Emerg 24
2 Emerg 26
2 Emerg 17
2 Emerg 23
2 Emerg 22
2 Other 29
2 Other 35
2 Other 33
2 Other 33
2 Other 24
2 Other 32
2 Other 32
2 Other 37
2 Other 29
2 Other 33
2 Other 30
2 Other 29
3 Emerg 36
3 Emerg 33
3 Emerg 35
3 Emerg 44
3 Emerg 37
3 Emerg 33
3 Emerg 33
3 Emerg 37
3 Emerg 34
3 Emerg 37
3 Emerg 37
3 Emerg 33
3 Other 41
3 Other 41
3 Other 39
3 Other 43
3 Other 40
3 Other 46
3 Other 41
3 Other 42
3 Other 48
3 Other 42
3 Other 36
3 Other 37

Readmit2

Male Female
Admit 1 4 4
3 6
5 2
4 2
8 4
Admit 2 3 7
1 13
3 3
1 5
1 2
Admit 3 2 10
7 7
3 16
14 4
3 11

Test-Retest

Nothing Pamphlet Face to Face
1 Before 7 10 13
2 13 13 10
3 10 9 11
4 12 9 9
5 10 10 15
6 10 12 9
1 After 9 13 16
2 10 13 15
3 10 15 18
4 12 10 15
5 14 14 17
6 12 9 18