You have 3 columns of sales data in excel that tell you (1) the date a...

 

Transcribed Image Text:

You have 3 columns of sales data in excel that tell you (1) the date a product was sold, (2) what product was sold, and (3) the revenue from that sale. We've provided a few rows of data in the picture, but imagine there were several thousand rows you would need to use. Can you explain below how you would tell us what product sold the most if you had a similar, but much larger data set with hundreds of products? And what month that product sold the most? You don't have to calculate anything for this question, just explain your approach in excel or another applicable method (python, SQL, any other approach). Feel free to use Google to find the most efficient way to solve this problem. 1 2 3 4 5 6 A B Date of Sale Product Sold 1/2/22 Product 1 3/5/22 Product 2 9/27/22 Product 4 3/22/22 Product 1 6/7/22 Product 4 C Revenue $100 $150 $125 $126.34 $178.45 1 2 3 4 5 6 7 8 9 10 11 12 13 Date of Sale B Product Sold 1/2/22 Product 1 3/5/22 Product 2 9/27/22 Product 4 3/22/22 Product 1 6/7/22 Product 4 7/8/22 Product 3 9/4/22 Product 1 5/7/22 Product 4 1/2/22 Product 3 3/5/22 Product 1 9/27/22 Product 4 3/22/22 Product 1 Your answer Revenue Please explain here how you would accomplish the 2 items above. $100 $150 $125 $126.34 $178.45 $178.56 $24 $67 $94.32 $78.23 $135.40 $97.80 You have 3 columns of sales data in excel that tell you (1) the date a product was sold, (2) what product was sold, and (3) the revenue from that sale. We've provided a few rows of data in the picture, but imagine there were several thousand rows you would need to use. Can you explain below how you would tell us what product sold the most if you had a similar, but much larger data set with hundreds of products? And what month that product sold the most? You don't have to calculate anything for this question, just explain your approach in excel or another applicable method (python, SQL, any other approach). Feel free to use Google to find the most efficient way to solve this problem. 1 2 3 4 5 6 A B Date of Sale Product Sold 1/2/22 Product 1 3/5/22 Product 2 9/27/22 Product 4 3/22/22 Product 1 6/7/22 Product 4 C Revenue $100 $150 $125 $126.34 $178.45 1 2 3 4 5 6 7 8 9 10 11 12 13 Date of Sale B Product Sold 1/2/22 Product 1 3/5/22 Product 2 9/27/22 Product 4 3/22/22 Product 1 6/7/22 Product 4 7/8/22 Product 3 9/4/22 Product 1 5/7/22 Product 4 1/2/22 Product 3 3/5/22 Product 1 9/27/22 Product 4 3/22/22 Product 1 Your answer Revenue Please explain here how you would accomplish the 2 items above. $100 $150 $125 $126.34 $178.45 $178.56 $24 $67 $94.32 $78.23 $135.40 $97.80

Answer rating: 100% (QA)

To find out what product sold the most and in which month it sold the most we can use Microsoft Exce... View the full answer