Analysis Question

[liquidmettle]

Hi Everyone!

This is only a pseudo-excel question.

Conducting a recent survey, one question asked respondents to rate the Mission Impact and the Financial Viability of a specific issue on a scale of High / Mid / Low.

My question is how should I assess this data and turn it into meaningful information.

I'm attempting to use the Dual Bottom Line Matrix approach but I've found that seems to rely more on getting hard financial data on a program or issue.

I've played with assigning High(1) Mid(0) and Low(-1) but I feel zeroing out the middle impact/viability is hurting the visualization of where the issue falls overall.

Lets say for Issue 1, we had the following distribution:

Mission Impact: 5 High votes, 2 Mid votes, 1 Low Vote

Financial Viability: 1 High votes, 4 Mid votes, 0 Low Votes (1 person not rating)

Any thoughts on how I take these numbers, toss them about, and make a meaningful Bubble chart in excel or some other visualization that captures the data?

Other thoughts / considerations / suggestions?

Thanks all!!

[MrShorty]

As you correctly note, I don't know how much of this is Excel, yet. Are you familiar with Likert scales? This was my first though from reading your description of the questionnaire/survey. Here's a page that describes entering and simple analysis for Likert type data: http://extra.centenary.edu/dotto/rel308/Measure.pdf

[liquidmettle]

Thanks MrShorty,

Yes I am familiar and in hindsight I wish I'd have used a larger 5 to 7 point scale (the Dual Bottom matrix I mentioned actually only has High / Low quadrants).

Even so your document is a helpful refresher on how to treat the results, so thank you for that!

I'll leave this open a little while longer to see if anyone else has additional suggestions, but otherwise I'll close it in a day or so.

Thanks!