diabetes complication risk calc-logistic.xlsx

	A	B	C	D	E	F	G	H	I	L	M	N
1		diabetes complication risk calculator
2		Results from logistic regression					User enters data in red
3
4										steady state
5	Term	Estimate	Std Error	ChiSquare	p value		value			glucose	logit	risk
6	Intercept	-14.703	3.231	20.706	0.0000		1			120	-3.360	3.36%
7	obese	0.328	0.615	0.284	0.5939		0.1	<- value between 0 and 1		125	-3.248	3.74%
8	fastglu	0.108	0.030	12.457	0.0004		80	<-fasting glucose, mg/dl		130	-3.135	4.17%
9	steadyglu	0.023	0.005	18.323	0.0000		150	<-steady state glucose, mg/dl		135	-3.022	4.64%
10										140	-2.909	5.17%
11		Odds ratio	lower	upper			estimate	lower	upper	145	-2.796	5.75%
12	obese	1.388	0.416	4.631		logit	-2.684			150	-2.684	6.39%
13	fastglu	1.114	1.049	1.182		Odds	0.06831099113			155	-2.571	7.10%
14	steadyglu	1.023	1.012	1.033		risk	6.4%			160	-2.458	7.88%
15										165	-2.345	8.74%
16										170	-2.233	9.69%
17										175	-2.120	10.72%
18										180	-2.007	11.85%
19										185	-1.894	13.08%
20										190	-1.781	14.41%
21										195	-1.669	15.86%
22										200	-1.556	17.42%
23										205	-1.443	19.11%
24										210	-1.330	20.91%
25										215	-1.217	22.84%
26										220	-1.105	24.89%
27										225	-0.992	27.05%
28										230	-0.879	29.34%
29										235	-0.766	31.73%
30										240	-0.654	34.22%
31										245	-0.541	36.80%
32										250	-0.428	39.46%
33										255	-0.315	42.18%
34										260	-0.202	44.96%
35										265	-0.090	47.76%
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100