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 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 150 employees at the (fictional) Adventures Company.

a.Create a table of correlations between the variables Age, Prior Experience, Education, and Annual Salary. Which of the first three of these variables is most highly correlated (in a positive direction) with the Annual Salary

b.Create scatterplots of Annual Salary (Y axis) versus Age and Education.

email me if you need referenced files