Here is a link to the full deck that we reviewed and you can watch the ~1 hour webinar below. If you’d like to sign up for our AHK “Hangouts”, please click here.
This video has lots of insights and advanced analysis. 🙂 The very end we performed the random drawing and found out that Ben from Coraopolis, PA, won the $100 Amazon gift card! You can register for upcoming webinars here.
Care to get some tips on how to look at your survey data? I’ve been an analyst for nearly 20 years now and was featured in a joint webinar with SurveyGizmo (my favorite survey tool) .
The webinar will be covered the basics of reporting of data, types of variables (Nominal/Categorical, Ordinal, Interval and Scale/Ratio) and best practices of how to report on them. I also reviewed how, by creating binary variables, you can simplify a lot of your reporting. The webinar is sightly over an hour long. I showed a few tips for using Excel pivot tables and demonstrated how to replicate graphs quickly & easily.
Making Sense of Survey Data: Laying the Foundation for Data Analysis
I’m hoping to have another one getting a bit more specific on using SPSS and cranking-out Excel / PowerPoint slides. 🙂
While it is easy to use Excel to transpose rows into columns, I’ve created an AutoHotkey script which negates the need to. Basically it examines what is on the clipboard and replaces tabs with line breaks, then it sends paste to the program thus it is transposing clipboard content. I have it triggered of hitting a hotkey and comes in pretty handy and can save some time if it is something you do frequently.
Below is a video which demonstrates it usage.
^+t:: ;Control, Shift and T trigger script
StringReplace, clipboard, clipboard,%A_Tab%, `r , All ;replace all tabs with line return
SendPlay,^v ;send "paste"
I had over 100 URLs I wanted to submit to StumbleUpon.com and wanted to tag them with around 12 interests. This would have taken me quite some to do manually so I wrote an AutoHotKey script to web scrape and cranked it out in no time!
Below is the video demonstrating the AutomatingStumbleUpon submissions.
And here is the first draft of my script (I only included 3 urls in this example)