I have excel sheet for data and I need analysis with appropriate charts.

Description

I collecred data for my audit. There are different headline for each category. First thing, I need the data in appropriate charts. For example: the sex Male/Female can be in chart to see how many Fs/Ms? and the same for other categories.The last column AO the title is PsA at 3 months.For data with number , for example eosinophil and Ige, FEV1 < and> 1 I am not sure how to do it so I need help with that.From column J to O, thses all medications so I am not sure if it is better to do it in one chart ??

Don't use plagiarized sources. Get Your Custom Assignment on
I have excel sheet for data and I need analysis with appropriate charts.
From as Little as $13/Page

Unformatted Attachment Preview

Sl No
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
MRN No
Age
4472336
351788
327783
4008551
455170
4641882
4144747
10792861
10462441
4208673
1251964
10299490
1626318
1251964
629996
10900982
212596
10298582
914576
1465914
752967
1509289
4008551
573030
10857561
10400216
459585
10214512
552584
1213760
4288788
987145
171373
571504
4710567
534514
546131
Sex
53 Female
61 Male
89 Female
33 Female
75 Male
26 Female
85 Female
81 Male
35 Female
76 Male
52 Female
63 Female
25 Female
52 Female
77 Female
45 Female
74 Female
17 Female
57 Female
29 Female
76 Female
37 Male
33 Female
72 Female
25 Male
72 Male
86 Female
36 Male
70 Female
66 Female
60 Male
76 Female
83 Female
82 Male
80 Female
74 Male
78 Male
Source of referral
Diagnosis
Inpatient
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
Bronchiectasis
Others
YES
NO
YES
NO
YES
NO
NO
NO
YES
YES
NO
YES
YES
NO
YES
YES
YES
YES
YES
NO
NO
YES
NO
NO
NO
NO
NO
YES
NO
NO
NO
YES
YES
NO
NO
NO
YES
NO
NO
YES
YES
NO
NO
YES
NO
NO
YES
NO
NO
YES
YES
NO
YES
NO
NO
YES
YES
NO
YES
YES
YES
NO
YES
YES
YES
YES
YES
NO
YES
YES
YES
NO
YES
NO
Out PatientCF
YES
NO
YES
NO
YES
NO
YES
YES
YES
NO
YES
NO
YES
NO
YES
NO
YES
NO
YES
NO
YES
YES
YES
YES
YES
YES
YES
YES
YES
NO
YES
YES
YES
NO
YES
YES
YES
NO
YES
YES
YES
NO
YES
YES
YES
YES
YES
NO
YES
YES
YES
NO
YES
NO
YES
YES
YES
NO
YES
NO
YES
NO
YES
NO
YES
NO
YES
NO
YES
NO
YES
NO
YES
NO
Sl No
MRN No
Age
Sex
Inpatient Out PatientCF
Bronchiectasis
Others
Male
YES
NO
Pre
FeV1>1
ICS – Y/N
YES
YES
YES
YES
YES
NO
NO
YES
YES
YES
YES
YES
NO
YES
NO
YES
YES
NO
NO
YES
YES
NO
YES
YES
NO
NO
YES
NO
NO
YES
NO
YES
NO
NO
YES
NO
NO
LD ICS – Y/NMD ICS – Y/N
HD ICS – Y/Ncarbocysteine
HTS- Yes/N
– Y/N Eosinophil>IgE>500
0.3 – Y/NY/NY/N
NO
NO
YES
YES
NO
N/A
N/A
YES
YES
NO
NO
YES
NO
NO
NO
YES
YES
NO
NO
YES
NO
NO
NO
YES
NO
YES
NO
NO
NO
YES
N/A
NO
NO
NO
YES
YES
NO
NO
YES
YES
NO
NO
NO
NO
YES
NO
NO
NO
N/A
YES
NO
YES
NO
YES
NO
N/A
N/A
NO
NO
YES
NO
YES
NO
NO
NO
YES
NO
YES
NO
YES
NO
YES
NO
YES
NO
NO
YES
YES
NO
YES
NO
YES
NO
YES
NO
NO
NO
N/A
N/A
YES
NO
NO
YES
NO
NO
NO
N/A
YES
NO
NO
YES
YES
NO
YES
NO
YES
NO
NO
YES
N/A
NO
NO
YES
NO
NO
NO
NO
N/A
YES
NO
YES
NO
YES
NO
NO
N/A
YES
NO
NO
YES
NO
YES
N/A
N/A
YES
YES
NO
NO
NO
NO
NO
N/A
YES
YES
NO
NO
NO
NO
N/A
N/A
NO
N/A
N/A
YES
NO
YES
NO
NO
NO
YES
N/A
NO
YES
NO
NO
YES
NO
N/A
N/A
YES
NO
YES
N/A
N/A
YES
YES
NO
NO
NO
YES
YES
NO
NO
NO
NO
N/A
N/A
YES
NO
NO
NO
NO
YES
YES
NO
NO
N/A
YES
NO
YES
NO
YES
YES
YES
YES
YES
YES
NO
NO
N/A
YES
NO
YES
NO
YES
YES
NO
NO
YES
NO
NO
NO
N/A
NO
NO
N/A
YES
YES
NO
NO
YES
NO
NO
N/A
YES
NO
N/A
YES
NO
N/A
YES
ICS – Y/N
LD ICS – Y/NMD ICS – Y/N
HD ICS – Y/Ncarbocysteine
HTS- Yes/N
– Y/N Eosinophil>IgE>500
0.3 – Y/NY/NY/N
YES
YES
YES
YES
Pre-test
FeV1>1
FEV1
FEV1%
Y/N
1.1
41 NO
1.14
34 NO
1.26
81 NO
YES
2.14
67 NO
2.68
82 NO
1.16
69 NO
YES
1.89
52 NO
1.34
36 NO
1.2
44 NO
3.3
96 NO
1.48
45 NO
1.37
48 NO
YES
1.13
43 NO
1.09
42 NO
2.84
70 NO
2.27
85 NO
1.46
51 NO
YES
1.75
39 NO
YES
1.58
71 NO
3.4
77 NO
1.39
53 NO
1.36
75 NO
1.36
33 NO
1.8
93 NO
1.62
70 NO
2.11
53 NO
1.6
87 NO
YES
1.77
63 NO
1.02
58 NO
2.89
96 NO
1.63
58 NO
FeV1
Purchase answer to see full
attachment