Research on diagnosis-related group grouping of inpatient medical expenditure in colorectal cancer patients based on a decision tree model

Table 1 Single factor analysis of the influencing factors on inpatient medical expenditure in colorectal cancer patients

Influencing factors	Number	Average medical cost in RMB yuan	t / F	P value
Gender			3. 732	0.025
Male	489	59273.4
Female	537	56596.6
Age in yr			3.184	0.011
≤ 0	118	47184.4
50-84	206	56413.4
60-13	290	59724.5
70-24	314	63554.3
> 80	98	50122.0
Length of hospital stay in d
≤ en	182	16967.4	145.352	0.000
11-005	592	60226.3
21-26	198	73877.1
> 30	56	109912.1
Surgery			231.157	0.000
Yes	910	63290.1
No	116	15371.1
Hospital infection				0.171
Yes	12	59790.5
No	1014	57849.7
Treatment
Maintenance therapy	144	55757.4		0.004
Radiotherapy	38	62032.2
Chemotherapy	662	56028.4
Radiotherapy and chemotherapy	182	65019.6

P < 0.05 was considered statistically significant.

Table 2 Multivariate analysis of high inpatient expenditure

Variable	Variable assignment	Regression coefficient	Standardregression coefficient	t	P value
Gender	Male = 0
	Female = 1	-0.007	-0.032	2.017	< 0.05
Age	Actual value	0.015	0.043	9.371	< 0.05
Length of hospital stay	Actual value	0.039	0.231	18.27	< 0.05
Surgery	No = 0				< 0.05
	Yes = 1	0.595	0.109	15.67	< 0.05
Treatment	Maintenance therapy = 0				< 0.05
	Radiotherapy = 1	5.294	0.042	2.62	< 0.05
	Chemotherapy = 2	4.786	0.073	2.37	< 0.05
	Radiotherapy and chemotherapy = 3	2.813	0.321	25.84	< 0.05

P < 0.05 was considered statistically significant.

Table 3 Grouping results and the predicted medical costs

Group No.	Combination description	Number	Mean in RMB yuan	Standard deviation	Median in RMB yuan	Upper limit in RMB yuan	CV
1	Surgery, maintenance therapy, age ≤ 67 yr	55	50726.7	14973.5	49335.7	71075.8	0.24
2	Surgery, maintenance therapy, age > 67 yr	45	53285.4	16784.2	51533.9	78229.0	0.42
3	Surgery, chemotherapy or radiotherapy, age ≤ 67 yr	351	56827.3	17256.3	55964.2	89934.1	0.33
4	Surgery, chemotherapy or radiotherapy, age > 67 yr	297	61154.3	15147.8	60924.5	91365.2	0.54
5	Surgery, chemotherapy and radiotherapy, age ≤ 67 yr	80	62244.6	18475.6	61574.3	93574.2	0.65
6	Surgery, chemotherapy and radiotherapy, age > 67 yr	82	65647.3	17985.1	65879.1	95498.3	0.14
7	Non-surgery, maintenance therapy, age ≤ 67 yr	12	41995.3	11425.5	42703.1	67470.7	0.31
8	Non-surgery, maintenance therapy, age > 67 yr	32	42203.3	12574.3	44217.5	68154.2	0.56
9	Non-surgery, chemotherapy or radiotherapy, age ≤ 67 yr	16	52309.7	16785.1	50557	71256.1	0.64
10	Non-surgery, chemotherapy or radiotherapy, age > 67 yr	36	52775	14287.1	51427.2	72546.3	0.45
11	Non-surgery, chemotherapy and radiotherapy, age ≤ 67yr	10	55681.4	17694.2	53214.5	76085. 4	0.41
12	Non-surgery, chemotherapy and radiotherapy, age > 67 yr	10	56930	21454.1	53945.7	78945.0	0.71

P < 0.05 was considered statistically significant. CV: Coefficient of variation within each group.