The importance of editing the collected raw data to detect errors and omissions. 

• The importance of editing the collected raw data to detect errors and omissions.

• How coding is used to assign numbers and other symbols to answers and to categorize responses.
• Problems with and solutions for “don’t know” responses and missing data.
• The options for data entry and manipulation.
• Exploratory Data Analysis
• Frequency Table, Bar Chart and Pie Chart, Histogram, Pareto Diagram, Mapping
• Cross-Tabulation
• The Use of Percentage, Other table based analysis.

Case Study: The marketing of arts festivals

Jemma was interested in utilizing secondary data from her placement organization as part of her undergraduate research project on the marketing of arts festivals. In particular she was interested in:

• The extent to which audiences associated events with their sponsors;
• The socio-economic status of those attending;
• The importance of different media for finding out about events.

Her placement organization had undertaken a questionnaire survey with attendees at the local Arts festival and agreed that Jemma could use the data for her research project. The data had already been entered into a spreadsheet. A copy of a completed questionnaire is included below:

Assignment Questions:

1. On looking at the questionnaire, Jemma noticed some problems with the way in which some questions had been coded.

• What were these problems?
• How might these have been overcome at the survey design stage?

• Which of the questions were likely to be most useful to Jemma for her research project?
• How could Jemma have minimized the impact on her analysis of any coding problems with these questions?
• Which diagrams would you recommend Jemma to use to analyze questions 3 and 5?

(You should state precisely what the recommended diagrams will enable Jemma to find out.)

3. After collecting the data, Jemma tried to analyze the correlation between the age of the festival attendees and the easiness to book/buy tickets. The results are presented in the graph below. Interpret and discuss the result found by Jemma.