Chapter 4, Data Preparation and Descriptive Statistics Video Solutions, Statistics for Marketing and Consumer Research

Problem 1

Open the Trust SPSS data-set and perform the following operations:
a. The variable q64 (country) is a nominal variable with five response categories, each corresponding to a country. Transform it into five dummy variables, one for each country, by using the COMPUTE command (you may find it easier by exploiting SPSS syntax
b. Create a MULTIPLE RESPONSE SET (see SPSS Help and the DATA menu) for the dummy variables recording the point of purchase (q8a to q8d) and name it as POP
c. Using the CUSTOM TABLE command under the ANALYZE/TABLE menu, create a frequency table to show the proportion of points of purchase across countries (POP by q64)
d. Create a pie chart showing the proportion of points of purchase for the whole data-set.

$$
\begin{array}{llcr}
\hline \text { Case ID } & \text { Math ability } & \begin{array}{l}
\text { Attitude to } \\
\text { driving (1 to 9) }
\end{array} & \text { Car value (\$) } \\
\hline \text { John } & \text { Poor } & 3 & 12,000 \\
\text { Amanda } & \text { Medium } & 7 & 13,225 \\
\text { Ben } & \text { Poor } & 5 & 8,000 \\
\text { Frank } & \text { Excellent } & 8 & 25,000 \\
\text { Johanna } & \text { Excellent } & 6 & 16,450 \\
\text { Steve } & \text { Medium } & 2 & 5,000 \\
\text { Matilda } & \text { Poor } & 9 & 29,000 \\
\text { Patrick } & \text { Excellent } & 6 & 14,000 \\
\text { Claire } & \text { Excellent } & 8 & 19,000 \\
\text { Andrea } & \text { Poor } & 4 & 7,000 \\
\hline
\end{array}
$$

Check back soon!

04:12

Problem 2

Create a new data-set in SPSS and name it Chap4.sav
a. Insert the four variables (including CASE ID) and ten observations, shown in the table assigning properly TYPE, LABEL, VALUES, MISSING VALUES. WIDTH, DECIMALS and MEASURE
b. Create a binned variable with three categories for car value
c. Create a frequency table for the binned variable
d. Create a table showing the average attitude to driving for each category of the car value, using two decimals
e. Create a histogram showing the attitude to driving and car value for each level of math ability.

James Kiss

Numerade Educator

Problem 3

Open the EFS data-set in SPSS:
a. Consider variable a094 (NS-SEC 8 Class of Household Reference Person)
b. Create a frequency table also showing the percentage of missing values by type
c. Create a Pareto chart showing the distribution of different types of missing values
d. Create a table with the mean of p600 (EFS-Total Consumption Expenditure) for the various categories of missing values plus a single category of nonmissing values. Do you presume that the missing values may be biasing the sample?
e. Perform the outliers checks described in chapter 4
f. Compute the average of p600 for the whole sample
g. Weight the observation using weight a (Annual Weight). Compute the sample mean of p600 again. Does it change?

Check back soon!