• Intro to AutoHotkey Intermediate AutoHotkey Intermediate Objects GUIs are Easy w/AutoHotkey Painlessly switch from V1 to V2

Mock focus groups- Models & Smartphones; which one is smarter?

Mock Focus Groups – Models

mock focus groups-models

These mock focus groups were done brilliantly however, if you’ve ever participated/conducted a focus group you’ll be able to relate to some of the comments.  Let’s just say, often you’ll pull in some of the sharp knives and some that make butter-knives look like razor blades.  I think the Toddlers were one step above them but would put them on-par with the Failed Rockers and Guidos but ahead of the Surfers.

The “moderator” should get an Oscar for his “blank stare” reaction to some of the comments.  I must admit I’ve been there!  Trust me when I say you’re going to LOL thru this video!

Here is a book for those interested in learning about Focus groups.  I recommend buying the used version

Mock focus groups- Guidos; The Italian Stallions demonstrate their genius

Mock focus groups- Guidos

I’d almost say that this mock focus groups is proof that Guidos (almost) have a brain…   I love how they keep trying to out-do each other.  The testosterone kept getting dialed up!  I think the Toddlers and Seniors made better use of the phones then they did!   I would loved to have seen the Guidos matched up with the Models and compete with the Failed Rockers and Surfers!


Here is a book for those interested in learning about Focus groups. I recommend buying the used version

Using First & Last variables for SPSS Syntax- Great way to reduce your code

SPSS syntax

In SPSS syntax you can streamline your code by putting the word “TO” between the first and last variable you want.  For instance, in the image below, Category, Lang, cname, Date, and Sent is highlighted. If I wanted to run frequencies perform something on all of these variables I could write the following code:

Frequency Category Lang cname Date Sent.

or I could simply do the following:

 Frequency Category TO Sent.

Both return the same results yet the second one is much simpler, cleaner and can save a lot of space (especially when there are dozens of variables).

I have a short AutoHotKey script which grabs the variables highlighted, copies them to the clipboard and takes the first item, then puts the word ” TO ” then grabs the list item.

This helps me write clean-looking syntax much faster than doing it manually.

Grabbing first and last variable with SPSS syntax



The following is the AutoHotKey code:

;************************Grab first and Last variables for SPSS syntax*******************************.
^!v:: ;Control Alt V is the hotkey that pastes what is on the clipboard
Loop, parse, Clipboard, `n, `r ; Specifying `n prior to `r allows both Windows and Unix files to be parsed.
If A_Index =1
FirstToLast:= " " . First . " TO " . Last . " "
SendPlay, %FirstToLast%


SPSS to Excel graph in seconds– Autographs to reduce workload

SPSS to excel graph

Typically I used to use SPSS to create tables then export them and graph them in Excel (because Excel makes darn pretty graphs!)

A few years back I wrote a script that would, automatically, take SPSS tables and create the graphs for me.  This brought down my reporting time to minutes instead of hours!  Using AutoHotKey I was able to take SPSS to Excel without embedding any macros.  This is possible because AutoHotKey can connect via a COM object.

SPSS to Excel graph in seconds