Producing graphs representing segments from different sample sizes

Berglind

New Member
Joined
Mar 7, 2019
Messages
2
Hi there,

I'm producing some graphs based on a set of questionnaires. Some are Likert Scale statements and some are simple yes/no/don't know questions. We are trying to split the answers down by type of respondents: Amenity manager; productive managers; multi-functional managers; and conservation managers. We have 3 conservation respondents and 36 productive respondents. So in our graphs, conservation managers are always under represented. I then calculated the percentage within each segment which responded yes/no/don't know (24% of productive managers responded yes, 13% responded no etc - and not all participants responded to all questions, so in one case, only 1 of 3 conservation managers responded, so 33% of all conservation managers or 100% of conservation managers that responded. I've visualised this in simple bar-charts. The danger in this is that it gets quite confusing for people to understand what I've done, and it doesn't reflect the low sample sizes for some of the segments, inflating or deflating the results disproportionately. Is there any better way of doing this?
 

Excel Facts

Control Word Wrap
Press Alt+Enter to move to a new row in a cell. Lets you control where the words wrap.
Not an option I'm afraid. They have very different views and attitudes, and the segmentation was developed based on outcomes from past studies.
 
Upvote 0
You obviously understand low sample sizes mean dodgy information. So I would say only 1 out of 3 responded and no meaningful conclusion can be drawn. And I would contact the 3 and tell them it is imperative they respond.
 
Upvote 0

Forum statistics

Threads
1,224,823
Messages
6,181,181
Members
453,022
Latest member
Mohamed Magdi Tawfiq Emam

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top