Saeko has a yarn shop and wants to expand the colors in her yarn lines. She send

Question

Saeko has a yarn shop and wants to expand the colors in her yarn lines. She sends you the raw data in the "Pivot Table Data" tab.This data consists of the number of yards and meters of the color names, and the color types that each name belongs to, sold during her busiest weekend last year.

1. Use the "Pivot Table Data" tab to create a pivot table that shows Saeko the number of yards and meters that were sold in the various yarn types during the busiest weekend of her shop last year.

Using the pivot table that you just created, determine which of the color types sold the least amount of meters using =MIN()

Using the pivot table that you just created, determine which of the color types sold the largest amount of meters using =MAX()

If Saeko wants to expand the colors in both the best selling and the worst selling color type, which two color types should she buy?

Please show excel steps

Explanation / Answer

Ans: 1: the above table shows you the adata

color type yards meter Values Row Labels Sum of Yards Sum of Meters Black 2408 2201.8 Blue 6157 5630.1 Brown 7141 6530.1 Green 3641 3329.2 Purple 3902 3567.9 Red 3042 2781.7 White 6315 5774.5 Yellow 1573 1438.3 Grand Total 34179 31253.6

Related Questions

Navigate

• Browse (All)
• Browse S
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.