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 played on this gambling site and secured a considerable sum of cash. However, afterward, my mother fell critically ill, and I needed to withdraw some earnings from my casino balance. Unfortunately, I experienced difficulties and couldn’t withdraw the funds. Tragically, my mother passed away due to this online casino. I earnestly plead for your support in addressing this issue with the online casino. Please assist me in seeking justice, to ensure others do not experience the hardship I’m facing today, and avert them from undergoing similar heartache. ??

    Reply

  2. I played on this gambling site and won a substantial pile of earnings. However, eventually, my mom fell critically ill, and I needed to take out some money from my wallet. Unfortunately, I encountered problems and could not complete the withdrawal. Tragically, my mother passed away due to the gambling platform. I urgently request your help in reporting this issue with the platform. Please assist me in seeking justice, to ensure others do not experience the pain I’m facing today, and prevent them from experiencing similar heartache. ??

    Reply

  10. I participated on this gambling site and won a considerable amount of money. However, eventually, my mom fell gravely sick, and I required to withdraw some funds from my wallet. Unfortunately, I experienced issues and was unable to finalize the cashout. Tragically, my mom passed away due to this casino site. I earnestly ask for your help in addressing this issue with the site. Please assist me to find justice, to ensure others won’t have to endure the hardship I’m facing today, and prevent them from experiencing similar heartache. ??

    Reply

  11. I played on this online casino platform and earned a considerable sum of earnings. However, eventually, my mom fell seriously ill, and I required to take out some money from my account. Unfortunately, I encountered difficulties and could not withdraw the funds. Tragically, my mom died due to this gambling platform. I kindly request your assistance in reporting this situation with the site. Please aid me in seeking justice, to ensure others won’t have to endure the anguish I’m facing today, and avert them from facing similar heartache. ??

    Reply

  25. Wow, you’ve done an outstanding job this time! Your hard work and creativity are truly inspiring of this piece. I couldn’t help but express my appreciation for sharing such amazing content with us. Your talent and dedication are truly admirable. Keep up the fantastic work! ???

    Reply

  26. Absolutely fantastic, you’ve truly surpassed expectations this time! Your effort and creativity are truly commendable of this content. I just had to take a moment to express my gratitude for bringing such awesome content with us. You have an incredible talent and dedication. Keep up the fantastic work! ???

    Reply

  29. Wow, you’ve truly surpassed expectations this time! Your hard work and creativity are truly inspiring of this work. I couldn’t help but express my appreciation for producing such outstanding content with us. You are exceptionally talented and dedicated. Keep up the excellent work! ???

    Reply

  41. ? Wow, this blog is like a cosmic journey blasting off into the universe of excitement! ? The thrilling content here is a rollercoaster ride for the imagination, sparking awe at every turn. ? Whether it’s lifestyle, this blog is a goldmine of exhilarating insights! #MindBlown Dive into this exciting adventure of imagination and let your mind fly! ? Don’t just enjoy, experience the thrill! #FuelForThought Your mind will thank you for this exciting journey through the dimensions of awe! ?

    Reply

  43. ? Wow, this blog is like a fantastic adventure blasting off into the universe of wonder! ? The mind-blowing content here is a rollercoaster ride for the mind, sparking excitement at every turn. ? Whether it’s inspiration, this blog is a goldmine of exhilarating insights! #InfinitePossibilities Embark into this exciting adventure of knowledge and let your mind fly! ? Don’t just explore, immerse yourself in the thrill! #FuelForThought ? will thank you for this exciting journey through the worlds of awe! ?

    Reply

Leave a Reply

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