Supermarket Transactions

By

QUESTION

The dataset contains sales data from a supermarket chain. Your boss wants to know the general sales status. As part of the report, you need to generate the following statistics. (The questions are not systematic in terms of a report. They are to help you practice certain techniques.)
1. Generate descriptive statistics on “Children,” “Units sold,” and “Revenue” respectively.  Change the worksheet name to Q1. Based on the statistics, write a couple of lines to summarize the basic characteristics of “Units sold per transaction” in your company.
2. Draw a histogram on “Units sold.” Change the worksheet name to Q2. Write a couple of lines to further discuss the characteristics of Units sold per transaction.
Hint: You need to specify the bins for the histogram
3. Calculate the number of transactions for each gender and draw a pie chart on this gender-based statistics. Change the worksheet name to Q3.
Hint: Use COUNTIF
4. Make pivot tables based on gender and state and report the sum of revenues for each cell. Draw a column chart based on this pivot table. Change the worksheet name to Q4. Based on question 3 and 4 write a couple of lines to explain different gender’s transactions in your company’s all transaction.
Hint: The two dimensions of the pivot table are “gender” and “state. The statistics is “sum” on “revenue.”
5. Make pivot tables base on purchase date and state. Group purchase date to month level and report the maxim transaction revenue per month. Draw a line chart based on this pivot table (x axis is year-month).
Hint: The two dimensions of the pivot table are “date” and “state. Then, you need to group the purchase date dimension. Please note that you need to select both year and month to differentiate different years’ data.

Sample Solutions
Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Phasellus hendrerit. Pellentesque aliquet nibh nec urna. In nisi neque, aliquet vel, dapibus id, mattis vel, nisi. Sed pretium, ligula sollicitudin laoreet viverra, tortor libero sodales leo, eget blandit nunc tortor eu nibh. Nullam mollis. Ut justo. Suspendisse potenti.

Get sample solution
Order Now

Sed egestas, ante et vulputate volutpat, eros pede semper est, vitae luctus metus libero eu augue. Morbi purus libero, faucibus adipiscing, commodo quis, gravida id, est. Sed lectus. Praesent elementum hendrerit tortor. Sed semper lorem at felis. Vestibulum volutpat, lacus a ultrices sagittis, mi neque euismod dui, eu pulvinar nunc sapien ornare nisl. Phasellus pede arcu, dapibus eu, fermentum et, dapibus sed, urna.

Morbi interdum mollis sapien. Sed ac risus. Phasellus lacinia, magna a ullamcorper laoreet, lectus arcu pulvinar risus, vitae facilisis libero dolor a purus. Sed vel lacus. Mauris nibh felis, adipiscing varius, adipiscing in, lacinia vel, tellus. Suspendisse ac urna. Etiam pellentesque mauris ut lectus. Nunc tellus ante, mattis eget, gravida vitae, ultricies ac, leo. Integer leo pede, ornare a, lacinia eu, vulputate vel, nisl.
Suspendisse mauris. Fusce accumsan mollis eros. Pellentesque a diam sit amet mi ullamcorper vehicula. Integer adipiscing risus a sem. Nullam quis massa sit amet nibh viverra malesuada. Nunc sem lacus, accumsan quis, faucibus non, congue vel, arcu. Ut scelerisque hendrerit tellus. Integer sagittis. Vivamus a mauris eget arcu gravida tristique. Nunc iaculis mi in ante. Vivamus imperdiet nibh feugiat est.
Ut convallis, sem sit amet interdum consectetuer, odio augue aliquam leo, nec dapibus tortor nibh sed augue. Integer eu magna sit amet metus fermentum posuere. Morbi sit amet nulla sed dolor elementum imperdiet. Quisque fermentum. Cum sociis natoque penatibus et magnis xdis parturient montes, nascetur ridiculus mus. Pellentesque adipiscing eros ut libero. Ut condimentum mi vel tellus. Suspendisse laoreet. Fusce ut est sed dolor gravida convallis. Morbi vitae ante. Vivamus ultrices luctus nunc. Suspendisse et dolor. Etiam dignissim. Proin malesuada adipiscing lacus. Donec metus. Curabitur gravida

How to create Testimonial Carousel using Bootstrap5

Clients' Reviews about Our Services