Zolo is a national retail clothing store with locations across the United States. As an accounting analyst at Zolo, you have been given an Excel spreadsheet with more than 70,000 records. The corporate controller wants you to analyze this data to answer a few questions regarding sales activities. For each of the following scenarios, identify the spreadsheet data field names that you need to answer the scenarios question and the visualization technique that best fits. Use the sample of the

. In which state were the most items sold in the past year?

2. Which day did Zolo make the most money from orders?

3. At what time of day should Zolo increase the number of in-store associates due to increased transactions?

4. How much money, on average, does a rewards member spend compared to a non-rewards member?

5. What are the highest, lowest, and median order amounts in this data set?

Sample spreadsheet data: