Zolo is a national retail clothing store with locations across the United States. As an accounting...

  

Transcribed Image Text:

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 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. transaction_ID TID_00012546 TID_00012547 TID_00012548 TID_00012549 TID_00012550 TID_00012551 TID_00012552 TID_00012553 TID_00012554 TID_00012555 TID_00012556 TID_00012557 TID_00012558 TID_00012559 TID_00012560 TID_00012561 TID_00012562 TID_00012563 TID_00012564 transaction_date 10/1/2021 10/1/2021 10/1/2021 10/1/2021 10/1/2021 10/1/2021 10/1/2021 10/1/2021 10/1/2021 10/1/2021 10/1/2021 10/1/2021 10/1/2021 10/1/2021 10/1/2021 10/1/2021 10/1/2021 10/1/2021 10/1/2021 transaction_hour 5:46 PM 2:25 PM 4:55 PM 4:31 PM 6:04 PM 12:53 PM 2:09 PM 7:13 PM 1:29 PM 5:55 PM 6:27 PM 8:29 PM 7:02 PM 8:52 PM 5:34 PM 4:16 PM 11:22 AM 6:07 PM 3:09 PM location state Georgia Florida Florida Florida Florida Alabama Florida Florida Mississippi Florida Georgia Florida Florida Florida Alabama Florida Georgia Georgia Alabama location_city Albany Pompano Beach Fort Lauderdale Tampa Jacksonville Montgomery Daytona Beach Miami Jackson Orlando Lawrenceville Naples North Port Miami Birmingham Orlando Savannah Atlanta Huntsville rewards_member TRUE TRUE TRUE TRUE TRUE FALSE TRUE FALSE FALSE TRUE FALSE FALSE TRUE FALSE FALSE TRUE FALSE FALSE FALSE num_of_ Scenario 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? Save for Later Visualization Technique Attempts: 0 of 1 used Submit Answer 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 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. transaction_ID TID_00012546 TID_00012547 TID_00012548 TID_00012549 TID_00012550 TID_00012551 TID_00012552 TID_00012553 TID_00012554 TID_00012555 TID_00012556 TID_00012557 TID_00012558 TID_00012559 TID_00012560 TID_00012561 TID_00012562 TID_00012563 TID_00012564 transaction_date 10/1/2021 10/1/2021 10/1/2021 10/1/2021 10/1/2021 10/1/2021 10/1/2021 10/1/2021 10/1/2021 10/1/2021 10/1/2021 10/1/2021 10/1/2021 10/1/2021 10/1/2021 10/1/2021 10/1/2021 10/1/2021 10/1/2021 transaction_hour 5:46 PM 2:25 PM 4:55 PM 4:31 PM 6:04 PM 12:53 PM 2:09 PM 7:13 PM 1:29 PM 5:55 PM 6:27 PM 8:29 PM 7:02 PM 8:52 PM 5:34 PM 4:16 PM 11:22 AM 6:07 PM 3:09 PM location state Georgia Florida Florida Florida Florida Alabama Florida Florida Mississippi Florida Georgia Florida Florida Florida Alabama Florida Georgia Georgia Alabama location_city Albany Pompano Beach Fort Lauderdale Tampa Jacksonville Montgomery Daytona Beach Miami Jackson Orlando Lawrenceville Naples North Port Miami Birmingham Orlando Savannah Atlanta Huntsville rewards_member TRUE TRUE TRUE TRUE TRUE FALSE TRUE FALSE FALSE TRUE FALSE FALSE TRUE FALSE FALSE TRUE FALSE FALSE FALSE num_of_ Scenario 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? Save for Later Visualization Technique Attempts: 0 of 1 used Submit Answer

Answer rating: 100% (QA)

1 In which state were the most items sold in the past year Visualization Technique Bar Chart 2 Which ... View the full answer