Let’s filter the data by customer. Make a copy of the data worksheet. Name the new worksheet tab Filter. Create a filter for customer number 3013. Copy the resulting data into row 235 (so you can create descriptive statistics). On the same worksheet, create descriptive statistics for customer 3013, placing the descriptive statistics in row 252. Answer the following questions about customer 3013.

a. How many items did customer 3013 buy?

b. Did customer 3013 buy more than one item in a sales transaction? 

c. What was the average gross margin percentage for customer 3013’s sales transactions?

d. Create a visualization showing the number of each product purchased by customer 3013 during October. Is the chart a histogram or a bar chart? Explain your answer.

e. Why would management want to analyze sales by individual customers?

Filtered Data

Transcribed Image Text:

Date 10/5/2025 10/8/2025 10/8/2025 10/11/2025 B 10/14/2025 10/14/2025 10/16/2025 10/21/2025 Invoice Customer-T SKU 6018 6030 6033 6054 6078 6080 6096 6121 3013 MEM-256 3013 PRK-CSE 3013 SKY-PRK 3013 SKY-CHG 3013 SK2-CIK 3013 CAM-FIL 3013 SKY-BAT 3013 SKY-PRK Description SanDisk 256 GB MicroSD Card Pro Hard Case Skydio 1 Pro Kit Dual Charger Skydio 2 Cinema Kit PolarPro ND Filters Skydio 1 Battery Skydio 1 Pro Kit Sales Pric Cost 69 229 2299 129 1799 69.99 115 2299 40 133 1234 77 1060 40 66 1234 Gross Margi Gross Margin Percenta ✓ 29 96 1065 52 739 29.99 49 1065 0.42 0.42 0.46 0.40 0.41 0.43 0.43 0.46