# How to analyse survey data

Document Sample

```					                        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