1.Recall from chapter 2 that the file of Supermarket Transactions.xlsx contains over 14,000 transactions made by supermarket customers over a period of approximately two years. To understand which customers purchase which products, use pivot tables to create a crosstabs and an associated column part for each of the following. For each, express the counts as percentages so that for any value of the first variable listed, the percentages add to 100%. Do any patterns Recall stand out?

a.State or Province versus Product Department

b.Marital Status versus Product Category

c.Annual Income versus Product Category

2.The file of HW_02.xlsx includes data on 138 houses that were recently sold in a (fictional) suburban community. The data set includes the selling price of each house, along with its appraised value, square footage, number of bedrooms, and number of bathrooms.

a.Create a table of correlations between all of the variables. Comment on the magnitudes of the correlations. Specifically, which of the last three variables, Square Feet, Bedrooms, and Bathrooms, are highly correlated with each Selling Price?

b.Create a scatterplot between Appraised Value and Selling Price.

c.So, here Selling Price minus Appraised Value is the "error" in the appraised value, in the sense that this difference is how much more or less the house sold for than the appraiser expected. Find the correlation between the difference and Selling Price. Is the correlation reasonably larger? What does it mean?