NHS COVID 19 Infection and The Risk of Developing Pulmonary Fibrosis Analysis Report
I am working on a small study. It is about COVID-19 infection and the risk of developing pulmonary fibrosis.
I have the excel data sheet, and there are many variables.
I need help with the SPSS system to help analyze the data.
Basically, I want to know if there is any association between each variable and the risk of developing pulmonary fibrosis in COVID patients.
So please, I need an expert in SPSS to help me to analyse the data very carefully and to formulate tables/ charts or others to simplify the data analysis.
-From the biochemical and vascular data, troponin level, I don’t want it a single number, I prefer if it can be range, for example, troponin level <15, 15-30, 30-60, unknown etc, this is just an example.
-For the treatment and ventilatory support, also I prefer if it can be in ranges. Maximum FIO2, for example: 0-28%- 29-40%, 41-60%, 61-80%, 81-100%, unknown.
-Days on O2 as IP lsoo in ranges: ,2weeks, 2-4weeks, 4-8 weeks, > 8weeks
Wexham Park Hospital post COVID fibrosis audit 2021
Demographics
Hospital Number DOB
43805
1371165
1546589
386190
4244928
5344816
400315
5391985
60906
1410383
1668979
286491
1590363
1723430
1741649
1681038
1607766
1767255
1677773
1131972
1682853
1403102
1053091
3787806
1318307
241048
1507981
5327494
1164893
5363813
1803616
4733192
3779475
5388762
1707388
1428092
Risk Factors
Age
8/1/1942
20/8/1961
1/3/1959
11/3/1960
3/3/1966
26/3/1970
23/4/1960
20/4/1937
5/5/1952
28/8/1948
8/8/1975
14/5/1953
12/7/1952
6/6/1973
24/6/1946
9/9/1949
21/7/1951
21/2/1941
1/1/1955
26/7/1942
23/7/1965
22/11/1941
12/6/1962
26/5/1967
24/4/1940
11/1/1946
25/6/1961
19/10/1958
9/9/1954
23/3/1960
29/9/1949
21/7/1957
9/8/1956
4/4/1944
27/11/1943
8/4/1928
M/F
79 Male
59 Female
62 Female
61 Male
55 Male
51 Male
61 Female
83 Female
69 Male
72 Male
45 Female
67 Male
68 Male
47 Male
74 Male
71 Female
69 Male
80 Male
66 Female
79 male
56 Male
79 Male
58 Female
54 Male
81 Male
74 male
60 Male
63 Female
67 Male
61 Male
72 Male
64 Male
65 Male
76 Male
77 Male
93 Female
Ethnicity
Diabetes
Asian or Asian British
Yes
Asian or Asian British
Yes
White
No
Mixed: white and Black/Asian/Other
No
Mixed: white and Black/Asian/Other
No
White
No
Asian or Asian British
Yes
White
No
White
Yes
Asian or Asian British
Yes
White
No
Asian or Asian British
Yes
Asian or Asian British
No
Asian or Asian British
No
White
Yes
Asian or Asian British
Yes
Asian or Asian British
Yes
White
No
Asian or Asian British
Yes
Asian or Asian British
Yes
White
No
White
No
White
No
Asian or Asian British
No
White
No
Asian or Asian British
No
White
No
White
No
Asian or Asian British
Yes
Asian or Asian British
No
White
No
Asian or Asian British
No
Asian or Asian British
Yes
White
No
White
No
White
No
200750
0090160
5157899
1507981
1488943
1164893
1502342
5327494
4892243
0286491
1236766
0279909
1796163
4733192
4281228
1723430
1443687
1507616
1707323
207669
0200750
0133847
0207669
1633665
1139315
1294767
5396030
1551736
269092
1106118
4916356
5267822
120913
288375
5397420
104548
1758834
4951317
4358259
277122
12/6/1954
14/10/1952
5/9/1975
25/6/1961
7/3/1961
9/9/1954
16/7/1938
19/10/1958
21/4/1943
14/5/1953
1/10/1964
8/4/1942
12/6/1960
21/7/1957
21/1/1976
6/6/1973
4/11/1938
2/11/1932
15/8/1931
18/11/1959
12/6/1954
4/5/1949
18/11/1959
27/5/1939
15/5/1959
17/10/1952
17/4/1956
14/2/1952
21/5/1979
23/10/1964
1/1/1964
14/8/1981
1/8/1933
16/6/1962
19/1/1976
15/8/1968
27/5/1959
26/7/1973
11/11/1943
22/5/1962
67 Female
69 Female
46 Male
59 Male
59 Male
67 Male
83 Male
63 Female
78 Male
68 Male
57 Male
79 Female
61 Male
64 male
45 Female
48 male
83 male
89 male
90 Female
62 Female
68 Female
73 Female
62 Female
83 Female
63 Male
69 Male
66 Female
70 Female
43 Female
57 Female
58 Female
40 Male
88 Female
60 Female
46 Male
53 Female
63 Male
48 Female
78 Male
60 Female
Asian or Asian British
Yes
White
No
White
No
White
No
White
No
Asian or Asian British
Yes
White
No
White
No
Asian or Asian British
Yes
Asian or Asian British
Yes
Asian or Asian British
Yes
White
No
White
Yes
Asian or Asian British
No
White
No
Asian or Asian British
No
White
No
White
No
Asian or Asian British
No
Asian or Asian British
Yes
Asian or Asian British
Yes
White
No
Asian or Asian British
Yes
Asian or Asian British
No
Asian or Asian British
No
Asian or Asian British
Yes
Mixed: white and Black/Asian/Other
No
Asian or Asian British
Yes
Asian or Asian British
No
Asian or Asian British
Yes
Asian or Asian British
No
Asian or Asian British
No
White
No
White
No
Asian or Asian British
No
White
No
White
No
Mixed: white and Black/Asian/Other
No
White
No
White
No
Risk Factors
HTN
Yes
No
No
No
No
No
Yes
Yes
No
No
No
No
No
Yes
Yes
Yes
Yes
Yes
No
Yes
No
Yes
Yes
No
Yes
No
No
No
No
Yes
Yes
Yes
No
No
Yes
Yes
CKD
Yes
Yes
No
No
No
No
No
No
Yes
No
No
No
No
No
No
Yes
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
Yes
No
No
Obesity/
BMI>30
Yes
No
Yes
No
No
No
No
No
No
No
Yes
No
No
Yes
No
Yes
No
No
No
No
No
Yes
No
No
No
No
No
No
No
No
No
No
No
No
No
No
Smoking history
No
No
No
No
No
No
No
No
No
Yes
No
Yes
No
No
Yes
No
No
No
No
Unknown
No
No
Yes
No
No
Yes
No
Unknown
No
Unknown
No
No
Unknown
Unknown
Yes
No
Underlying lung/ airways disease
None
Asthma
Asthma
None
Asthma
None
None
Asthma
None
COPD
Asthma
Asthma
None
None
Pulmonary fibrosis
None
Asthma
None
None
None
None
None
None
None
None
Pulmonary fibrosis
None
None
None
None
None
None
None
None
None
None
Known AI/ CTD
No
No
No
No
No
No
No
No
No
No
No
No
No
No
Yes
No
No
Yes
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
Yes
No
No
No
No
No
No
No
No
Yes
No
Yes
No
No
Yes
No
No
Yes
Yes
No
No
Yes
Yes
No
No
No
No
No
No
Yes
No
Yes
No
No
No
Yes
No
No
No
No
No
No
No
No
No
No
Yes
No
No
No
No
No
No
No
No
No
Yes
Yes
No
No
No
Yes
No
Yes
No
No
No
No
No
No
No
No
No
Yes
No
No
No
Yes
No
No
No
No
Yes
No
No
Yes
No
No
No
No
No
No
No
No
No
No
No
No
Yes
No
Yes
Yes
No
No
Yes
No
Yes
No
Yes
No
No
Yes
No
Yes
Yes
No
No
No
Unknown
Unknown
Unknown
No
Unknown
No
Unknown
Unknown
No
Unknown
No
Unknown
Unknown
No
Yes
Unknown
Yes
No
Unknown
Unknown
Unknown
No
Unknown
No
No
Unknown
No
No
No
Unknown
Unknown
Unknown
Yes
Unknown
No
No
No
No
Yes
Yes
Asthma
None
None
None
None
None
None
None
None
Asthma
None
COPD
None
None
COPD
None
COPD
None
none
None
Asthma
None
None
Asthma
None
None
Asthma
None
None
Asthma
None
None
None
Asthma
None
None
None
None
None
Pulmonary fibrosis
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
Yes
Biochemical and vascular data
SOB at
Chest pain at Highest Dpresentation? presentation? dimer level
No
No
1000-5000
Yes
No
Yes
Yes
10000
Yes
No
Yes
No
>10000
No
No
>10000
No
No
1000-5000
Yes
No
10000
No
No
Yes
No
Yes
No
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
not done
not done
not done
1000-5000
1000-5000
1000-5000
1000-5000
1000-5000
10000
1000-5000
1000-5000
1000-5000
1000-5000
10000
>500
>1000
200-500
>1000
200-500
>500
>1000
>500
200-500
>500
>5000
>500
3-16
3-16
3-16
200-500
>1000
>1000
200-500
200-500
>500
>500
>100
>500
200-500
1000
200-500
>1000
>500
not done
not done
200-500
200-500
200-500
>500
3-16
3-16
17-30
31-50
51-100
3-16
3-16
3-16
17-30
not done
200-500
>1000
>1000
200-500
>500
>1000
200-500
>500
>1000
>500
not done
200-500
>500
200-500
200-500
200-500
200-500
200-500
200-500
200-500
200-500
not done
Highest CRP
level
>200
>100
300
300
>300
>200
>51
>51
300
>51
>100
>300
>300
51
>51
>100
>200
>200
>300
>200
>51
>100
>100
>100
>300
>200
>100
>100
>100
>51
>100
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
No
Yes
Yes
No
No
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
No
No
No
No
No
No
No
No
No
No
Yes
No
No
No
No
No
No
No
Yes
No
No
No
No
No
No
Yes
No
Yes
No
Yes
No
No
No
No
No
No
No
No
No
No
1000
>1000
>500
200-500
not done
>1000
200-500
200-500
500
>1000
200-500
not done
>1000
>500
>1000
1000
10 200-500
28 >500
26 >1000
47 >1000
6 >500
28 >1000
15 >1000
6 200-500
27 >500
16 200-500
11 >1000
7 >1000
15 >1000
67 >1000
4 >1000
65 >500
22 >1000
27 >500
13 >1000
16 500
>200
200-500
>100
200-500
>51
200-500
>100
not done
not done
200-500
200-500
>100
200-500
>100
200-500
>51
200-500
>100
>500
>100
200-500
>100
not done
not done
>500
>100
200-500
>51
100
100
200-500
>100
>500
>51
>500
500
>200
200-500
>200
>1000
>200
haemolysed >51
51
200-500
>300
>500
>51
>500
>100
>500
>300
>500
>100
200-500
>200
200-500
1