M
matt3542
Dear Forum,
I would be very grateful if anyone can provide a solution to the following
problem;
I have a dataset as per the example below that consists of text and numbers.
I am trying to determine the mode based on the text entries and not the
number entries. In the example below the entry "ear infection" would
represent the text mode as it appears the most amount of times. The number
values represent sub totals.
Ear infection
Ear infection
Sinusitis
Ear infection
D&V
5
D&V
Rash on leg
Migraine
3
Many Thanks
Matt
I would be very grateful if anyone can provide a solution to the following
problem;
I have a dataset as per the example below that consists of text and numbers.
I am trying to determine the mode based on the text entries and not the
number entries. In the example below the entry "ear infection" would
represent the text mode as it appears the most amount of times. The number
values represent sub totals.
Ear infection
Ear infection
Sinusitis
Ear infection
D&V
5
D&V
Rash on leg
Migraine
3
Many Thanks
Matt