Name$\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_$

Market Research and Analysis Data Preparation and Editing Worksheet

$$

Edit the following samples by stating if the response can be processed, needs to be edited, or needs to be thrown out:

$1.$ Open Editing Examples:$$

Question: How many years have you been a member of The Gallery Club at Spectrum?

Response: One year, Ten months.

$$

Process as is $\_\_\_\_\_\_\_\_\_\_$ Edit Response $1$ year $10$ months$$ Throw Out$\_\_\_\_\_\_\_\_\_\_\_\_$

Response if edited$\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_$

$$

$2.$ Question: How many weeks per year have you attended workouts at Golds Gym?

Response: Twelve days

$$

Process as is $\_\_\_\_\_\_\_\_\_\_$ Edit Response $\_\_\_\_\_\_\_\_\_\_\_\_\_\_$ Throw Out$\_\_\_\_\_\_\_\_\_\_\_\_$

Response if edited$\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_$

$$

$3.$ Question: How many people have redeemed a coupon at the Brighton Car was this week?

Response: $711$

$$

Process as is $\_\_\_\_\_\_\_\_\_\_$ Edit Response $\_\_\_\_\_\_\_\_\_\_\_\_\_\_$ Throw Out$\_\_\_\_\_\_\_\_\_\_\_\_$

Response if edited$\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_$

Explain how you would code the following questions for data processing:

$4.$ How did you learn about Greenfield Mall? $($Check all that apply$)$

$\_\_\_$ Digital advertising

$\_\_\_$ Newspaper advertising

$\_\_\_$ Recommended by someone

$\_\_\_$ other

$$

$$

$$

$$

$$

$$

$$

$$

$$

$5.$ How would you code a survey where a responded was asked $20$ questions about the service at a restaurant looking for a rating from one to five. When the response is examined, all $20$ responses are checked with a $1$ response.

Would you:

A$.$Process the survey with twenty registered #$1$ responses?

B$.$Reject the survey for coding as the question was not taken seriously.

$$ Answer A:$\_\_\_\_$ B:$\_\_\_\_\_$

$$

$6.$ A question asked the age of a particular respondent. The best way to code this would be to:

A$.$ Process the actual age of a particular respondent.

B$.$ Group respondents by category $($ages $0-20,$ ages $21-40,$ ages $41-60,$ ages $61-80,$ over $80)$

$$ Answer A:$\_\_\_\_\_$ B$.\_\_\_\_\_$

$$

$7.$ A question asks respondents how many times they have gotten their taxes done at Miller Tax Services. How would you process the answer for coding?

Question: How many times have you come to Miller Tax Services to get your taxes done?

Response: Six

Would you:

A$.$ Process the number $6$ as the response.

B$.$ Edit the number to a category $(1-5$ years, $6-10$ years, over $10$ ten years$)$

Answer A: $\_\_\_\_$ B:$\_\_\_\_$

$8.$ A survey asks the respondent to pick three of the five possible answers. They only pick one of the five answers. How would you choose to code the response?

$$

A$.$ Code each of the five possible answers with a number and count the responses returned regardless of the number of responses returned.

B$.$ Throw out the question because the instructions were not properly followed.

Answer A:$\_\_\_\_\_$ B:$\_\_\_\_\_$

$9.$ You issue a survey to $100$ people. You get $17$ responses. Should you:

A$.$ Code and register the data.

B$.$ Reject the survey entirely due to poor turnout.

Answer A:$\_\_\_\_\_$ B: $\_\_\_\_\_\_$

$$

$$

$$

$10.$ You issue a survey asking $10$ different questions. The responded answers the first six and leaves the rest of the survey blank.

Should you:

A$.$ Code the responses you have received.

B$.$ Reject the survey as it is incomplete.

Answer A:$\_\_\_\_\_$ B:$\_\_\_\_\_$