Best way of summarising results from a Likert scale survey?

[chris1089]

Hi

Could you please help with the below as I'm not experienced. What is the best way of summarising results from a likert Survey. For example how can I show:

- The average confidence for each report type. For example, out of the 8 people that responded, what was the average confidence level for report 1? The workbook attached breaks down confidence into 5 levels > not confident (1) at all to extremely confident(5)2 (if possible please include filters)
- Confidence per person (clustered bar graph showing all 8 people's confidence levels as a average). I'm not sure if this should be sum or average but i think average is best (if possible please include filters)
- The sum confidence for each report type shown as a clustered bar graph (the clustered bar graph would show all 5 confidence levels)


In summary, these individuals are meant to present these reports. So I'm trying to figure out in the simplest way who is most or least confident. Which reports have the number of least confident people.

[AliGW]

Administrative Note:

We would very much like to help you with your query, however the thread title does not really convey what your request is about. Tell us what you are trying to do, not how you think it should be done.

Please take a moment to amend your thread title. Make sure that the title properly explains your request. Your title should be explicit and not be generic (this includes function names used without an indication of what you are trying to achieve).

Please see Forum Rule #1 about proper thread titles and adjust accordingly. To edit the thread title, open the original post to edit and then click on Go Advanced (bottom right) to access the area where you can edit your title.

(Note: this change is not optional. No help to be offered until this moderation request has been fulfilled.)

[chris1089]

Administrative Note:

We would very much like to help you with your query, however the thread title does not really convey what your request is about. Tell us what you are trying to do, not how you think it should be done.

Please take a moment to amend your thread title. Make sure that the title properly explains your request. Your title should be explicit and not be generic (this includes function names used without an indication of what you are trying to achieve).

Please see Forum Rule #1 about proper thread titles and adjust accordingly. To edit the thread title, open the original post to edit and then click on Go Advanced (bottom right) to access the area where you can edit your title.

(Note: this change is not optional. No help to be offered until this moderation request has been fulfilled.)

Thank you, I've been the modification. Is this ok?