KEMBAR78
Assignment 1 Submitted DRK | PDF | Business | Business Economics
0% found this document useful (0 votes)
11 views7 pages

Assignment 1 Submitted DRK

The document provides a detailed dataset on various hospitals, including their Facility ID, State, Region, Hospital Ownership, and market share percentages for both outpatient and inpatient services. It also includes financial metrics such as Net Patient Revenue and Net Operating Margin. The data is categorized by nominal and continuous variables, allowing for analysis of hospital performance across different ownership types and geographical locations.

Uploaded by

John Ñjuru
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
0% found this document useful (0 votes)
11 views7 pages

Assignment 1 Submitted DRK

The document provides a detailed dataset on various hospitals, including their Facility ID, State, Region, Hospital Ownership, and market share percentages for both outpatient and inpatient services. It also includes financial metrics such as Net Patient Revenue and Net Operating Margin. The data is categorized by nominal and continuous variables, allowing for analysis of hospital performance across different ownership types and geographical locations.

Uploaded by

John Ñjuru
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
You are on page 1/ 7

Variable Variable Variable Values Level of

Variable Name Type Label Measurement


Facility ID String ID Nominal

1 = CA; 2 = CT; 3 = HI; 4 = IA; 5 = ID;


6 = IL; 7 = IN; 8 = MA; 9 = ME; 10 =
MI; 11 = MT; 12 = NE; 13 = NH; 14 =
NJ; 15 = NV; 16 = NY; 17 = OH; 18 =
OR; 19 = PA; 20 = RI; 21 = SD; 22 =
State Categorical ST UT; 23 = WI; 24 = WY Nominal

Region Categorical RE 1 = West; 2 = Northeast; 3 = Midwest Nominal

1 = Government – Hospital District or


Authority; 2 = Government - Local; 3 =
Proprietary; 4 = Voluntary Nonprofit –
Church; 5 = Voluntary non-profit –
Hospital Other; 6 = Voluntary non-profit -
Ownership Categorical H.O Private Nominal

% OP Market Share Continuous OP Scale


% IP Market Share Continuous IP Scale

Net Patient Revenue Continuous NPR Scale

% Net Operating Margin Continuous OPM Scale


Description/Survey Question
Facility ID

Location of Facility

Region where facility is located

Type of hospital ownership

Percent of Outpatient Market Share


Percent of Inpatient Market Share

Gross revenue earned by the


hospital for the provision of
inpatient and outpatient services

Determined by the formula:


operating revenue minus operating
cost divided by operating revenue
Facility ID State Region Hospital Ownership % OP Market Share
1 SD Midwest Voluntary non-profit - Private 27.8
12 OR West Voluntary non-profit - Other 49.9
13 HI West Voluntary non-profit - Private 38.7
14 NV West Voluntary non-profit - Private 34.2
15 CA West Voluntary non-profit - Church 42.4
16 MT West Voluntary non-profit - Private 64.7
17 ID West Voluntary non-profit - Private 46.5
18 WY West Government - Hospital District or Authority 42.7
20 UT West Voluntary non-profit - Private 57
23 MI Midwest Voluntary non-profit - Private 22.2
24 NE Midwest Voluntary non-profit - Private 46.7
25 IA Midwest Voluntary non-profit - Private 21.2
26 OH Midwest Voluntary non-profit - Private 38.4
27 IL Midwest Voluntary non-profit - Private 35.5
28 IN Midwest Government - Local 56.3
29 WI Midwest Voluntary non-profit - Church 31.8
30 PA Northeast Voluntary non-profit - Private 51.3
31 ME Northeast Voluntary non-profit - Church 62.5
32 NJ Northeast Voluntary non-profit - Private 49.2
33 CT Northeast Voluntary non-profit - Church 29.9
34 MA Northeast Voluntary non-profit - Other 34.4
35 NH Northeast Voluntary non-profit - Private 33.8
36 NY Northeast Voluntary non-profit - Private 35.2
37 RI Northeast Proprietary 44.2
% IP Market Share Net Patient Revenue % Net Operating Margin
21.9 $ 95,743,349.00 19
40.4 $ 121,470,401.00 20
43.5 $ 1,060,016,250.00 19
27.5 $ 772,562,788.00 18
46.1 $ 136,818,602.00 19
56.5 $ 216,888,165.00 17
53.7 $ 386,881,546.00 14
33.5 $ 163,940,522.00 16
47.2 $ 591,482,760.00 11
32.4 $ 326,188,268.00 12
46 $ 621,292,018.00 13
12.8 $ 60,491,409.00 18
52.9 $ 244,980,897.00 12
28.7 $ 87,218,585.00 16
75.3 $ 73,258,282.00 15
28.1 $ 187,184,723.00 13
36.8 $ 290,113,162.00 16
55.4 $ 136,339,076.00 16
52.7 $ 1,674,633,238.00 20
50.3 $ 871,474,435.00 20
69.2 $ 188,086,651.00 16
40.1 $ 476,953,814.00 20
18.2 $ 97,917,068.00 10
37.5 $ 171,941,138.00 10
Facility ID State Region Hospital Ownership % OP Market Share
1 21 3 6 27.8
12 18 1 5 49.9
13 3 1 6 38.7
14 15 1 6 34.2
15 1 1 4 42.4
16 11 1 6 64.7
17 5 1 6 46.5
18 24 1 1 42.7
20 22 1 6 57
23 10 3 6 22.2
24 12 3 6 46.7
25 4 3 6 21.2
26 17 3 6 38.4
27 6 3 6 35.5
28 7 3 2 56.3
29 23 3 4 31.8
30 19 2 6 51.3
31 9 2 4 62.5
32 14 2 6 49.2
33 2 2 4 29.9
34 8 2 5 34.4
35 13 2 6 33.8
36 16 2 6 35.2
37 20 2 3 44.2

1 8 1 41.52
1 8 1 11.76
1 8 1 40.55
1 4 21.2
1 33.33% 2 64.7
1 33.33% 15
1 33.33%
1 4.17%
1 4.17%
1 4.17%
1 16.67%
1 8.33%
1 62.50%
1
1
1
1
1
1
1
1
1
1
1

4.17%
4.17%
4.17%
4.17%
4.17%
4.17%
4.17%
4.17%
4.17%
4.17%
4.17%
4.17%
4.17%
4.17%
4.17%
4.17%
4.17%
4.17%
4.17%
4.17%
4.17%
4.17%
4.17%
4.17%
% IP Market Share Net Patient Revenue % Net Operating Margin
21.9 $ 95,743,349.00 19
40.4 $ 121,470,401.00 20
43.5 $ 1,060,016,250.00 19
27.5 $ 772,562,788.00 18
46.1 $ 136,818,602.00 19
56.5 $ 216,888,165.00 17
53.7 $ 386,881,546.00 14
33.5 $ 163,940,522.00 16
47.2 $ 591,482,760.00 11
32.4 $ 326,188,268.00 12
46 $ 621,292,018.00 13
12.8 $ 60,491,409.00 18
52.9 $ 244,980,897.00 12
28.7 $ 87,218,585.00 16
75.3 $ 73,258,282.00 15
28.1 $ 187,184,723.00 13
36.8 $ 290,113,162.00 16
55.4 $ 136,339,076.00 16
52.7 $ 1,674,633,238.00 20
50.3 $ 871,474,435.00 20
69.2 $ 188,086,651.00 16
40.1 $ 476,953,814.00 20
18.2 $ 97,917,068.00 10
37.5 $ 171,941,138.00 10

41.95 $ 377,244,881.13 16
15.27 389747232.636695 3.31
41.95 $ 202,487,408.00 16
12.8 $ 60,491,409.00 10
75.3 $ 1,674,633,238.00 20

You might also like