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”

  5. Hi there! I know this is kinda off topic however , I’d figured I’d ask. Would you be interested in exchanging links or maybe guest writing a blog article or vice-versa? My website discusses a lot of the same subjects as yours and I feel we could greatly benefit from each other. If you happen to be interested feel free to send me an e-mail. I look forward to hearing from you! Wonderful blog by the way!

    Reply

  6. With havin so much written content do you ever run into any problems of plagorism or copyright violation? My site has a lot of completely unique content I’ve either created myself or outsourced but it appears a lot of it is popping it up all over the web without my authorization. Do you know any solutions to help reduce content from being ripped off? I’d definitely appreciate it.

    Reply

  10. Greetings from Carolina! I’m bored to death at work so I decided to check out your website on my iphone during lunch break. I really like the knowledge you present here and can’t wait to take a look when I get home. I’m amazed at how quick your blog loaded on my cell phone .. I’m not even using WIFI, just 3G .. Anyhow, fantastic site!

    Reply

  11. This design is wicked! You obviously know how to keep a reader entertained. Between your wit and your videos, I was almost moved to start my own blog (well, almost…HaHa!) Fantastic job. I really enjoyed what you had to say, and more than that, how you presented it. Too cool!

    Reply

  13. I think what you postedtypedthink what you postedtypedsaidbelieve what you postedwrotethink what you postedwrotesaidWhat you postedwrotesaid was very logicala bunch of sense. But, what about this?think about this, what if you were to write a killer headlinetitle?content?typed a catchier title? I ain’t saying your content isn’t good.ain’t saying your content isn’t gooddon’t want to tell you how to run your blog, but what if you added a titleheadlinetitle that grabbed a person’s attention?maybe get a person’s attention?want more? I mean %BLOG_TITLE% is a little plain. You ought to peek at Yahoo’s home page and watch how they createwrite post headlines to get viewers to click. You might add a related video or a pic or two to get readers interested about what you’ve written. Just my opinion, it might bring your postsblog a little livelier.

    Reply

  18. I don’t even know how I ended up here, but I thought this post was good. I don’t know who you are but definitely you are going to a famous blogger if you are not already 😉 Cheers!

    Reply

  19. Hi there! I could have sworn I’ve been to this blog before but after going through some of the posts I realized it’s new to me. Anyhow, I’m definitely pleased I discovered it and I’ll be bookmarking it and checking back regularly!

    Reply

  22. When I originally commented I clicked the “Notify me when new comments are added” checkbox and now each time a comment is added I get three emails with the same comment. Is there any way you can remove me from that service? Thanks a lot!

    Reply

  25. This is the right blog for anyone who really wants to find out about this topic. You understand so much its almost hard to argue with you (not that I personally would want to?HaHa). You definitely put a new spin on a topic that has been written about for a long time. Excellent stuff, just great!

    Reply

  28. ? ???? ????????? ??????????? ???? ??? ????????, ?? ?? ?????????? ???????????? 30000 ??????. ? ????? ?????????? ? LinkedIn, ?? ??????? ????? ?? ????. ?? ???-?????-???.?? ? ?????? ??????? ??????????? ?????. ????????? ????? ??? ?????? ????????? ???????!

    Reply

  29. Incredible, blog yang fantastis! ? Saya sangat kagum dengan kontennya yang menarik dan menghibur. Setiap artikel memberikan informasi segar dan inspiratif. ? Saya sepenuh hati menikmati menelusuri setiap kata. Semangat terus! ? Sudah tidak sabar untuk membaca artikel selanjutnya. ? Terima kasih atas usaha kerasnya dalam memberikan informasi yang berguna dan menginspirasi. ?? Keep up the great work!

    Reply

Leave a Reply

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