Guidelines for Reporting Poll Results

October 8th, 2007 by Jared Bothwell

I found some interesting guidelines published on Hang Right which come from the Associated Press online style guide.

In light of the upcoming election in New Zealand I thought it would be worthwhile passing these along. It is well known that polls can influence voters so it is important that the media reports on these accurately to ensure the polls retain their integirty in the election process. Read the rest of this entry »

Posted in Marketing Research | Comments Off

Querying External Data in Excel

October 2nd, 2007 by Jared Bothwell

Hats off to Dick’s Clicks for detailing how to successfully add a parameter using Microsoft Query. By using MS Excel is it possible to create a database connection to another excel sheet and feed data through. The great thing about Dick’s Clicks solution is that you can use a variable in the spreadsheet to determine which data is imported (rather than have all the data piped through).

The tricky part about querying the data is that adding a parameter is not possible unless you add a criteria from MS Query. Otherwise if you try to do it from excel you are faced with a greyed out parameter button. Dicks solution has saved me again.

Posted in Survey Technology | Comments Off