OPINIONS AS DATA

I’ve created a video describing how to make this in Excel and you can get it HERE.

Also, I’ve created a template that you can download and use HERE.

Finally, HERE is the YouTube video instructions.

As many of you know, I’m a huge proponent of the communication style of Why, then How, then What. Because of this, I’ve come across a lot of opinionated information – asking people why they may want or do something, how they do it, and then what it is they actually do.

Not long ago I sent a survey out to my co-workers asking them why we do a few things as an organization to start a mission statement for the group I was tasked with forming. This brought back a bunch of results with no, absolutely none, data to work with. For a couple years now, as well, I’ve been collecting surveys from our training clients (with a few questions to be hand-written) to see how we might better serve them and improve in our quality. It’s great having that information, but can we really interpret these opinions into actionable paths for improvement? Maybe. If there are a few.

So, I started researching and finally built a tool (in Excel) to turn opinions into measurable results; in more technical terms – qualitative results into quantifiable data.

This is a valuable tool for anyone that wants to rightly know what clients, employees, friends, groups, or even one’s self, are thinking, want, need….

Simply, send out a survey:

  1. In a class
  2. On Facebook
  3. As an email
  4. Using MailChimp
  5. A pros and cons list
  6. Whatever

Use the results with this method, and you’ll have the DATA you want to make the decisions you see best.

This tool was built in Excel, however, the concept can be used in any logic program I believe.

Below I describe the process:

  1. Get your survey responses
  2. Enter them into a data bank (some electronic tool or list that can sort and assign)
  3. Create overarching categories that describe all the variables in the responses
    • ex. capture
  4. Assign the categories a code
  5. Go through all of the responses and assign them a category code
  6. Sum the results of each category

I’ve created a video describing how to make this in Excel and you can get it HERE.

Also, I’ve created a template that you can download and use HERE.

Hopefully, this brings some enrichment to your life. I know it is to me. If you have any feedback, comments, questions, etc I’d be really happy to hear from you.

Thanks for reading,

Jase

Published by Jason Kleinhenz

Why: I’m passionate about family, friends, community, helping people, rugby, and drumming. How: I’m involved in cultivating culture, philanthropy, startups and new ventures, young professionals, mentors and mentoring, biomedical engineering, cross functional and cross disciplined teams, sharing, and love. What: I’m an engineer, business owner, drummer, rugby player, philanthropist, community lover, and passionate beach bum. More info: You can see my other pages for more information, and please feel free to contact me if you think we could have a mutually beneficial discussion. If you’d like to get in touch, please feel free to say hello through any of the social links below.

1,076 thoughts on “OPINIONS AS DATA”

  1. I highly advise steer clear of this site. The experience I had with it was nothing but disappointment along with suspicion of fraudulent activities. Be extremely cautious, or better yet, seek out an honest service to meet your needs.

    Reply

  2. I highly advise steer clear of this site. My personal experience with it was only frustration and concerns regarding scamming practices. Proceed with extreme caution, or even better, find a more reputable service to fulfill your requirements.

    Reply

  4. I highly advise stay away from this platform. My own encounter with it was nothing but dismay along with concerns regarding fraudulent activities. Be extremely cautious, or better yet, find a trustworthy service to meet your needs.

    Reply

  5. I highly advise to avoid this platform. My personal experience with it has been purely dismay and concerns regarding scamming practices. Proceed with extreme caution, or even better, find a trustworthy site for your needs.

    Reply

  6. I highly advise steer clear of this site. My personal experience with it has been only dismay and suspicion of deceptive behavior. Exercise extreme caution, or better yet, find an honest platform to fulfill your requirements.

    Reply

  7. I urge you stay away from this site. My personal experience with it was purely frustration along with concerns regarding fraudulent activities. Proceed with extreme caution, or alternatively, seek out a more reputable service to fulfill your requirements.

    Reply

  8. I strongly recommend to avoid this site. My personal experience with it has been only dismay and doubts about scamming practices. Exercise extreme caution, or alternatively, find an honest site to fulfill your requirements.

    Reply

  9. I strongly recommend stay away from this site. My personal experience with it was purely frustration and doubts about scamming practices. Exercise extreme caution, or even better, look for a more reputable platform to meet your needs.

    Reply

  10. I strongly recommend stay away from this site. My personal experience with it has been only frustration and doubts about scamming practices. Be extremely cautious, or better yet, seek out a trustworthy platform to fulfill your requirements.

    Reply

  11. I urge you steer clear of this platform. My personal experience with it has been only frustration along with suspicion of fraudulent activities. Exercise extreme caution, or alternatively, find a trustworthy platform for your needs.

    Reply

  18. I highly advise steer clear of this platform. My own encounter with it was nothing but frustration as well as doubts about fraudulent activities. Be extremely cautious, or even better, find a trustworthy platform for your needs.

    Reply

  19. I strongly recommend to avoid this site. My own encounter with it has been purely frustration along with concerns regarding deceptive behavior. Proceed with extreme caution, or better yet, seek out a more reputable platform to fulfill your requirements.

    Reply

  20. I strongly recommend to avoid this site. My own encounter with it has been purely dismay along with suspicion of scamming practices. Exercise extreme caution, or even better, seek out a trustworthy platform to meet your needs.

    Reply

  21. I strongly recommend steer clear of this platform. My own encounter with it was purely frustration and suspicion of deceptive behavior. Proceed with extreme caution, or better yet, find a more reputable site to meet your needs.

    Reply

  22. I highly advise steer clear of this site. My own encounter with it was purely frustration as well as concerns regarding scamming practices. Exercise extreme caution, or even better, look for a more reputable platform to fulfill your requirements.

    Reply

  23. I urge you to avoid this site. The experience I had with it has been only frustration and doubts about fraudulent activities. Exercise extreme caution, or better yet, look for a trustworthy service for your needs.

    Reply

  24. I strongly recommend to avoid this site. The experience I had with it has been purely disappointment and doubts about scamming practices. Exercise extreme caution, or better yet, seek out a trustworthy service to meet your needs.

    Reply

Leave a Reply

Your email address will not be published. Required fields are marked *