STAT535 Indiana University of Pennsylvania Applied Statistics Project Getting Started The purpose of the Project assignment in each STAT-535 workshop is t

STAT535 Indiana University of Pennsylvania Applied Statistics Project Getting Started

The purpose of the Project assignment in each STAT-535 workshop is to provide you with an opportunity to demonstrate your ability to apply the statistical tools you have learned in this course.

Resources
Assigned Statistics for Managers: Using Microsoft Excel reading
MyStatLab assignments
File: Patients dataset (Excel)

Background Information

In each workshop, you will be asked to demonstrate some of the knowledge you have gained by applying a few of the statistical tools that you have learned.

Instructions
Download the Patients dataset (Excel).
Create a table in which for each variable in the dataset, you :
Identify the variable as categorical, numerical discrete, or numerical continuous. (5 points)
Identify the level of measurement of each variable (nominal, ordinal, interval, or ratio). (5 points)
Create a bar chart comparing the average total charges between males and females. (10 points)
When you have completed your assignment, save a copy for yourself and submit a copy to your instructor using the Assignment submission page by the end of the workshop. Showing your work is required, not just providing answers without showing how you arrived at them. Length of Stay
3
3
11
3
9
3
3
3
3
5
3
2
3
3
5
3
4
3
2
3
4
1
2
3
4
6
2
1
4
5
3
2
4
15
3
6
4
2
5
9
3
3
5
5
7
4
ICU Days
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
1
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
Age (Years)
78
74
89
81
87
65
90
61
90
78
78
71
76
76
79
72
72
64
72
69
63
78
83
62
71
83
63
83
76
79
65
79
74
63
84
90
73
81
75
87
70
73
77
71
76
49
Sex (M/F/U)
F
F
M
M
F
M
M
F
M
F
M
M
F
F
M
M
M
F
F
M
M
M
F
M
F
F
M
F
M
M
M
M
M
M
F
F
M
F
F
M
F
M
M
M
F
Principal Payer
CARE
CARE
CARE
CARE
CARE
CARE
CARE
BC
CARE
CARE
CARE
CARE
CARE
CARE
CARE
CARE
CARE
CARE
CARE
CARE
HMO
CARE
CARE
OTHR
CARE
CARE
OTHR
CARE
CARE
CARE
CARE
CARE
CARE
OGVT
CARE
CARE
CARE
CARE
CARE
CARE
CARE
CARE
CARE
CARE
CARE
CAID
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
Total Chges
5,418.85
4,575.10
12,031.18
3,617.84
12,806.88
5,295.55
3,453.21
1,760.03
3,290.40
6,253.65
3,896.16
1,795.35
9,265.17
3,282.90
9,565.83
3,782.15
6,384.28
4,904.25
4,169.92
5,204.41
6,740.00
5,016.44
4,178.94
4,105.26
4,717.30
6,598.92
1,633.85
2,200.85
7,461.54
11,413.23
5,607.55
4,850.62
7,102.49
13,615.69
5,069.18
6,536.07
7,401.25
3,744.34
8,653.68
14,423.21
3,742.30
5,514.09
7,390.15
9,358.20
14,570.29
4,526.43
6
2
3
6
8
4
5
8
7
8
3
12
2
5
5
3
2
4
3
2
6
3
3
4
5
3
7
7
3
4
8
2
3
1
4
3
6
5
5
7
1
2
4
11
3
2
1
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
1
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
2
0
0
78
86
67
69
73
88
67
69
77
64
76
64
41
49
59
81
74
77
78
73
67
80
77
73
67
86
82
84
73
82
62
84
89
84
81
81
78
84
37
62
80
80
73
80
80
80
81
F
M
M
M
F
F
M
M
M
F
M
F
M
M
M
M
F
F
F
F
M
M
F
F
M
M
F
F
F
M
F
M
F
M
F
F
M
F
M
M
F
F
M
F
F
F
F
CARE
CARE
CARE
CARE
CARE
CARE
INS
CARE
CARE
CAID
CARE
CAID
SELF
CAID
BC
CARE
CARE
CARE
CARE
CARE
INS
CARE
CARE
CARE
CARE
CARE
CARE
CARE
BC
CARE
CARE
CARE
CARE
CARE
CARE
CARE
CARE
CARE
BC
BC
CARE
CARE
CARE
CARE
CARE
CARE
CARE
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
6,846.77
2,927.62
4,404.13
8,056.36
10,703.34
16,458.95
4,770.10
15,282.57
10,105.30
7,871.29
3,411.10
10,962.17
7,374.27
7,788.51
8,191.10
11,117.35
5,624.54
4,574.92
3,644.36
2,937.92
3,944.78
6,366.10
4,992.01
6,929.35
5,595.42
3,466.70
7,289.77
6,375.95
3,585.62
5,970.45
10,578.14
2,223.60
2,250.50
1,644.55
2,491.45
1,691.50
7,931.92
5,121.97
6,940.75
12,088.08
2,325.60
4,452.78
6,157.43
21,474.90
8,566.51
4,910.27
3,275.03
4
6
8
4
2
3
7
7
4
3
3
9
4
6
1
1
6
3
5
3
2
3
5
9
7
4
7
3
3
16
3
4
1
2
2
2
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
39
86
79
87
53
83
80
79
72
77
81
67
80
67
88
88
92
85
85
80
98
74
77
53
93
83
80
79
87
59
81
94
33
78
29
80
M
M
M
M
F
F
F
F
F
F
F
F
M
F
M
F
F
F
M
M
F
F
M
F
M
F
M
M
F
M
F
F
F
F
F
F
CAID
CARE
CARE
CARE
CARE
CARE
CARE
CARE
CARE
CARE
CARE
OTHR
CARE
OTHR
CARE
CARE
CARE
CARE
CARE
CARE
CARE
CARE
CARE
CARE
CARE
CARE
CARE
CARE
CARE
CARE
CARE
CARE
CAID
CARE
CARE
CARE
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
12,080.81
7,436.85
15,624.20
4,590.48
3,232.63
3,768.11
9,862.26
10,626.42
6,967.99
5,891.25
4,756.91
8,096.93
4,620.59
5,796.49
1,483.39
2,510.05
10,185.83
3,391.90
8,418.13
4,346.47
2,043.85
2,594.85
5,499.36
11,244.45
6,565.55
6,031.15
4,912.76
6,182.45
4,218.95
40,231.27
3,608.95
3,041.44
1,581.93
1,468.48
2,294.55
7,138.72
Drug Charges
$
68.70
$
58.65
$
230.28
$
142.89
$
889.23
$
102.50
$
122.15
$
161.18
$
235.65
$
103.05
$
229.06
$
52.05
$
211.37
$
298.40
$
477.03
$
166.85
$
342.98
$
208.65
$
545.15
$
510.01
$
480.20
$
401.44
$
604.49
$
90.46
$
120.90
$
380.17
$
20.85
$
21.00
$
508.34
$
1,149.88
$
230.50
$
172.52
$
259.09
$
438.84
$
282.90
$
122.85
$
216.90
$
176.24
$
246.63
$
527.63
$
112.95
$
368.34
$
331.25
$
491.35
$
286.74
$
203.98
Lab Charges
$
273.50
$
439.50
$
816.50
$
387.00
$
795.50
$
837.00
$
323.00
$
35.00
$
243.00
$
487.50
$
222.00
$
58.00
$ 1,626.50
$
381.50
$
974.00
$
345.00
$
644.85
$
768.00
$
375.50
$
870.50
$ 1,091.50
$
630.00
$
433.50
$
222.00
$
496.00
$
386.00
$
207.00
$
176.00
$ 1,082.50
$ 1,335.50
$
969.35
$
867.00
$
881.00
$ 1,930.00
$
476.50
$
651.00
$
971.50
$
394.00
$
859.00
$ 2,138.00
$
396.50
$
874.50
$
696.00
$ 1,223.50
$ 1,090.00
$
378.50
Imaging Charges
$
832.00
$
725.00
$
187.00
$
93.50
$
827.50
$
959.50
$
103.00
$
$
117.50
$
941.00
$
93.50
$
216.00
$
1,255.00
$
214.00
$
214.00
$
93.50
$
307.50
$
832.00
$
557.00
$
158.00
$
925.50
$
158.00
$
1,188.50
$
725.00
$
631.50
$
832.00
$
93.50
$
117.50
$
1,071.50
$
267.00
$
738.50
$
845.50
$
780.00
$
912.00
$
832.00
$
947.50
$
845.50
$
1,291.50
$
767.00
$
925.50
$
93.50
$
200.50
$
825.00
$
1,230.80
$
939.00
$
725.00
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
RT Chge
660.85
276.50
1,312.30
231.95
1,526.35
177.45
23.45
303.85
446.55
477.05
39.30
827.65
476.75
2,017.80
253.60
605.30
369.60
803.77
599.05
734.40
246.75
217.05
226.15
88.30
202.75
340.65
1,442.15
289.15
206.05
773.85
1,911.70
345.80
458.05
562.10
80.00
942.10
1,069.00
340.65
371.55
661.90
736.95
921.80
608.95
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
162.57
145.42
161.78
331.66
618.64
813.55
236.30
1,704.77
597.30
606.64
124.70
712.67
361.47
478.85
661.65
142.35
149.69
159.82
126.46
50.67
602.98
169.15
148.66
679.25
582.56
78.15
162.77
275.30
276.29
156.45
696.94
36.25
182.70
19.40
84.45
10.45
746.06
479.99
768.55
592.43
101.50
160.38
193.61
1,420.14
446.11
307.97
152.28
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
657.50
606.50
630.00
642.00
1,297.50
1,050.50
747.00
1,860.00
1,251.00
550.00
356.50
697.00
600.50
610.00
800.00
318.00
542.00
186.50
220.50
268.00
462.00
1,130.00
569.50
1,286.50
714.00
408.50
821.50
1,692.50
578.00
711.50
1,329.35
229.00
205.50
142.00
114.00
114.00
707.00
981.35
1,791.50
971.80
440.50
276.50
540.50
2,302.00
1,393.50
707.00
414.50
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
93.50
107.00
93.50
767.00
692.50
971.50
93.50
1,153.00
1,304.50
200.50
187.00
321.00
736.50
117.50
736.50
1,348.50
673.50
93.50
971.50
818.50
1,135.50
980.00
187.00
818.50
93.50
951.50
738.50
783.65
725.00
117.50
107.00
93.50
64.50
200.50
930.00
825.00
1,566.00
107.00
107.00
725.00
2,128.00
214.00
107.00
107.00
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
181.00
543.10
491.10
367.15
958.30
2,114.60
2,221.30
877.00
725.05
93.15
1,144.35
554.00
500.85
445.30
50.85
326.40
612.50
30.90
134.65
272.25
766.70
848.75
338.25
825.85
755.65
40.00
1,084.85
2,058.75
253.10
226.85
137.00
381.70
12.95
2,030.60
314.90
922.10
2,170.60
69.05
720.00
1,140.57
2,765.60
1,505.55
820.70
573.05
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
708.40
242.70
462.40
414.40
200.90
216.01
432.36
449.47
176.89
260.65
104.66
473.98
178.59
472.74
30.34
82.45
403.13
49.60
281.48
108.11
49.20
131.60
153.91
500.30
710.00
294.60
468.01
234.85
183.45
2,768.32
290.77
109.59
141.78
175.18
402.98
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
971.50
700.50
2,372.00
966.00
320.00
312.50
1,504.00
1,011.40
1,062.00
1,215.50
893.50
862.50
535.00
1,007.00
172.00
485.00
1,054.50
588.50
758.00
411.00
214.00
496.00
289.50
657.00
725.00
1,313.00
333.50
843.50
309.50
4,618.00
457.50
484.00
539.50
209.00
1,317.50
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
1,374.00
1,183.00
2,965.65
187.00
93.50
196.50
321.00
107.00
1,658.20
107.00
725.00
818.50
296.00
93.50
214.00
188.50
832.00
725.00
93.50
725.00
186.50
155.50
660.00
738.50
117.50
351.25
187.00
832.00
99.00
1,609.00
941.00
107.00
187.00
300.50
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
881.10
834.65
2,097.17
667.65
425.80
917.75
1,555.25
2,113.85
221.60
465.50
87.10
1,708.65
307.90
1,399.30
136.30
148.65
1,920.75
44.45
75.20
266.05
268.55
528.20
1,154.80
793.10
684.15
930.65
304.30
8,792.50
225.90
569.00
230.75
237.65
688.75
261.45
Freedom Hospital Geriatric Patient Analysis
File:
Patients.xlsx
Variable Definitions:
Column A:
Column B
Column C:
Column D:
Column E:
Length of Stay in Days
Number of Day in the Intensive Care Unit
Patient’s Age
Sex – M= Male, F = Female
Principal Payer – CARE = Medicare, BC = Blue Cross, HMO = Health maitenance Organizatio
CAID = Medicade, OGVT = Other Government Program, INS = Private Insurance
OTHR = Other form of Payment
Column F: Total Charges during Hospital Stay
Column G: Total Drug Charges
Column H: Lab Charges
Column I: Imaging Charges
Column J: Respiratory Therapy Charges
Program, INS = Private Insurance, SELF = Private Pay,

Purchase answer to see full
attachment