QA - Descriptive Statistics and variable relationships HW2

HW_02

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. Gender versus Product Department

b. Marital Status versus Product Department

c. Annual Income versus Product Department

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.

c. Use the pivot table to group the Annual Salary into several categories.