# Question

Recall from Chapter 2 that the HyTex Company is a direct marketer of technical products and that the file Catalog Marketing.xlsx contains recent data on 1000 HyTex customers. To understand these customers, first recode Salary and Amount Spent as indicated in part a, and then create each of the requested crosstabs and an associated column chart in parts b to e. Express each count as a percentage, so that for any value of the first variable listed, the percentages add to 100%. Do any patterns stand out?

a. Find the first, second, and third quartiles of Salary, and then recode Salary as 1 to 4, depending on which quarter of the data each value falls into. For example, the first salary, $16,400, is recoded as 1 because $16,400 is less than the first quartile, $29,975. Recode Amount Spent similarly, based on its quartiles.

b. Age versus the recoded Amount Spent

c. Own Home versus the recoded Amount Spent

d. History versus the recoded Amount Spent

e. The recoded Salary versus the recoded Amount Spent

a. Find the first, second, and third quartiles of Salary, and then recode Salary as 1 to 4, depending on which quarter of the data each value falls into. For example, the first salary, $16,400, is recoded as 1 because $16,400 is less than the first quartile, $29,975. Recode Amount Spent similarly, based on its quartiles.

b. Age versus the recoded Amount Spent

c. Own Home versus the recoded Amount Spent

d. History versus the recoded Amount Spent

e. The recoded Salary versus the recoded Amount Spent

## Answer to relevant Questions

In the smoking/drinking example in this section, we used the function COUNTIFS function (new to Excel 2007) to find the counts of the joint categories. Without using this function (or pivot tables), devise another way to get ...The file S02_32.xlsx contains blood pressures for 1000 people, along with variables that can be related to blood pressure. These other variables have a number of missing values, probably because some people didn’t want to ...The file S02_16.xlsx contains traffic data from 256 weekdays on four variables. Each variable lists the number of arrivals during a specific 5-minute period of the day.a. What would it mean, in the context of traffic, for ...Solve problem 3 with pivot tables and create corresponding pivot charts. Express the counts as percentage of row. What do these percentages indicate about this particular data set? Then repeat, expressing the counts as ...The file S02_18.xlsx contains daily values of the S&P Index from 1970 to 2009. It also contains percentage changes in the index from each day to the next. Create a pivot table with average of % Change in the Values area and ...Post your question

0