Zolo is a national retail clothing store with locations across the United States. As an accounting analyst at Zolo, you have been given a 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 visualization technique that best fits. Use the sample of the first 30 records in the Excel spreadsheet to identify the data field names you need. 1. 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? Zolo is a national retail clothing store with locations across the United States. As an accounting analyst at Zolo, you have been given a 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 visualization technique that best fits. Use the sample of the first 30 records in the Excel spreadsheet to identify the data field names you need. 1. 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