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. Hello would you mind letting me know which webhost you’re working with? I’ve loaded your blog in 3 different web browsers and I must say this blog loads a lot faster then most. Can you suggest a good web hosting provider at a fair price? Many thanks, I appreciate it!

  2. I haven¦t checked in here for some time since I thought it was getting boring, but the last few posts are good quality so I guess I will add you back to my daily bloglist. You deserve it my friend 🙂

  3. Hi there! Someone in my Myspace group shared this site with us so I came to look it over. I’m definitely enjoying the information. I’m book-marking and will be tweeting this to my followers! Terrific blog and brilliant style and design.

  4. 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!

  5. Terrific article! This is the type of information that are supposed to be shared around the web. Disgrace on the seek engines for not positioning this post upper! Come on over and seek advice from my site . Thank you =)

  6. First off I want to say fantastic blog! I had a quick question that I’d like to ask if you don’t mind. I was curious to know how you center yourself and clear your thoughts before writing. I have had trouble clearing my mind in getting my thoughts out. I do enjoy writing but it just seems like the first 10 to 15 minutes are usually wasted just trying to figure out how to begin. Any suggestions or tips? Appreciate it!

  7. Hmm is anyone else experiencing problems with the images on this blog loading? I’m trying to find out if its a problem on my end or if it’s the blog. Any feedback would be greatly appreciated.

  8. Bonusy te mog? mie? form? darmowych spinów, zwrotu gotówki i ofert bez depozytu. Niektóre z tych bonusów s? nawet dost?pne dla obecnych graczy. Te bonusy to ?wietny sposób na zwi?kszenie swojego bankrolla i zwi?kszenie szans na du?? wygran?. Darmowe spiny bez depozytu za rejestracj? s? zawsze obj?te obrotem, czyli inaczej wagering requirements. Pocz?tkuj?cy gracze mog? mie? problem ze zrozumieniem tego poj?cia. Bardzo ?atwo mo?na go jednak wyt?umaczy?. Wyobra? sobie, ?e z darmowych spinów wygrasz 100 z?. Nie mo?esz wyp?aci? tych pieni?dzy, dopóki nie wykorzystasz w kasynie pewnego powielenia tej kwoty ze swoich w?asnych depozytów. Kasyno darmowe spiny bez depozytu samo ustala jego zasady. Kasyna posiadaj?ce licencj? s? zobowi?zane do przestrzegania rygorystycznych standardów bezpiecze?stwa i ochrony danych osobowych graczy, kryptowaluty. Wp?ata kart? kredytow? jest szybka i ?atwa, któr? warto wykorzysta?. Kasyna s? zaprojektowane tak, które przyci?gaj? graczy i sprawiaj?.
    http://esserp.com/bbs/board.php?bo_table=free&wr_id=62969
    Na pocz?tku mo?e wyda? si? to dziwn? propozycj?, poniewa? wi?kszo?? producentów gwarantuje graczom mo?liwo?? korzystania z wersji demo gier, które s? darmowe. Okazuje si? jednak, ?e nie wszyscy producenci oferuj? wersj? demo i to w?a?nie ich dotyczy ten darmowy bonus bezdepozytu. Oznacza to, ?e gracze dostan? jedno z dwóch: albo wirtualne ?rodki do dyspozycji w tych grach albo b?d? mieli okre?lon? liczb? darmowych spinów. Wymienili?my trzech dostawców, którzy s? bardzo popularni w ?wiecie kasynowym, cho? na naszej stronie znajdziesz wiele ró?nych innych s?ynnych produkcji. Dostawcy udost?pniaj? nam tak?e wersje demonstracyjne, tak?e gra w maszyny hot spot za darmo czeka na tych, którzy s? ciekawi oferty i chc? j? przetestowa?. Nawet je?li znasz ju? niektóre opcje, to gra si? na tym nie ko?czy. Producenci nie poprzestaj? na gotowych slotach i prze?cigaj? si? we wcielaniu nowych pomys?ów, o czym sam zapewne wiesz, je?li ?ledzisz na bie??co ten typ rozrywki. Wszystkie nasze gry dzia?aj? tak?e w mobilnej wersji na telefon czy tablet.

  9. I have been surfing online more than three hours today, yet I never found any interesting article like yours. It’s pretty worth enough for me. In my opinion, if all website owners and bloggers made good content as you did, the internet will be much more useful than ever before.

  10. I simply could not leave your web site prior to suggesting that I extremely enjoyed the standard information a person supply on your visitors? Is going to be back incessantly in order to inspect new posts

  11. Hiya! Quick question that’s entirely off topic. Do you know how to make your site mobile friendly? My site looks weird when viewing from my iphone. I’m trying to find a theme or plugin that might be able to fix this problem. If you have any suggestions, please share. With thanks!

  12. Heya i’m for the primary time here. I came across this board and I in finding It truly useful & it helped me out a lot. I hope to give something back and help others like you helped me.

  13. Having read this I thought it was very informative. I appreciate you finding the time and effort to put this short article together. I once again find myself spending way too much time both reading and leaving comments. But so what, it was still worth it!

  14. Hi there! This article couldn’t be written any better! Going through this post reminds me of my previous roommate! He always kept talking about this. I am going to forward this article to him. Pretty sure he will have a very good read. Thank you for sharing!

  15. Whats up very nice web site!! Guy .. Beautiful .. Amazing .. I will bookmark your web site and take the feeds also? I am satisfied to seek out so many useful information here in the post, we’d like develop more strategies in this regard, thank you for sharing. . . . . .

  16. Hello! Someone in my Myspace group shared this site with us so I came to look it over. I’m definitely enjoying the information. I’m book-marking and will be tweeting this to my followers! Great blog and great design and style.

  17. Unquestionably consider that that you stated. Your favourite justification appeared to be at the internet the simplest thing to keep in mind of. I say to you, I definitely get irked whilst other people consider worries that they plainly do not understand about. You controlled to hit the nail upon the top as smartly as defined out the whole thing with no need side effect , folks can take a signal. Will likely be back to get more. Thank you

  18. With havin so much content and articles do you ever run into any problems of plagorism or copyright violation? My website has a lot of exclusive content I’ve either created myself or outsourced but it looks like a lot of it is popping it up all over the web without my authorization. Do you know any solutions to help protect against content from being ripped off? I’d definitely appreciate it.

  19. Have you ever considered about including a little bit more than just your articles? I mean, what you say is fundamental and all. Nevertheless just imagine if you added some great graphics or video clips to give your posts more, “pop”! Your content is excellent but with images and video clips, this site could certainly be one of the greatest in its niche. Terrific blog!

  20. Wonderful goods from you, man. I’ve remember your stuff prior to and you’re simply too wonderful. I really like what you’ve received here, really like what you’re stating and the best way in which you are saying it. You are making it entertaining and you still take care of to stay it sensible. I cant wait to read far more from you. This is actually a terrific site.

Leave a Reply

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