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

1,076 thoughts on “OPINIONS AS DATA

  1. I highly advise stay away from this platform. My own encounter with it has been purely frustration and suspicion of deceptive behavior. Exercise extreme caution, or even better, look for an honest platform to fulfill your requirements.

  2. I highly advise steer clear of this site. The experience I had with it has been nothing but dismay as well as concerns regarding scamming practices. Proceed with extreme caution, or alternatively, look for an honest platform to meet your needs.

  3. I urge you to avoid this site. The experience I had with it has been nothing but disappointment and suspicion of fraudulent activities. Proceed with extreme caution, or better yet, look for a trustworthy site to meet your needs.

  4. I urge you stay away from this platform. My own encounter with it has been only disappointment along with suspicion of scamming practices. Exercise extreme caution, or alternatively, find a trustworthy service for your needs.

  5. I highly advise stay away from this platform. My own encounter with it has been purely disappointment as well as suspicion of deceptive behavior. Exercise extreme caution, or alternatively, seek out a trustworthy service for your needs.

  6. I strongly recommend stay away from this platform. The experience I had with it has been only disappointment along with doubts about deceptive behavior. Exercise extreme caution, or alternatively, look for a trustworthy platform to fulfill your requirements.

  7. I strongly recommend to avoid this site. My personal experience with it was nothing but dismay as well as concerns regarding deceptive behavior. Exercise extreme caution, or even better, look for a trustworthy service to fulfill your requirements.

  8. I strongly recommend to avoid this platform. My personal experience with it was nothing but dismay as well as concerns regarding deceptive behavior. Exercise extreme caution, or better yet, find a trustworthy site for your needs.

  9. I strongly recommend stay away from this platform. The experience I had with it has been nothing but frustration and suspicion of fraudulent activities. Proceed with extreme caution, or alternatively, find an honest service to meet your needs.

  10. I strongly recommend stay away from this site. My own encounter with it was only dismay and doubts about fraudulent activities. Be extremely cautious, or better yet, look for a more reputable site to fulfill your requirements.

  11. I strongly recommend stay away from this platform. My personal experience with it has been only frustration as well as suspicion of fraudulent activities. Proceed with extreme caution, or alternatively, find a trustworthy platform to meet your needs.

  12. I highly advise to avoid this platform. The experience I had with it was purely frustration as well as concerns regarding scamming practices. Proceed with extreme caution, or even better, look for a trustworthy service to meet your needs.

  13. I urge you steer clear of this site. My own encounter with it was purely disappointment and doubts about scamming practices. Exercise extreme caution, or alternatively, find an honest service to fulfill your requirements.

  14. I strongly recommend stay away from this site. The experience I had with it was only dismay and doubts about scamming practices. Be extremely cautious, or even better, look for a trustworthy platform for your needs.

  15. I highly advise to avoid this site. My personal experience with it was nothing but dismay as well as suspicion of fraudulent activities. Proceed with extreme caution, or alternatively, find a more reputable site to fulfill your requirements.

  16. I highly advise steer clear of this site. My personal experience with it was only disappointment as well as doubts about deceptive behavior. Proceed with extreme caution, or alternatively, look for a more reputable platform to fulfill your requirements.

  17. I highly advise to avoid this platform. My personal experience with it has been nothing but frustration along with suspicion of deceptive behavior. Be extremely cautious, or better yet, look for a trustworthy platform to fulfill your requirements.

  18. I urge you to avoid this site. The experience I had with it was purely frustration and concerns regarding scamming practices. Exercise extreme caution, or even better, seek out a trustworthy platform to fulfill your requirements.

  19. I strongly recommend stay away from this site. The experience I had with it was only disappointment and suspicion of deceptive behavior. Be extremely cautious, or even better, look for a trustworthy platform to fulfill your requirements.

  20. I highly advise stay away from this site. The experience I had with it has been purely frustration and concerns regarding fraudulent activities. Be extremely cautious, or better yet, look for a trustworthy service for your needs.

  21. I urge you to avoid this platform. My own encounter with it has been nothing but frustration as well as concerns regarding scamming practices. Proceed with extreme caution, or better yet, find an honest service for your needs.

  22. I urge you steer clear of this site. The experience I had with it has been purely dismay and suspicion of scamming practices. Exercise extreme caution, or alternatively, seek out a more reputable service to meet your needs.

  23. I urge you steer clear of this site. My personal experience with it was purely disappointment as well as doubts about scamming practices. Exercise extreme caution, or even better, find an honest service for your needs.

  24. I strongly recommend to avoid this site. The experience I had with it has been nothing but frustration as well as suspicion of fraudulent activities. Proceed with extreme caution, or even better, look for a trustworthy site to meet your needs.s

  25. I highly advise to avoid this site. My personal experience with it was nothing but frustration along with concerns regarding deceptive behavior. Be extremely cautious, or alternatively, seek out an honest site to meet your needs.s

  26. I strongly recommend to avoid this platform. My own encounter with it has been purely disappointment as well as suspicion of deceptive behavior. Be extremely cautious, or even better, look for a more reputable platform to fulfill your requirements.

  27. I urge you to avoid this site. My own encounter with it has been purely dismay along with concerns regarding deceptive behavior. Proceed with extreme caution, or even better, seek out a trustworthy service for your needs.

  28. I urge you stay away from this site. The experience I had with it has been only frustration and doubts about deceptive behavior. Be extremely cautious, or even better, seek out a more reputable service to fulfill your requirements.

  29. I strongly recommend to avoid this platform. My personal experience with it was only disappointment along with suspicion of deceptive behavior. Exercise extreme caution, or better yet, find a trustworthy platform to fulfill your requirements.

  30. I strongly recommend to avoid this platform. My personal experience with it was purely disappointment and doubts about scamming practices. Be extremely cautious, or alternatively, find a more reputable service to meet your needs.

  31. I highly advise to avoid this platform. My own encounter with it has been nothing but dismay and suspicion of deceptive behavior. Exercise extreme caution, or better yet, look for an honest platform to meet your needs.

  32. I strongly recommend steer clear of this site. My personal experience with it has been nothing but disappointment along with concerns regarding scamming practices. Exercise extreme caution, or alternatively, seek out a trustworthy site for your needs.

  33. I highly advise stay away from this site. The experience I had with it was only disappointment as well as suspicion of scamming practices. Be extremely cautious, or alternatively, look for a trustworthy service for your needs.

  34. I highly advise steer clear of this site. My own encounter with it has been purely disappointment as well as doubts about deceptive behavior. Be extremely cautious, or better yet, find a trustworthy service to meet your needs.

  35. I strongly recommend steer clear of this platform. My personal experience with it has been purely frustration as well as doubts about fraudulent activities. Proceed with extreme caution, or better yet, look for a trustworthy site to fulfill your requirements.

  36. I highly advise stay away from this site. My personal experience with it has been only frustration as well as suspicion of scamming practices. Proceed with extreme caution, or even better, seek out an honest site for your needs.

  37. I urge you to avoid this platform. My personal experience with it was nothing but dismay and concerns regarding deceptive behavior. Exercise extreme caution, or alternatively, seek out an honest site to meet your needs.

  38. I strongly recommend to avoid this platform. The experience I had with it has been only frustration and doubts about fraudulent activities. Exercise extreme caution, or alternatively, seek out a more reputable service to fulfill your requirements.

  39. I urge you steer clear of this site. My own encounter with it was nothing but disappointment along with suspicion of fraudulent activities. Be extremely cautious, or alternatively, look for a trustworthy platform to fulfill your requirements.

Leave a Reply

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