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.)
- 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.
- 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 - 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 - 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.