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

Pivot Table Data

Customer Color Name Color Type Yards Meters 1 Coriander White 219 200.3 2 Lynx Brown 243 222.2 3 Daffodil Yellow 439 401.4 4 Periwinkle Purple 181 165.5 5 Opal Blue 260 237.7 6 Toffee Brown 184 168.2 7 Ruby Red 415 379.5 8 Ash Blue 407 372.2 9 Ash Blue 236 215.8 10 Ash Blue 185 169.2 11 Whirlpool Blue 219 200.3 12 Whirlpool Blue 303 277.1 13 Verde Green 220 201.2 14 Regal Purple 246 224.9 15 Lynx Brown 289 264.3 16 Toffee Brown 297 271.6 17 Chocolate Brown 249 227.7 18 Mist White 176 160.9 19 Whirlpool Blue 100 91.4 20 Alfalfa Green 403 368.5 21 Ruby Red 361 330.1 22 Verde Green 373 341.1 23 Sky White 303 277.1 24 Chocolate Brown 396 362.1 25 Whirlpool Blue 321 293.5 26 Black Black 324 296.3 27 Mist White 160 146.3 28 Alfalfa Green 187 171.0 29 Jade Green 102 93.3 30 Opal Blue 157 143.6 31 Cream White 193 176.5 32 Chocolate Brown 104 95.1 33 Ruby Red 303 277.1 34 Mist White 438 400.5 35 Regal Purple 276 252.4 36 Jade Green 335 306.3 37 Sky White 284 259.7 38 Periwinkle Purple 261 238.7 39 Coriander White 445 406.9 40 Black Black 357 326.4 41 Ash Blue 261 238.7 42 Chocolate Brown 242 221.3 43 Periwinkle Purple 321 293.5 44 Black Black 155 141.7 45 Blush Red 146 133.5 46 Lynx Brown 312 285.3 47 Mist White 324 296.3 48 Coriander White 249 227.7 49 Cream White 356 325.5 50 Verde Green 427 390.4 51 Chocolate Brown 139 127.1 52 Daffodil Yellow 382 349.3 53 Chocolate Brown 337 308.2 54 Daffodil Yellow 201 183.8 55 Regal Purple 226 206.7 56 Sapphire Blue 211 192.9 57 Coriander White 224 204.8 58 Black Black 398 363.9 59 Lynx Brown 325 297.2 60 Lynx Brown 330 301.8 61 Periwinkle Purple 419 383.1 62 Chocolate Brown 344 314.6 63 Coriander White 153 139.9 64 Verde Green 328 299.9 65 Lynx Brown 110 100.6 66 Alfalfa Green 433 395.9 67 Cream White 190 173.7 68 Daffodil Yellow 176 160.9 69 Periwinkle Purple 320 292.6 70 Cream White 210 192.0 71 Toffee Brown 230 210.3 72 Opal Blue 261 238.7 73 Cream White 421 385.0 74 Cream White 143 130.8 75 Coriander White 199 182.0 76 Mist White 413 377.6 77 Verde Green 142 129.8 78 Toffee Brown 183 167.3 79 Blush Red 199 182.0 80 Opal Blue 199 182.0 81 Daffodil Yellow 375 342.9 82 Mist White 195 178.3 83 Alfalfa Green 280 256.0 84 Jade Green 274 250.5 85 Ruby Red 133 121.6 86 Verde Green 137 125.3 87 Cream White 242 221.3 88 Lynx Brown 344 314.6 89 Chocolate Brown 293 267.9 90 Regal Purple 124 113.4 91 Sky White 214 195.7 92 Regal Purple 377 344.7 93 Opal Blue 173 158.2 94 Lynx Brown 411 375.8 95 Regal Purple 151 138.1 96 Ash Blue 367 335.6 97 Periwinkle Purple 411 375.8 98 Black Black 338 309.1 99 Black Black 183 167.3 100 Blush Red 427 390.4 101 Regal Purple 433 395.9 102 Sapphire Blue 328 299.9 103 Whirlpool Blue 172 157.3 104 Chocolate Brown 102 93.3 105 Whirlpool Blue 258 235.9 106 Sapphire Blue 450 411.5 107 Chocolate Brown 407 372.2 108 Toffee Brown 240 219.5 109 Sapphire Blue 305 278.9 110 Whirlpool Blue 100 91.4 111 Black Black 283 258.8 112 Regal Purple 156 142.6 113 Opal Blue 134 122.5 114 Blush Red 301 275.2 115 Coriander White 430 393.2 116 Whirlpool Blue 215 196.6 117 Ash Blue 353 322.8 118 Blush Red 316 289.0 119 Black Black 370 338.3 120 Ruby Red 441 403.3 121 Mist White 134 122.5 122 Chocolate Brown 296 270.7 123 Opal Blue 182 166.4 124 Toffee Brown 395 361.2 125 Ash Brown 339 310.0

Explanation / Answer

Answer:

i am providing you the data in and how to use it step by step to find out all your answers

by clicking on any cell value of sheet 1 you can go into the "insert" and select pivot table .your data converted in to the pivot table on the new sheet.

ans.1: the pivot table shows you the total number of sales with reference to each type of color and yards and meters. on the sheet no 4 of the pivot table

Ans 2: sheet5 provides you which color type has the minimum sale and which color type has the maximum sale .

ans 3: two worst selling colors are 1) Ash 2) Jade

Two best selling color are 1) chocolate 2) Black

Values

Row Labels

Sum of Customer

Sum of Yards

Sum of Meters

Black

595

2408

2201.8

Black

595

2408

2201.8

Blue

1671

6157

5630.1

Ash

281

1809

1654.3

Opal

516

1366

1249.1

Sapphire

373

1294

1183.2

Whirlpool

501

1688

1543.5

Brown

1660

7141

6530.1

Ash

125

339

310

Chocolate

703

2909

2660.2

Lynx

429

2364

2161.8

Toffee

403

1529

1398.1

Green

658

3641

3329.2

Alfalfa

197

1303

1191.4

Jade

149

711

650.1

Verde

312

1627

1487.7

Purple

906

3902

3567.9

Periwinkle

312

1913

1749.2

Regal

594

1989

1818.7

Red

722

3042

2781.7

Blush

456

1389

1270.1

Ruby

266

1653

1511.6

White

1405

6315

5774.5

Coriander

398

1919

1754.8

Cream

451

1755

1604.8

Mist

405

1840

1682.4

Sky

151

801

732.5

Yellow

258

1573

1438.3

Daffodil

258

1573

1438.3

Grand Total

7875

34179

31253.6

next table

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

min

min

Yellow

1573

1438.3

max

max

Brown

7141

6530.1

Values

Row Labels

Sum of Customer

Sum of Yards

Sum of Meters

Black

595

2408

2201.8

Black

595

2408

2201.8

Blue

1671

6157

5630.1

Ash

281

1809

1654.3

Opal

516

1366

1249.1

Sapphire

373

1294

1183.2

Whirlpool

501

1688

1543.5

Brown

1660

7141

6530.1

Ash

125

339

310

Chocolate

703

2909

2660.2

Lynx

429

2364

2161.8

Toffee

403

1529

1398.1

Green

658

3641

3329.2

Alfalfa

197

1303

1191.4

Jade

149

711

650.1

Verde

312

1627

1487.7

Purple

906

3902

3567.9

Periwinkle

312

1913

1749.2

Regal

594

1989

1818.7

Red

722

3042

2781.7

Blush

456

1389

1270.1

Ruby

266

1653

1511.6

White

1405

6315

5774.5

Coriander

398

1919

1754.8

Cream

451

1755

1604.8

Mist

405

1840

1682.4

Sky

151

801

732.5

Yellow

258

1573

1438.3

Daffodil

258

1573

1438.3

Grand Total

7875

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.