Retail Sales Data Analysis
10 Questions
0 Views

Choose a study mode

Play Quiz
Study Flashcards
Spaced Repetition
Chat to lesson

Podcast

Play an AI-generated podcast conversation about this lesson

Questions and Answers

What is the total gross income for the customer with Invoice ID 373-73-7910?

The total gross income for the customer with Invoice ID 373-73-7910 is $30.2085.

What is the unit price of the product line 'Food and beverages' for the customer with Invoice ID 692-92-5582?

The unit price of the product line 'Food and beverages' for the customer with Invoice ID 692-92-5582 is $54.84.

On which date and at what time did the customer with Invoice ID 631-41-3108 make the purchase?

The customer with Invoice ID 631-41-3108 made the purchase on 3/3/2019 at 13:23.

What is the total amount paid by the customer with Invoice ID 355-53-5943?

<p>The total amount paid by the customer with Invoice ID 355-53-5943 is $433.692.</p> Signup and view all the answers

What is the gender of the customer with Invoice ID 665-32-9167?

<p>The gender of the customer with Invoice ID 665-32-9167 is Female.</p> Signup and view all the answers

What is the total amount paid by all customers in the branch 'Yangon'?

<p>total amount = $548.9715 + 340.5255 + 489.048 + 634.3785 + 433.692 + 76.146 = $2522.7615</p> Signup and view all the answers

What is the average gross margin percentage for customers who paid using 'Ewallet'?

<p>average gross margin percentage = $4.761904762 + 4.761904762 + 4.761904762 + 4.761904762 = $4.761904762</p> Signup and view all the answers

What is the total quantity of products purchased by male customers in the branch 'Yangon'?

<p>total quantity = 7 + 7 + 8 = 22</p> Signup and view all the answers

What is the total COGS (Cost of Goods Sold) for all customers who made a purchase on 1/27/2019?

<p>total COGS = $465.76</p> Signup and view all the answers

What is the average unit price of 'Electronic accessories' for customers who made a purchase using 'Credit card'?

<p>average unit price = $85.39</p> Signup and view all the answers

More Like This

Business Analytics for Retailers
10 questions
Market Basket Analysis
10 questions

Market Basket Analysis

SignificantAntagonist avatar
SignificantAntagonist
VBM Retailing Vocabulary Flashcards
97 questions

VBM Retailing Vocabulary Flashcards

ManeuverableForgetMeNot2590 avatar
ManeuverableForgetMeNot2590
Use Quizgecko on...
Browser
Browser