Data Code Description

This file has the following three sheets
1. Data Description sheet: Provides data dictionary

2. Raw data: Contains information about 248 patients
3. Modified data: Raw data is modified data by introducing dummy
variables
Data Code Description

AGE Age of the patient
Gender code for patient:
GENDER Male
Female
Marital Status of the patient:
MARITAL STATUS Married
Un Married
BODY WEIGHT Weight of the patient
BODY HEIGHT Height of the patient
HR PULSE The pulse of patient at the time of admission
BP-HIGH High BP of the patient (Systolic)
BP-LOW Low BP of the patient (Diastolic)
RR Respiratory rate of patient
HB Hemoglobin count of patient
UREA Urea levels of patient
CREATININE Creatinine levels of patient
The way in which the patient arrived the hospital:
Ambulance
MODE OF ARRIVAL
Transferred
Walked In
State in which the patient arrived:
STATE AT THE TIME OF
Alert
ARRIVAL
Confused
Type of admission for the patient:
TYPE OF ADMISSION Elective
Emergency
TOTAL COST TO HOSPITAL The actual cost incurred by the hospital
TOTAL LENGTH OF STAY Number of days patient stayed in the hospital
LENGTH OF STAY-ICU Number of days patient stayed in the ICU
LENGTH OF STAY-WARD Number of days patient stayed in the ward
IMPLANT USED (Y/N) Any implant is is done on the patient
COST OF IMPLANT The total cost of all the implants done on the patient if any
DESCRIPTIVE STATISTICS
Total Cost of
hospital
Mean 198723.33
Standard Error 7784.31
Median 162660.50
Mode 129474.64
Standard
Deviation 122587.49
Sample Variance 15027693436.14
Kurtosis 8.09
Skewness 2.46
Range 841257.00
Minimum 46093.00
Maximum 887350.00
Sum 49283385.91
Count 248
UNIVARIATE ANALYSIS:
Age Count of
AGE
0-10 91
10-20 42
20-30 9
30-40 9
40-50 21
50-60 29
60-70 29
70-80 16
80-90 2
Grand 248
Total
INFERENCE:
From the given data it can be analyzed that from among 248 people:
o People admitted to the hospital are maximum from age 0-10 which consist of 37% of total
people and the second highest is covered by teenagers and young adults which is 17%. And the
lowest admission is from age 60-70 which is 1%.
o This represents that kids are more prone to diseases and fall ill followed by teens who have a
hectic schedule and different habits and the least people who visit the hospital are people who
are very old. they visit only during emergencies.
o This shows that the hospital needs more pediatricians as compared to other specialists.
BI-VARIATE ANALYSIS
Count of GENDER Type of Admission
AGE ELECTIVE EMERGENCY Grand Total
0-10 91 91
10-20 41 1 42
20-30 9 9
30-40 7 2 9
40-50 19 2 21
50-60 23 6 29
60-70 17 12 29
70-80 8 8 16
80-90 1 1 2
Grand Total 216 32 248
INFERENCE:
From the data given above this can be inferred that
o Out of 248 people there are maximum cases of elective
admission as compared to emergency cases.
o Total emergency cases are 32 which shows that there are
fewer patients with critical issues.
o Maximum elective cases are from age 0-10, who are kids and
more prone to fall sick.
o The hospital needs more wards for patients who are elective
one’s.
o There are maximum emergency cases for people aged 60-70.
MULTIVARIATE ANALYSIS
AGE Average of Average of

UREA CREATININE
F 26.98333333 0.575
0-10 23.25 0.363333333
10-20 22.33333333 0.446153846
20-30 23 0.666666667
30-40 27 0.84
40-50 33.28571429 0.783333333
50-60 21.75 0.675
60-70 54.67142857 1.3
70-80 25 1
M 26.38216561 0.826530612
0-10 24.10714286 0.412765957
10-20 24.36363636 0.668181818
20-30 18.75 0.975
30-40 18 0.95
40-50 32.75 0.961538462
50-60 25.79166667 1.023809524
60-70 25.33333333 1.033333333
70-80 38.14285714 1.593333333
80-90 33.5 1
Grand Total 26.58170213 0.746976744
INFERENCE:
From the above data this can be inferred that
o Creatinine levels in the blood can vary depending on age,race and body size. A creatinine
level of greater than 1.2 for WOMEN and >1.4 for MEN might be an early sign that the
kidney is not working properly.
o Urea is another measure to detect kidney failure and In general, around 7 to 20 mg/dL
(2.5 to 7.1 mmol/L) is considered normal.
o AVERAGE OF UREA can be seen highest among people aged 60-70 and in female.
HISTOGRAM
Bin Frequency
50000 3
100000 16
150000 87
200000 64
250000 28
300000 16
350000 10
400000 8
450000 6
500000 1
550000 3
600000 1
650000 1
700000 1
750000 1
800000 0
850000 1
900000 1
More 0
Histogram
100
90
80
70
Frequency
60
50
40
Frequency
30
20
10
0
Bin

Data Code Description

Uploaded by

Copyright:

Available Formats

Data Code Description

Uploaded by

Document Information

Original Description:

Original Title

Copyright

Available Formats

Share this document

Share or Embed Document

Sharing Options

Did you find this document useful?

Is this content inappropriate?

Copyright:

Available Formats

Data Code Description

Uploaded by

Copyright:

Available Formats

This file has the following three sheets

1. Data Description sheet: Provides data dictionary

Data Code Description

AGE Average of Average of

You might also like