Docstoc

How to analyse survey data

Document Sample
How to analyse survey data Powered By Docstoc
					                        How to analyse survey data
Useful info:
Dirty Data = data that has been put into the online survey incorrectly.
Input (Clean Data) Sheet = the page where you keep your definitive data set.
Process Sheets = pages that you paste a copy of some data onto and then sort
and count to analyse.
Output Sheets = pages that display your results, normally a graph.

Useful formulae
=max(A1:A5) to find the highest number in a range of data
=min(A1:A5) to find the minimum number in a range of data
=average(A1:A5) to find the average number in a range of data
=countif(A1:A5,B1) to count a range of cells containing the same data as in B1.
=100*A1/SUM(A1:A5)to work out A1 as a percentage of the total of A1:A5

Dirty Data
    Rename the first sheet Dirty Data.
    Use right click / insert comment to label the title of each column.
    Use Data / Filter / Auto Filter to find rows containing dirty data.
    Highlight and colour in any rows containing dirty data.
    Copy the data and paste it onto Sheet 2.

Input Sheet
   Rename the Sheet 2 Input
   Carefully delete all the coloured rows containing dirty data.
   Do not sort or make any further changes to the data on this sheet.

Process 1 Sheet (core data)
   Rename the third sheet Process 1
   Select some core data to analyse what sample of people completed the
     survey
   Sort the data
   Create tables to count the results
   Create some appropriate graphs as separate sheets called Output 1 etc.

Process 2 Sheet (your theme data)
   Select some core data and some data specific to your theme.
   Sort the data
   Create tables to count the results
   Create some appropriate graphs as separate sheets called Output xxx etc.

Process 3 Sheet (your theme data)
   Select some core data and some different data specific to your theme.
   Sort the data
   Create tables to count the results
   Create some appropriate graphs as separate sheets called Output xxx etc.

Process 4 sheet (2 themes data)
   Select some data from your theme and another relevant group’s theme
   Sort the data
   Create tables to count the results
   Create some appropriate graphs as separate sheets called Output xxx etc.

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:6
posted:2/13/2010
language:English
pages:1