1.The file Supermarket Transactions.xlsx contains over 500 transactions made by supermarket customers over a period of approximately two years. (The data are not real, but real supermarket chains have huge data sets just like this one.) . Column B contains the date of the purchase, column C is a unique identifier for each customer, columns D-H contain information about the customer, columns I-K contain the location of the store, columns L-N contain information about the product purchased, and the last two columns indicate the number of items purchased and the amount paid.

-Identify the variables type and level of measurement

-Summarize the data using tables, diagrams and charts

-Compute appropriate numerical descriptivemeasures

-Set up a single pivot table and corresponding pivot chart, with some instructions to a user ( like the supermarket manager) in a text box, on how the user can get answers to any typical question about the data. For example, one possibility (of many) could be total revenue by product department and month, for any combination of gender, marital status, and homeowner.

Write a brief summary report on the findings.

DATA ENCLOSED IN THE LINK MENTIONED BELOW.

https://docs.google.com/spreadsheets/d/1sWTEwdW2HjAFaEAHuhWyul8a0fJiaf1u/edit#gid=1498564568