You are given data on production of 5 products at plants in 4 cities.

Use a PivotTable to summarize the fraction of defective products produced at each plant.
Setup a slicer that let's me show any subset of products and a timeline that let's me slice and d
Task Questions to be answered:
1.1 Which plant appears to produce the highest percentage of defectives? The lowest?
1.2 Which plant has the highest percentage of defectives for product D in 2017?
1.3 Which plant has the lowest percentage of defectives on average for products A and E in 2019

Product Location Date Produced Defectives

B Dallas 6/17/2020 568 22
E Houston 9/22/2016 192 6
B Houston 6/12/2018 531 26
E Houston 3/24/2019 677 20
E San Antonio 1/14/2020 550 36
B Houston 2/24/2019 663 24
D Houston 10/2/2017 369 19
E Dallas 11/8/2017 421 6 This shape represents a slic
A Houston 2/26/2018 484 21 Slicers are supported in Ex
E El Paso 4/5/2019 482 37 2010 or later.
D Houston 6/7/2020 163 7
D Dallas 2/3/2020 482 19 If the shape was modified i
an earlier version of Excel,
D Dallas 6/10/2020 711 26
if the workbook was saved
D El Paso 12/2/2017 726 49 Excel 2003 or earlier, the
C Dallas 10/25/2017 592 16 slicer cannot be used.
E San Antonio 11/13/2016 649 41
C Houston 4/3/2019 292 13
C El Paso 8/25/2017 619 40
A Dallas 4/3/2018 640 18
C Houston 4/29/2017 637 32
B Dallas 12/8/2019 649 23
E San Antonio 8/8/2017 659 37
E Dallas 3/22/2020 587 18
B Houston 7/20/2017 499 25
E Houston 2/27/2018 711 20
C San Antonio 11/16/2016 425 16
D Houston 12/4/2018 460 19
D Houston 7/12/2017 563 25
D Dallas 8/16/2016 482 12
A Dallas 7/10/2019 294 3
D Dallas 5/27/2018 202 6
E San Antonio 9/12/2019 742 34
E Dallas 3/14/2020 417 8
A El Paso 2/15/2019 262 21
C Dallas 7/8/2017 541 16
B Dallas 9/13/2019 275 6
D Houston 5/11/2017 329 11
C Dallas 9/29/2016 265 7
C Dallas 3/6/2020 615 16
E Dallas 2/23/2018 703 25
C Houston 8/1/2016 189 6
C Houston 1/9/2018 754 29
A Houston 4/10/2017 704 32
C El Paso 11/14/2017 418 26
B Dallas 7/5/2017 330 6
C Dallas 4/3/2018 617 19
B Houston 6/11/2020 267 13
D Dallas 12/27/2018 451 14
D Houston 7/26/2018 288 12
E El Paso 6/27/2019 394 24
B Houston 5/31/2020 167 7
E Houston 4/3/2020 222 7
D Houston 1/12/2020 706 20
D El Paso 11/15/2018 665 43
E Houston 3/4/2018 167 8
E San Antonio 8/3/2016 706 25
C Houston 3/1/2020 687 28
C El Paso 7/24/2018 157 8
C Houston 7/25/2018 167 5
C Houston 12/10/2018 480 18
E Dallas 6/11/2019 497 14
C Houston 12/9/2019 547 21
E Houston 5/24/2018 410 5
E Houston 11/11/2018 214 6
A Dallas 9/29/2019 523 14
B Dallas 3/19/2018 374 8
E Dallas 10/30/2019 334 13
E Dallas 12/24/2016 693 20
E Dallas 7/16/2017 215 9
E Houston 10/19/2019 546 20
E San Antonio 2/4/2017 509 27
E Dallas 8/4/2018 538 17
E Dallas 11/12/2017 734 22
D Dallas 5/19/2018 509 12
A Houston 8/6/2016 244 5
B Dallas 7/24/2016 361 10
E El Paso 10/20/2016 366 30
C El Paso 8/26/2017 618 41
B Dallas 4/5/2019 717 20
E Houston 10/26/2019 639 29
E Dallas 2/8/2019 441 17
E Houston 1/1/2018 409 18
B El Paso 11/26/2016 323 17
D El Paso 12/5/2017 238 18
E Houston 2/1/2017 263 13
E El Paso 4/10/2017 539 40
E El Paso 11/23/2018 721 54
D Houston 7/31/2018 575 30
D Dallas 12/4/2019 581 16
C San Antonio 6/15/2018 190 17
C Houston 6/21/2018 356 19
B El Paso 10/26/2019 524 27
E Houston 5/1/2020 288 11
D Houston 6/15/2020 709 26
C Houston 1/15/2017 465 16
E San Antonio 6/10/2019 197 11
B Houston 1/24/2017 665 34
C Dallas 10/4/2017 287 6
B El Paso 12/16/2018 693 42
C San Antonio 7/31/2018 418 17
E Dallas 1/6/2017 717 23
E El Paso 9/20/2018 447 25
C Dallas 2/16/2017 565 7
E El Paso 7/6/2017 430 27
B Houston 3/16/2019 413 12
E Dallas 9/27/2019 642 16
C Dallas 8/23/2016 222 1
B Houston 8/6/2018 471 15
C El Paso 6/18/2020 513 36
D Dallas 12/18/2018 571 12
D Dallas 9/3/2017 611 16
E Houston 7/10/2018 728 24
B El Paso 12/8/2019 679 59
E Houston 7/4/2017 697 23
B El Paso 10/11/2018 173 8
D El Paso 1/4/2017 747 55
E Dallas 9/30/2019 258 9
D Houston 12/24/2018 692 31
B Dallas 8/17/2017 750 18
C Dallas 6/14/2018 356 12
A El Paso 5/31/2019 596 45
A San Antonio 12/24/2016 642 36
E El Paso 8/6/2018 508 40
D Houston 8/27/2018 710 23
E Dallas 6/22/2017 660 18
C Dallas 6/30/2019 518 14
E El Paso 1/22/2017 431 22
C Houston 6/5/2019 421 23
B El Paso 2/2/2017 431 28
E Dallas 5/28/2020 357 12
B San Antonio 5/27/2020 681 37
C El Paso 8/8/2018 225 26
E Dallas 12/4/2018 534 18
A El Paso 4/9/2020 207 18
C El Paso 12/6/2018 640 50
E Dallas 4/1/2017 430 12
C Dallas 1/24/2018 379 10
B Houston 2/11/2020 316 13
E Houston 12/8/2019 630 26
A Houston 9/25/2019 266 11
B El Paso 9/8/2018 612 41
D El Paso 5/28/2020 749 45
C Dallas 4/21/2020 392 12
B Dallas 12/4/2018 578 22
D Houston 4/4/2019 214 12
C Houston 7/16/2017 387 20
A Houston 11/17/2017 619 21
E San Antonio 9/22/2017 262 13
C El Paso 9/10/2019 512 39
C Dallas 9/6/2019 374 12
E El Paso 9/15/2019 441 29
E Dallas 4/9/2018 556 13
B Houston 10/2/2017 680 23
B Houston 6/3/2020 283 10
E El Paso 6/14/2018 331 17
B Dallas 1/29/2017 478 10
E Houston 1/10/2018 680 21
D Dallas 10/11/2018 628 18
D Dallas 12/26/2018 373 17
C Dallas 5/29/2017 437 11
B Houston 5/26/2019 750 34
C San Antonio 4/16/2018 261 16
E Dallas 9/12/2018 729 27
C Houston 8/25/2016 235 14
E Houston 2/2/2020 222 7
B Houston 3/25/2020 616 20
B Houston 9/23/2017 595 23
A Houston 4/11/2017 634 29
B San Antonio 7/31/2017 728 35
C San Antonio 1/25/2018 740 34
B Houston 5/18/2019 667 23
E Dallas 3/13/2019 252 12
B Dallas 7/20/2017 409 14
E Dallas 6/19/2017 664 18
E Houston 12/2/2019 752 34
B Houston 2/1/2020 210 12
E Dallas 8/6/2016 512 9
E El Paso 11/22/2016 752 54
C El Paso 12/24/2016 308 22
C Houston 4/9/2017 323 13
E Houston 8/4/2018 485 13
B Dallas 9/19/2019 361 5
C Houston 3/25/2020 679 36
C Houston 5/24/2017 744 32
B Houston 9/10/2019 555 24
B Houston 3/18/2018 205 6
C Houston 12/15/2017 316 8
E San Antonio 3/19/2020 478 23
C Dallas 8/28/2019 621 15
D San Antonio 8/13/2017 477 20
C Houston 4/11/2017 662 21
B Houston 3/1/2017 243 12
C Dallas 4/6/2017 598 24
E Houston 1/22/2018 483 20
B Houston 4/10/2017 661 19
C Houston 1/8/2020 347 21
C El Paso 6/10/2019 358 18
C Dallas 3/10/2017 428 13
E San Antonio 4/29/2019 706 42
C Dallas 5/14/2017 271 4
A El Paso 4/21/2019 356 17
B El Paso 5/18/2017 272 24
B Dallas 8/14/2016 641 18
A Houston 10/23/2016 224 5
B Dallas 3/14/2017 201 7
C Houston 11/19/2018 641 36
B Dallas 11/15/2018 689 28
E El Paso 5/1/2019 379 29
E Dallas 4/30/2018 600 24
D El Paso 5/8/2017 641 38
A San Antonio 3/11/2018 252 10
D Dallas 8/11/2016 201 4
B Dallas 1/13/2018 308 8
B Houston 7/20/2016 299 13
E Houston 2/24/2019 442 17
C El Paso 12/31/2018 372 28
B El Paso 1/19/2020 429 37
A Dallas 5/10/2020 521 17
E El Paso 12/23/2019 322 22
A Dallas 12/27/2018 431 14
B San Antonio 4/19/2020 740 30
B Dallas 8/13/2018 480 15
C Houston 9/27/2018 709 31
A Dallas 5/7/2019 446 18
C El Paso 1/11/2019 327 25
E Dallas 5/16/2017 221 6
E El Paso 11/29/2017 241 18
B Dallas 8/1/2017 547 19
C Houston 2/21/2017 628 30
E Houston 8/6/2016 505 19
A Houston 11/2/2019 213 9
C Houston 5/11/2019 337 9
D Dallas 5/31/2018 410 13
C Dallas 3/19/2020 183 4
C Houston 4/9/2019 729 30
C El Paso 8/15/2019 612 34
C Dallas 4/1/2020 179 8
B Houston 6/12/2017 157 4
B Houston 11/22/2016 447 17
D El Paso 11/27/2019 255 18
E El Paso 2/17/2018 369 26
D San Antonio 6/29/2019 190 6
C Houston 1/7/2018 635 27
B Dallas 2/17/2019 736 20
C El Paso 6/7/2020 564 49
C El Paso 5/18/2018 397 29
B El Paso 8/5/2017 634 32
C Houston 11/24/2019 623 37
B Dallas 1/15/2019 630 24
B El Paso 9/30/2017 215 15
E Houston 5/18/2020 714 19
B Houston 7/31/2016 679 21
E El Paso 10/5/2016 631 56
B Houston 4/18/2018 308 14
E Houston 10/15/2017 641 26
C Houston 1/31/2020 273 10
E Dallas 9/9/2017 473 10
D Houston 4/12/2019 450 24
A El Paso 12/4/2019 256 11
E El Paso 8/28/2016 273 18
D Houston 6/2/2019 517 24
E San Antonio 12/6/2017 316 13
E Houston 7/6/2018 514 16
E San Antonio 12/10/2018 252 10
C Houston 9/23/2017 744 26
C Dallas 4/26/2017 250 12
D Dallas 5/22/2019 338 6
E El Paso 5/12/2020 736 56
A Houston 3/2/2019 475 17
C Dallas 12/20/2019 345 10
A Dallas 11/4/2018 247 9
D Houston 8/19/2019 715 24
E Houston 11/17/2016 477 19
B Dallas 9/18/2016 260 7
E Houston 12/9/2017 314 15
C El Paso 1/11/2019 156 11
C Dallas 8/9/2016 383 16
C Houston 1/5/2017 307 15
C San Antonio 12/30/2017 159 8
E Houston 6/14/2020 254 15
E San Antonio 8/20/2018 206 14
C Houston 9/10/2018 251 11
D El Paso 7/5/2019 598 45
D Houston 3/22/2017 383 18
E Dallas 11/3/2019 170 6
B Dallas 11/5/2017 334 12
E Houston 3/3/2020 540 15
B San Antonio 5/30/2020 394 21
B Dallas 10/26/2017 636 25
B Dallas 3/3/2018 481 16
B Dallas 3/23/2018 205 6
E El Paso 9/10/2018 446 24
B Dallas 6/14/2020 678 19
D Houston 11/23/2017 240 5
E Houston 9/27/2016 162 9
C Dallas 9/12/2016 403 5
D El Paso 11/30/2017 260 19
E Dallas 1/15/2020 224 6
A El Paso 12/27/2017 674 39
E San Antonio 11/16/2019 688 39
C Houston 11/25/2017 463 18
E Houston 11/17/2016 379 17
E El Paso 11/12/2018 308 25
D Dallas 10/19/2018 566 18
B Houston 6/18/2018 742 27
E Houston 6/1/2019 248 6
B San Antonio 3/6/2017 305 9
E Dallas 12/26/2019 618 19
E Houston 9/9/2019 609 24
E Houston 5/17/2019 209 13
C Houston 5/28/2020 592 16
E Houston 6/23/2018 698 29
D San Antonio 9/5/2017 259 9
D Houston 3/13/2017 217 13
A Houston 10/21/2019 486 16
B Houston 2/5/2019 688 23
C El Paso 7/30/2016 576 32
E San Antonio 2/29/2020 468 16
B Houston 5/9/2017 247 13
B Houston 2/5/2020 701 31
A El Paso 3/10/2020 629 59
B Houston 6/11/2017 508 17
E Dallas 1/16/2020 303 8
A Houston 1/22/2017 499 21
B Houston 5/14/2020 382 16
E Houston 3/22/2020 634 25
E El Paso 9/23/2017 361 24
C Houston 4/10/2020 418 13
C El Paso 12/28/2018 237 20
C Houston 11/21/2018 198 10
E Houston 4/28/2020 648 36
A Houston 7/22/2018 727 31
E Houston 9/5/2019 390 18
C San Antonio 10/5/2019 197 10
B El Paso 12/12/2018 751 41
B Dallas 8/28/2018 720 20
E El Paso 1/21/2018 557 49
C Houston 2/10/2018 515 17
C Dallas 7/18/2019 211 6
E Dallas 4/19/2017 441 8
D San Antonio 3/9/2019 316 18
D Dallas 7/8/2017 749 24
C Dallas 8/6/2018 243 9
B Houston 7/4/2018 350 10
B Houston 1/18/2019 622 24
A Dallas 1/26/2017 164 6
C Dallas 1/1/2018 726 32
B Houston 4/14/2017 663 24
E San Antonio 2/5/2018 696 35
E Houston 8/17/2016 257 7
A San Antonio 10/16/2019 463 20
E Houston 11/10/2017 649 26
E Houston 3/2/2020 294 8
C El Paso 5/12/2018 565 47
C Dallas 6/13/2018 298 11
C Houston 5/6/2019 173 7
C Houston 9/16/2019 186 7
C El Paso 5/29/2018 670 42
C Houston 2/26/2018 456 19
E Dallas 11/10/2016 739 23
C San Antonio 3/24/2017 237 15
E Houston 8/24/2017 232 11
E Dallas 8/27/2017 652 30
C Houston 11/15/2017 200 8
A Dallas 1/26/2019 575 19
C El Paso 5/20/2019 738 61
B Houston 12/10/2018 688 32
E San Antonio 5/23/2020 226 13
D Houston 1/27/2019 583 27
D El Paso 8/28/2017 317 17
E Dallas 12/11/2017 386 10
E Dallas 9/6/2017 623 11
A San Antonio 11/11/2019 281 17
B San Antonio 3/30/2018 634 40
B Dallas 3/10/2020 627 23
B Dallas 5/8/2020 304 15
D San Antonio 1/20/2020 466 27
A Dallas 10/12/2016 652 17
B Dallas 3/25/2020 184 3
C Houston 9/14/2018 636 26
E Houston 6/18/2019 432 16
D Houston 4/1/2020 335 15
A Houston 3/11/2018 563 20
B Houston 4/3/2018 363 20
B Houston 11/8/2019 734 29
C Houston 6/28/2017 638 29
E Dallas 1/7/2018 180 2
E Houston 5/17/2020 738 26
B Houston 5/25/2019 630 21
C San Antonio 1/21/2017 241 11
E El Paso 6/29/2017 363 28
E Houston 6/3/2017 468 16
C Houston 3/31/2020 663 28
E Dallas 7/1/2017 484 13
E San Antonio 2/10/2018 268 20
D Houston 1/18/2020 606 29
E Houston 10/26/2019 704 36
C Dallas 7/31/2019 748 20
C Dallas 11/12/2017 323 6
A Dallas 10/11/2019 613 20
B Dallas 7/28/2016 671 18
A El Paso 12/6/2018 281 17
B Houston 4/28/2020 396 18
C Houston 10/17/2016 309 10
D San Antonio 1/8/2020 178 8
D El Paso 12/19/2016 709 44
E Houston 5/27/2020 474 16
B Dallas 12/4/2018 658 14
B Houston 1/5/2019 645 30
C San Antonio 12/21/2019 435 27
B Houston 6/9/2018 227 10
B El Paso 3/20/2017 432 36
C Dallas 6/9/2020 561 20
D Dallas 11/10/2017 179 7
B El Paso 7/31/2016 218 12
E San Antonio 4/25/2017 429 21
E El Paso 12/24/2016 390 34
D Dallas 12/29/2017 595 25
A El Paso 4/3/2017 460 23
C Dallas 11/9/2019 246 4
C El Paso 12/6/2016 608 39
E Dallas 6/8/2020 566 22
C Dallas 12/2/2017 414 7
A El Paso 3/31/2020 273 19
E Dallas 1/19/2019 663 20
C San Antonio 10/25/2017 164 10
C El Paso 7/8/2017 509 32
B Houston 6/14/2018 573 24
A San Antonio 10/18/2016 334 14
C San Antonio 1/21/2017 448 23
C Dallas 8/22/2017 513 11
C Houston 4/15/2018 683 27
E El Paso 8/3/2016 611 47
D Dallas 9/13/2017 169 4
B Dallas 4/20/2018 372 12
C El Paso 6/1/2017 603 34
B Houston 10/12/2016 199 7
A Dallas 8/18/2016 533 14
C Houston 1/30/2019 514 21
C El Paso 3/3/2020 742 50
A Dallas 4/16/2020 449 16
D Dallas 2/8/2020 512 11
C Houston 5/22/2019 567 23
C Dallas 2/18/2017 382 9
E Dallas 12/14/2018 556 17
E San Antonio 9/13/2019 452 21
E San Antonio 3/25/2018 438 16
E Dallas 3/19/2018 473 17
C Houston 5/30/2019 562 22
E El Paso 12/6/2019 157 9
B Dallas 2/26/2017 319 6
D Dallas 4/24/2020 153 6
C Houston 2/27/2017 607 34
B San Antonio 9/26/2016 545 23
E Dallas 12/20/2018 601 20
E San Antonio 1/7/2017 575 28
B Dallas 3/6/2019 738 25
C Houston 8/9/2018 635 34
E San Antonio 9/24/2016 428 22
A Houston 10/26/2017 594 23
E Dallas 6/20/2018 743 22
E El Paso 9/28/2017 706 49
E Houston 1/24/2020 378 17
D Dallas 7/26/2016 398 16
B El Paso 8/7/2019 640 43
E El Paso 6/10/2018 520 36
E Houston 3/6/2019 710 32
C San Antonio 1/17/2018 316 12
D Houston 4/16/2018 612 20
D El Paso 2/13/2018 750 54
C Dallas 10/12/2019 198 5
E Houston 4/10/2018 613 24
B Dallas 1/23/2019 542 11
B Dallas 12/8/2018 679 16
E San Antonio 1/4/2019 254 20
B San Antonio 1/5/2019 466 24
D Dallas 4/26/2019 741 23
D Houston 10/13/2016 725 30
D El Paso 7/17/2019 492 33
C Houston 5/21/2018 679 20
A Dallas 4/5/2017 718 24
E San Antonio 6/12/2017 350 12
D Houston 1/30/2017 178 5
A Houston 1/26/2018 622 18
D Houston 3/22/2019 615 23
D El Paso 5/31/2019 498 34
C San Antonio 7/15/2018 727 42
A Dallas 5/26/2017 559 13
D Dallas 2/12/2017 592 15
ducts produced at each plant.
d a timeline that let's me slice and dice over time.

of defectives? The lowest?

product D in 2017?
average for products A and E in 2019?

Sum of Defectives Years

Location 2016 2017 2018 2019 2020 Grand Total
Dallas 1.97% 5.90% 6.12% 4.66% 3.12% 21.78%
El Paso 4.06% 7.76% 7.94% 6.93% 3.70% 30.38%
Houston 2.05% 8.50% 9.44% 9.37% 5.92% 35.29%
San Antonio 1.77% 2.92% 2.84% 2.90% 2.12% 12.54%
Grand Total 9.86% 25.08% 26.34% 23.86% 14.86% 100.00%

This shape represents a slicer. Timeline: Works in Excel 2013 or higher. Do not move or
Slicers are supported in Excel resize.
2010 or later.

If the shape was modified in

an earlier version of Excel, or
if the workbook was saved in
Excel 2003 or earlier, the
slicer cannot be used.

Question
1.1 The highest percentage of defectives is at Houston, meanwhile San Antonio
1.2 The highest percentage of defectives for product D in 2017 is at El Paso.
1.3 The lowest percentage of defectives on average for product A and E in 2019
 meanwhile San Antonio has the lowest percentage of defectives.
in 2017 is at El Paso.
product A and E in 2019 is at Dallas.
 Everything before the hyphen is a product code and the number after the hyphen is units sold.
The letter indicates the product family.
Task
Use a PivotTable to determine total units sold for each product family.
Summarize the total units sold with a Pie Chart.

Product Family Hyphen Units Sold Family

C694-8459 C 5 8459 A
B75497- 86 B 7 86 B
F721-9831 F 5 9831 C
F31865- 84 F 7 84 D
B827-6343 B 5 6343 E
C44961- 51 C 7 51 F
E618-9241 E 5 9241 Grand Total
C63712- 75 C 7 75
E915-7859 E 5 7859
B62127- 73 B 7 73 Breakdown of To
A728-1797 A 5 1797 Prod
F67159- 12 F 7 12
F214-1865 F 5 1865
D48738- 89 D 7 89
E165-1167 E 5 1167
A74459- 14 A 7 14
B436-9915 B 5 9915
C82895- 92 C 7 92
C552-1868 C 5 1868
Grand Total
D92869- 78 D 7 78 50%
E933-7894 E 5 7894
B76312- 87 B 7 87
E346-6444 E 5 6444
A65852- 21 A 7 21
F928-5145 F 5 5145
A95334- 14 A 7 14
F389-5453 F 5 5453
F14311- 41 F 7 41
E778-9638 E 5 9638
A95583- 17 A 7 17
E964-7464 E 5 7464
E84987- 72 E 7 72
C726-1289 C 5 1289
D38788- 86 D 7 86
F219-1258 F 5 1258
F61634- 48 F 7 48
D358-6224 D 5 6224
B18429- 84 B 7 84
B816-9663 B 5 9663
B13399- 66 B 7 66
B959-5857 B 5 5857
C44696- 75 C 7 75
A753-5643 A 5 5643
B31829- 34 B 7 34
B455-1292 B 5 1292
D19368- 24 D 7 24
B736-9776 B 5 9776
E99123- 55 E 7 55
E386-2276 E 5 2276
F58288- 97 F 7 97
F387-8529 F 5 8529
E95581- 95 E 7 95
C898-2788 C 5 2788
B35728- 13 B 7 13
A573-4681 A 5 4681
D48349- 58 D 7 58
B212-8439 B 5 8439
D55461- 24 D 7 24
F754-3152 F 5 3152
C67487- 99 C 7 99
E348-2928 E 5 2928
A22468- 77 A 7 77
F495-5622 F 5 5622
A51132- 37 A 7 37
A838-8666 A 5 8666
B42782- 49 B 7 49
E646-1795 E 5 1795
F97588- 78 F 7 78
A899-5965 A 5 5965
E42869- 33 E 7 33
F945-9551 F 5 9551
A98586- 44 A 7 44
B974-9727 B 5 9727
D62438- 85 D 7 85
D856-9153 D 5 9153
B67766- 57 B 7 57
E297-9412 E 5 9412
C13672- 79 C 7 79
F226-4987 F 5 4987
B38312- 23 B 7 23
B963-9397 B 5 9397
B93413- 91 B 7 91
C674-5885 C 5 5885
D52362- 65 D 7 65
E197-7697 E 5 7697
F38284- 75 F 7 75
D927-9282 D 5 9282
B75179- 62 B 7 62
D414-3912 D 5 3912
D96751- 17 D 7 17
C847-2331 C 5 2331
D37673- 57 D 7 57
D175-4812 D 5 4812
F74619- 55 F 7 55
F856-1714 F 5 1714
B21176- 34 B 7 34
D549-4367 D 5 4367
E93979- 26 E 7 26
B673-6155 B 5 6155
B33226- 91 B 7 91
D191-8833 D 5 8833
D31295- 26 D 7 26
D129-6328 D 5 6328
B51788- 94 B 7 94
F942-7831 F 5 7831
B35671- 12 B 7 12
D134-8172 D 5 8172
B17651- 43 B 7 43
F187-7834 F 5 7834
E19593- 42 E 7 42
D867-5665 D 5 5665
D33396- 31 D 7 31
F971-1787 F 5 1787
C96864- 79 C 7 79
E873-5963 E 5 5963
C63413- 74 C 7 74
E296-8583 E 5 8583
B62647- 41 B 7 41
F352-3879 F 5 3879
F13514- 92 F 7 92
C573-4739 C 5 4739
E64936- 24 E 7 24
E789-7681 E 5 7681
D41492- 54 D 7 54
D917-6886 D 5 6886
C25642- 78 C 7 78
F468-7997 F 5 7997
E22983- 96 E 7 96
A736-4944 A 5 4944
B83529- 11 B 7 11
B146-3655 B 5 3655
E78147- 94 E 7 94
F589-2645 F 5 2645
F94642- 98 F 7 98
B175-6786 B 5 6786
E19582- 69 E 7 69
B161-8125 B 5 8125
F47525- 65 F 7 65
F525-5126 F 5 5126
F51239- 89 F 7 89
E877-3128 E 5 3128
B15936- 92 B 7 92
E424-8373 E 5 8373
D67531- 67 D 7 67
E928-3881 E 5 3881
A63328- 24 A 7 24
C321-1461 C 5 1461
E87662- 55 E 7 55
D115-2124 D 5 2124
C71297- 87 C 7 87
F644-2716 F 5 2716
E57574- 73 E 7 73
A726-1196 A 5 1196
A99383- 23 A 7 23
D827-2397 D 5 2397
D84874- 12 D 7 12
E578-7359 E 5 7359
A37594- 91 A 7 91
F248-7915 F 5 7915
D33393- 95 D 7 95
D432-9853 D 5 9853
B93164- 44 B 7 44
D543-8239 D 5 8239
D14713- 86 D 7 86
C521-4235 C 5 4235
B34129- 85 B 7 85
E685-7118 E 5 7118
E77792- 72 E 7 72
F545-9658 F 5 9658
A48142- 74 A 7 74
B155-4862 B 5 4862
B81263- 58 B 7 58
F823-4174 F 5 4174
E68413- 87 E 7 87
C498-6598 C 5 6598
E54345- 16 E 7 16
C259-9213 C 5 9213
D51179- 79 D 7 79
D194-4679 D 5 4679
B58141- 16 B 7 16
C517-1999 C 5 1999
D66683- 33 D 7 33
F455-1356 F 5 1356
F62524- 53 F 7 53
F737-1399 F 5 1399
C74994- 21 C 7 21
B452-6519 B 5 6519
E61361- 61 E 7 61
F574-5122 F 5 5122
F85149- 57 F 7 57
F895-9383 F 5 9383
B71682- 75 B 7 75
D338-6138 D 5 6138
B79166- 62 B 7 62
C739-8132 C 5 8132
F77235- 25 F 7 25
C621-5535 C 5 5535
D12229- 44 D 7 44
F326-7377 F 5 7377
E87658- 88 E 7 88
F663-6495 F 5 6495
F44969- 72 F 7 72
C186-1432 C 5 1432
B11687- 47 B 7 47
D245-6651 D 5 6651
A75964- 86 A 7 86
B721-1753 B 5 1753
F32543- 84 F 7 84
C241-2863 C 5 2863
C62446- 49 C 7 49
A767-9373 A 5 9373
C83957- 16 C 7 16
B398-7891 B 5 7891
A25832- 99 A 7 99
B537-3349 B 5 3349
D19444- 87 D 7 87
A953-8469 A 5 8469
B52845- 29 B 7 29
F981-6836 F 5 6836
F86262- 92 F 7 92
B456-8311 B 5 8311
F92739- 76 F 7 76
F861-1985 F 5 1985
A34935- 39 A 7 39
D389-5794 D 5 5794
A83883- 83 A 7 83
E683-2346 E 5 2346
C24153- 73 C 7 73
F464-9271 F 5 9271
D56526- 17 D 7 17
D786-2576 D 5 2576
F63696- 37 F 7 37
D573-1747 D 5 1747
A74273- 14 A 7 14
B932-1944 B 5 1944
D94825- 13 D 7 13
F578-5756 F 5 5756
B62992- 88 B 7 88
B223-2656 B 5 2656
A69222- 95 A 7 95
C146-5977 C 5 5977
D37815- 83 D 7 83
E524-7764 E 5 7764
B67944- 49 B 7 49
A437-2693 A 5 2693
A22295- 85 A 7 85
A237-2763 A 5 2763
A49193- 72 A 7 72
E969-9893 E 5 9893
B38541- 43 B 7 43
D845-2191 D 5 2191
E19898- 42 E 7 42
D697-6626 D 5 6626
F66315- 84 F 7 84
D725-2364 D 5 2364
F18765- 46 F 7 46
F329-7778 F 5 7778
E84459- 23 E 7 23
A267-8919 A 5 8919
D94656- 39 D 7 39
E452-4234 E 5 4234
C41468- 23 C 7 23
C992-8221 C 5 8221
D82562- 11 D 7 11
E972-4563 E 5 4563
C33228- 97 C 7 97
D638-8153 D 5 8153
F81562- 86 F 7 86
B646-1213 B 5 1213
E72123- 65 E 7 65
C149-8957 C 5 8957
E37783- 99 E 7 99
C296-2478 C 5 2478
D49179- 76 D 7 76
F231-5249 F 5 5249
D35517- 51 D 7 51
E451-3246 E 5 3246
D56366- 22 D 7 22
C897-8798 C 5 8798
E31315- 82 E 7 82
F765-5173 F 5 5173
E32934- 14 E 7 14
B564-5577 B 5 5577
A37711- 16 A 7 16
C691-1569 C 5 1569
C47278- 41 C 7 41
F386-5586 F 5 5586
D32119- 93 D 7 93
B683-3172 B 5 3172
B18278- 43 B 7 43
B271-1459 B 5 1459
F53315- 81 F 7 81
F443-3437 F 5 3437
B33957- 88 B 7 88
A477-6799 A 5 6799
E61811- 75 E 7 75
D123-5112 D 5 5112
C77195- 88 C 7 88
B931-6328 B 5 6328
E71421- 54 E 7 54
D525-1539 D 5 1539
B24178- 76 B 7 76
E643-7948 E 5 7948
F18632- 71 F 7 71
A812-9799 A 5 9799
F26753- 58 F 7 58
A926-3987 A 5 3987
E89617- 19 E 7 19
D174-4225 D 5 4225
C73418- 36 C 7 36
E467-3844 E 5 3844
F11933- 83 F 7 83
F419-1478 F 5 1478
B33916- 92 B 7 92
B826-2412 B 5 2412
B46312- 66 B 7 66
F586-4633 F 5 4633
B84266- 17 B 7 17
F639-6111 F 5 6111
C37939- 34 C 7 34
B938-8787 B 5 8787
E71373- 91 E 7 91
D171-8114 D 5 8114
E98399- 76 E 7 76
C458-9458 C 5 9458
E14427- 59 E 7 59
B242-9566 B 5 9566
B82794- 37 B 7 37
B464-3354 B 5 3354
F92528- 77 F 7 77
E963-9271 E 5 9271
A57139- 25 A 7 25
C548-4421 C 5 4421
E22895- 95 E 7 95
B432-2183 B 5 2183
E12837- 43 E 7 43
E592-7826 E 5 7826
D71572- 83 D 7 83
D275-3897 D 5 3897
F42624- 21 F 7 21
B685-4323 B 5 4323
F91328- 41 F 7 41
F246-1156 F 5 1156
F16721- 57 F 7 57
C568-8822 C 5 8822
D11182- 98 D 7 98
E947-9324 E 5 9324
F34239- 17 F 7 17
B299-1176 B 5 1176
B88748- 29 B 7 29
C537-1126 C 5 1126
F62744- 53 F 7 53
C568-6272 C 5 6272
C35859- 46 C 7 46
F778-7974 F 5 7974
F95876- 94 F 7 94
F562-5238 F 5 5238
F41314- 18 F 7 18
E917-3457 E 5 3457
D25365- 78 D 7 78
F217-9969 F 5 9969
C12582- 69 C 7 69
E845-6263 E 5 6263
F37994- 78 F 7 78
D589-3733 D 5 3733
F87238- 63 F 7 63
F488-7428 F 5 7428
E71588- 83 E 7 83
F396-6755 F 5 6755
E75871- 87 E 7 87
A853-5735 A 5 5735
B44397- 93 B 7 93
B527-6717 B 5 6717
C97765- 95 C 7 95
F338-8199 F 5 8199
D99962- 48 D 7 48
F254-9786 F 5 9786
D55646- 67 D 7 67
D148-5437 D 5 5437
C83373- 31 C 7 31
B991-6257 B 5 6257
D69297- 48 D 7 48
F174-6311 F 5 6311
E33385- 59 E 7 59
A434-7677 A 5 7677
D28868- 93 D 7 93
B944-8949 B 5 8949
D73835- 52 D 7 52
A158-1264 A 5 1264
B46896- 28 B 7 28
D141-1727 D 5 1727
E34452- 45 E 7 45
F787-8382 F 5 8382
B35598- 33 B 7 33
A461-3274 A 5 3274
F63442- 29 F 7 29
D417-1338 D 5 1338
C57244- 81 C 7 81
A889-2716 A 5 2716
A47687- 19 A 7 19
E779-7861 E 5 7861
B97928- 59 B 7 59
E769-6628 E 5 6628
F85516- 56 F 7 56
F292-2411 F 5 2411
B54196- 38 B 7 38
D689-8499 D 5 8499
D36983- 93 D 7 93
B135-9526 B 5 9526
A17342- 36 A 7 36
E126-9968 E 5 9968
E95793- 45 E 7 45
C592-1155 C 5 1155
after the hyphen is units sold.

Sum of Units Sold% Breakdown of Units Sold

107,465 9%
215,852 18%
137,670 12%
189,049 16%
232,551 20%
289,146 25%
1,171,733 100%

Breakdown of Total Units Sold based on

Product Family
A
5%
B
9%

C
6%

D
Grand Total 8%
50%

E
10%

F
12%
 In this worksheet you are given the following information about a sample of people that is represen
1. Do they subscribe to Garden and Gun Magazine?
2. Income Level (Upper, Middle, or Low)
3. Location ( Urban, Rural, or Suburban)
Task
Summarize your PivotTable with 6 pie charts as below:
- 3 charts to show Magazine Subscription based on Income Level
- 3 charts to show Magazine Subscription based on Location

Garden and Gun Magazine Income Low

Subscribe Income Location Subscribe Count of Subscribe

No Low Rural No 300
No Low Rural Yes 56
No Low Rural Grand Total 356
No Low Rural
No Low Rural
No Low Rural Magazine Subscription: Low In
No Low Rural
No Low Rural
No Low Rural
No Low Rural
No Low Rural
No Low Rural No
No Low Rural Grand Total 42%
No Low Rural 50%

No Low Rural
No Low Rural
No Low Rural
No Low Rural Yes
8%
No Low Rural
No Low Rural
No Low Rural
No Low Rural Income Middle
No Low Rural
No Low Rural Subscribe Count of Subscribe
No Low Rural No 276
No Low Rural Yes 15
No Low Rural Grand Total 291
No Low Rural
No Low Rural
No Low Rural Magazine Subscription: Mid
No Low Rural Income
No Low Rural
No Low Rural
No Low Rural
No Low Rural
No Low Rural
No Low Rural No
Grand Total 47%
50%
 No
Grand Total 47%
No Low Suburban 50%
No Low Suburban
No Low Suburban
No Low Suburban
No Low Suburban Yes
No Low Suburban 3%
No Low Suburban
No Low Suburban
No Low Suburban Income Upper
No Low Suburban
No Low Suburban Subscribe Count of Subscribe
No Low Suburban No 150
No Low Suburban Yes 75
No Low Suburban Grand Total 225
No Low Suburban
No Low Suburban
No Low Suburban Magazine Subscription: Upper
No Low Suburban
No Low Suburban
No Low Suburban
No Low Suburban
No Low Suburban No
33%
No Low Suburban
No Low Suburban Grand Total
50%
No Low Suburban
No Low Suburban
No Low Suburban
No Low Suburban Yes
No Low Suburban 17%
No Low Suburban
No Low Suburban
No Low Suburban
No Low Suburban
No Low Suburban
No Low Suburban
No Low Suburban
No Low Suburban
No Low Suburban
No Low Suburban
No Low Suburban
No Low Suburban
No Low Suburban
No Low Suburban
No Low Suburban
No Low Suburban
No Low Suburban
No Low Suburban
No Low Suburban
No Low Suburban
No Low Suburban
No Low Suburban
No Low Suburban
No Low Suburban
No Low Suburban
No Low Suburban
No Low Suburban
No Low Suburban
No Low Suburban
No Low Suburban
No Low Suburban
No Low Suburban
No Low Suburban
No Low Suburban
No Low Suburban
No Low Suburban
No Low Suburban
No Low Suburban
No Low Suburban
No Low Suburban
No Low Suburban
No Low Suburban
No Low Suburban
No Low Suburban
No Low Suburban
No Low Suburban
No Low Suburban
No Low Suburban
No Low Suburban
No Low Suburban
No Low Suburban
No Low Suburban
No Low Suburban
No Low Suburban
No Low Suburban
No Low Suburban
No Low Suburban
No Low Suburban
No Low Suburban
No Low Suburban
No Low Suburban
No Low Suburban
No Low Suburban
No Low Suburban
No Low Suburban
No Low Suburban
No Low Suburban
No Low Suburban
No Low Suburban
No Low Suburban
No Low Suburban
No Low Suburban
No Low Suburban
No Low Suburban
No Low Suburban
No Low Suburban
No Low Suburban
No Low Suburban
No Low Suburban
No Low Suburban
No Low Suburban
No Low Suburban
No Low Suburban
No Low Suburban
No Low Suburban
No Low Suburban
No Low Suburban
No Low Suburban
No Low Suburban
No Low Suburban
No Low Suburban
No Low Suburban
No Low Suburban
No Low Suburban
No Low Suburban
No Low Suburban
No Low Suburban
No Low Suburban
No Low Suburban
No Low Suburban
No Low Suburban
No Low Suburban
No Low Suburban
No Low Suburban
No Low Suburban
No Low Suburban
No Low Suburban
No Low Suburban
No Low Suburban
No Low Suburban
No Low Suburban
No Low Suburban
No Low Suburban
No Low Suburban
No Low Suburban
No Low Suburban
No Low Suburban
No Low Suburban
No Low Suburban
No Low Suburban
No Low Suburban
No Low Suburban
No Low Suburban
No Low Suburban
No Low Suburban
No Low Suburban
No Low Suburban
No Low Suburban
No Low Suburban
No Low Suburban
No Low Suburban
No Low Urban
No Low Urban
No Low Urban
No Low Urban
No Low Urban
No Low Urban
No Low Urban
No Low Urban
No Low Urban
No Low Urban
No Low Urban
No Low Urban
No Low Urban
No Low Urban
No Low Urban
No Low Urban
No Low Urban
No Low Urban
No Low Urban
No Low Urban
No Low Urban
No Low Urban
No Low Urban
No Low Urban
No Low Urban
No Low Urban
No Low Urban
No Low Urban
No Low Urban
No Low Urban
No Low Urban
No Low Urban
No Low Urban
No Low Urban
No Low Urban
No Low Urban
No Low Urban
No Low Urban
No Low Urban
No Low Urban
No Low Urban
No Low Urban
No Low Urban
No Low Urban
No Low Urban
No Low Urban
No Low Urban
No Low Urban
No Low Urban
No Low Urban
No Low Urban
No Low Urban
No Low Urban
No Low Urban
No Low Urban
No Low Urban
No Low Urban
No Low Urban
No Low Urban
No Low Urban
No Low Urban
No Low Urban
No Low Urban
No Low Urban
No Low Urban
No Low Urban
No Low Urban
No Low Urban
No Low Urban
No Low Urban
No Low Urban
No Low Urban
No Low Urban
No Low Urban
No Low Urban
No Low Urban
No Low Urban
No Low Urban
No Low Urban
No Low Urban
No Low Urban
No Low Urban
No Low Urban
No Low Urban
No Low Urban
No Low Urban
No Low Urban
No Low Urban
No Low Urban
No Low Urban
No Low Urban
No Low Urban
No Low Urban
No Low Urban
No Low Urban
No Low Urban
No Low Urban
No Low Urban
No Low Urban
No Low Urban
No Low Urban
No Low Urban
No Low Urban
No Middle Rural
No Middle Rural
No Middle Rural
No Middle Rural
No Middle Rural
No Middle Rural
No Middle Rural
No Middle Rural
No Middle Rural
No Middle Rural
No Middle Rural
No Middle Rural
No Middle Rural
No Middle Rural
No Middle Rural
No Middle Rural
No Middle Rural
No Middle Rural
No Middle Rural
No Middle Rural
No Middle Rural
No Middle Rural
No Middle Rural
No Middle Rural
No Middle Rural
No Middle Rural
No Middle Rural
No Middle Rural
No Middle Rural
No Middle Rural
No Middle Rural
No Middle Rural
No Middle Rural
No Middle Rural
No Middle Rural
No Middle Rural
No Middle Rural
No Middle Rural
No Middle Rural
No Middle Rural
No Middle Rural
No Middle Rural
No Middle Rural
No Middle Rural
No Middle Rural
No Middle Rural
No Middle Rural
No Middle Rural
No Middle Rural
No Middle Rural
No Middle Rural
No Middle Rural
No Middle Rural
No Middle Rural
No Middle Rural
No Middle Rural
No Middle Rural
No Middle Rural
No Middle Rural
No Middle Rural
No Middle Rural
No Middle Suburban
No Middle Suburban
No Middle Suburban
No Middle Suburban
No Middle Suburban
No Middle Suburban
No Middle Suburban
No Middle Suburban
No Middle Suburban
No Middle Suburban
No Middle Suburban
No Middle Suburban
No Middle Suburban
No Middle Suburban
No Middle Suburban
No Middle Suburban
No Middle Suburban
No Middle Suburban
No Middle Suburban
No Middle Suburban
No Middle Suburban
No Middle Suburban
No Middle Suburban
No Middle Suburban
No Middle Suburban
No Middle Suburban
No Middle Suburban
No Middle Suburban
No Middle Suburban
No Middle Suburban
No Middle Suburban
No Middle Suburban
No Middle Suburban
No Middle Suburban
No Middle Suburban
No Middle Suburban
No Middle Suburban
No Middle Suburban
No Middle Suburban
No Middle Suburban
No Middle Suburban
No Middle Suburban
No Middle Suburban
No Middle Suburban
No Middle Suburban
No Middle Suburban
No Middle Suburban
No Middle Suburban
No Middle Suburban
No Middle Suburban
No Middle Suburban
No Middle Suburban
No Middle Suburban
No Middle Suburban
No Middle Suburban
No Middle Suburban
No Middle Suburban
No Middle Suburban
No Middle Suburban
No Middle Suburban
No Middle Suburban
No Middle Suburban
No Middle Suburban
No Middle Suburban
No Middle Suburban
No Middle Suburban
No Middle Suburban
No Middle Suburban
No Middle Suburban
No Middle Suburban
No Middle Suburban
No Middle Suburban
No Middle Suburban
No Middle Suburban
No Middle Suburban
No Middle Suburban
No Middle Suburban
No Middle Suburban
No Middle Suburban
No Middle Suburban
No Middle Suburban
No Middle Suburban
No Middle Suburban
No Middle Suburban
No Middle Suburban
No Middle Suburban
No Middle Suburban
No Middle Suburban
No Middle Suburban
No Middle Suburban
No Middle Suburban
No Middle Suburban
No Middle Suburban
No Middle Suburban
No Middle Suburban
No Middle Suburban
No Middle Suburban
No Middle Suburban
No Middle Suburban
No Middle Suburban
No Middle Suburban
No Middle Suburban
No Middle Suburban
No Middle Suburban
No Middle Suburban
No Middle Suburban
No Middle Suburban
No Middle Suburban
No Middle Suburban
No Middle Suburban
No Middle Suburban
No Middle Suburban
No Middle Suburban
No Middle Suburban
No Middle Suburban
No Middle Suburban
No Middle Suburban
No Middle Suburban
No Middle Suburban
No Middle Suburban
No Middle Suburban
No Middle Suburban
No Middle Suburban
No Middle Suburban
No Middle Suburban
No Middle Urban
No Middle Urban
No Middle Urban
No Middle Urban
No Middle Urban
No Middle Urban
No Middle Urban
No Middle Urban
No Middle Urban
No Middle Urban
No Middle Urban
No Middle Urban
No Middle Urban
No Middle Urban
No Middle Urban
No Middle Urban
No Middle Urban
No Middle Urban
No Middle Urban
No Middle Urban
No Middle Urban
No Middle Urban
No Middle Urban
No Middle Urban
No Middle Urban
No Middle Urban
No Middle Urban
No Middle Urban
No Middle Urban
No Middle Urban
No Middle Urban
No Middle Urban
No Middle Urban
No Middle Urban
No Middle Urban
No Middle Urban
No Middle Urban
No Middle Urban
No Middle Urban
No Middle Urban
No Middle Urban
No Middle Urban
No Middle Urban
No Middle Urban
No Middle Urban
No Middle Urban
No Middle Urban
No Middle Urban
No Middle Urban
No Middle Urban
No Middle Urban
No Middle Urban
No Middle Urban
No Middle Urban
No Middle Urban
No Middle Urban
No Middle Urban
No Middle Urban
No Middle Urban
No Middle Urban
No Middle Urban
No Middle Urban
No Middle Urban
No Middle Urban
No Middle Urban
No Middle Urban
No Middle Urban
No Middle Urban
No Middle Urban
No Middle Urban
No Middle Urban
No Middle Urban
No Middle Urban
No Middle Urban
No Middle Urban
No Middle Urban
No Middle Urban
No Middle Urban
No Middle Urban
No Middle Urban
No Middle Urban
No Middle Urban
No Middle Urban
No Middle Urban
No Middle Urban
No Middle Urban
No Middle Urban
No Middle Urban
No Middle Urban
No Middle Urban
No Upper Rural
No Upper Rural
No Upper Rural
No Upper Rural
No Upper Rural
No Upper Rural
No Upper Rural
No Upper Rural
No Upper Rural
No Upper Rural
No Upper Rural
No Upper Rural
No Upper Rural
No Upper Rural
No Upper Rural
No Upper Rural
No Upper Rural
No Upper Rural
No Upper Rural
No Upper Rural
No Upper Rural
No Upper Rural
No Upper Rural
No Upper Rural
No Upper Rural
No Upper Rural
No Upper Rural
No Upper Suburban
No Upper Suburban
No Upper Suburban
No Upper Suburban
No Upper Suburban
No Upper Suburban
No Upper Suburban
No Upper Suburban
No Upper Suburban
No Upper Suburban
No Upper Suburban
No Upper Suburban
No Upper Suburban
No Upper Suburban
No Upper Suburban
No Upper Suburban
No Upper Suburban
No Upper Suburban
No Upper Suburban
No Upper Suburban
No Upper Suburban
No Upper Suburban
No Upper Suburban
No Upper Suburban
No Upper Suburban
No Upper Suburban
No Upper Suburban
No Upper Suburban
No Upper Suburban
No Upper Suburban
No Upper Suburban
No Upper Suburban
No Upper Suburban
No Upper Suburban
No Upper Suburban
No Upper Suburban
No Upper Suburban
No Upper Suburban
No Upper Suburban
No Upper Suburban
No Upper Suburban
No Upper Suburban
No Upper Suburban
No Upper Suburban
No Upper Suburban
No Upper Suburban
No Upper Suburban
No Upper Suburban
No Upper Suburban
No Upper Suburban
No Upper Suburban
No Upper Suburban
No Upper Suburban
No Upper Suburban
No Upper Urban
No Upper Urban
No Upper Urban
No Upper Urban
No Upper Urban
No Upper Urban
No Upper Urban
No Upper Urban
No Upper Urban
No Upper Urban
No Upper Urban
No Upper Urban
No Upper Urban
No Upper Urban
No Upper Urban
No Upper Urban
No Upper Urban
No Upper Urban
No Upper Urban
No Upper Urban
No Upper Urban
No Upper Urban
No Upper Urban
No Upper Urban
No Upper Urban
No Upper Urban
No Upper Urban
No Upper Urban
No Upper Urban
No Upper Urban
No Upper Urban
No Upper Urban
No Upper Urban
No Upper Urban
No Upper Urban
No Upper Urban
No Upper Urban
No Upper Urban
No Upper Urban
No Upper Urban
No Upper Urban
No Upper Urban
No Upper Urban
No Upper Urban
No Upper Urban
No Upper Urban
No Upper Urban
No Upper Urban
No Upper Urban
No Upper Urban
No Upper Urban
No Upper Urban
No Upper Urban
No Upper Urban
No Upper Urban
No Upper Urban
No Upper Urban
No Upper Urban
No Upper Urban
No Upper Urban
No Upper Urban
No Upper Urban
No Upper Urban
No Upper Urban
No Upper Urban
No Upper Urban
No Upper Urban
No Upper Urban
No Upper Urban
Yes Low Rural
Yes Low Rural
Yes Low Rural
Yes Low Rural
Yes Low Rural
Yes Low Rural
Yes Low Rural
Yes Low Rural
Yes Low Rural
Yes Low Rural
Yes Low Rural
Yes Low Rural
Yes Low Rural
Yes Low Rural
Yes Low Rural
Yes Low Rural
Yes Low Rural
Yes Low Rural
Yes Low Rural
Yes Low Rural
Yes Low Rural
Yes Low Rural
Yes Low Rural
Yes Low Rural
Yes Low Rural
Yes Low Rural
Yes Low Rural
Yes Low Rural
Yes Low Rural
Yes Low Rural
Yes Low Rural
Yes Low Rural
Yes Low Rural
Yes Low Rural
Yes Low Rural
Yes Low Rural
Yes Low Rural
Yes Low Rural
Yes Low Rural
Yes Low Rural
Yes Low Rural
Yes Low Rural
Yes Low Rural
Yes Low Rural
Yes Low Rural
Yes Low Rural
Yes Low Rural
Yes Low Rural
Yes Low Rural
Yes Low Suburban
Yes Low Suburban
Yes Low Urban
Yes Low Urban
Yes Low Urban
Yes Low Urban
Yes Low Urban
Yes Middle Rural
Yes Middle Rural
Yes Middle Rural
Yes Middle Suburban
Yes Middle Suburban
Yes Middle Suburban
Yes Middle Suburban
Yes Middle Suburban
Yes Middle Suburban
Yes Middle Suburban
Yes Middle Urban
Yes Middle Urban
Yes Middle Urban
Yes Middle Urban
Yes Middle Urban
Yes Upper Rural
Yes Upper Rural
Yes Upper Rural
Yes Upper Rural
Yes Upper Rural
Yes Upper Rural
Yes Upper Rural
Yes Upper Rural
Yes Upper Rural
Yes Upper Rural
Yes Upper Rural
Yes Upper Rural
Yes Upper Rural
Yes Upper Rural
Yes Upper Rural
Yes Upper Rural
Yes Upper Rural
Yes Upper Rural
Yes Upper Suburban
Yes Upper Suburban
Yes Upper Suburban
Yes Upper Suburban
Yes Upper Suburban
Yes Upper Suburban
Yes Upper Suburban
Yes Upper Suburban
Yes Upper Suburban
Yes Upper Suburban
Yes Upper Suburban
Yes Upper Suburban
Yes Upper Suburban
Yes Upper Suburban
Yes Upper Suburban
Yes Upper Suburban
Yes Upper Suburban
Yes Upper Suburban
Yes Upper Suburban
Yes Upper Suburban
Yes Upper Suburban
Yes Upper Suburban
Yes Upper Suburban
Yes Upper Suburban
Yes Upper Suburban
Yes Upper Suburban
Yes Upper Suburban
Yes Upper Suburban
Yes Upper Suburban
Yes Upper Suburban
Yes Upper Suburban
Yes Upper Suburban
Yes Upper Suburban
Yes Upper Suburban
Yes Upper Suburban
Yes Upper Suburban
Yes Upper Suburban
Yes Upper Suburban
Yes Upper Suburban
Yes Upper Suburban
Yes Upper Suburban
Yes Upper Suburban
Yes Upper Suburban
Yes Upper Suburban
Yes Upper Suburban
Yes Upper Suburban
Yes Upper Suburban
Yes Upper Suburban
Yes Upper Suburban
Yes Upper Suburban
Yes Upper Suburban
Yes Upper Suburban
Yes Upper Suburban
Yes Upper Suburban
Yes Upper Suburban
Yes Upper Suburban
Yes Upper Suburban
a sample of people that is representative of the US.

Location Rural

% Breakdown of Subscribe Subscribe Count of Subscribe

84% No 125
16% Yes 70
100% Grand Total 195

ne Subscription: Low Income Magazine Subscription

No
Grand Total 42% Grand Total
50% 50%

Ye
18
Yes
8%

Location Suburban

Subscribe Count of Subscribe

% Breakdown of Subscribe No 339
95% Yes 66
5% Grand Total 405
100%

Magazine Subscriptio
azine Subscription: Middle Area
Income

Grand Total
No 50%
Grand Total 47%
50%

Yes
8%
 Grand Total
No 50%
Grand Total 47%
50%

Yes
8%
Yes
3%

Location Urban

Subscribe Count of Subscribe

% Breakdown of Subscribe No 262
67% Yes 10
33% Grand Total 272
100%

e Subscription: Upper Income Magazine Subscription

No
33%
Grand Total
Grand Total 50%
50%

Yes Yes
17% 2%
 % Breakdown of Subscribe
64%
36%
100%

ne Subscription: Rural Area

No
32%

rand Total
50%

Yes
18%

% Breakdown of Subscribe
84%
16%
100%

ine Subscription: Suburban

Area

No
Grand Total 42%
50%

Yes
8%
 No
Grand Total 42%
50%

Yes
8%

% Breakdown of Subscribe
96%
4%
100%

ne Subscription: Urban Area

No
Grand Total 48%
50%

Yes
2%
 Many men and women were asked to rate the age of member of the opposite sex they
You are given each person's age, gender, and the age of a member of the opposite se
For example, person 1 is a 30 year old woman who finds 30 year old men most attrac
old man who finds 27 years old women most attractive.
Task
Construct a PivotTable to help you understand how men and women answer this qu

Then make 2 scatter plots checking the relationship between Age of Person and Age
Hint: Filter for Man only then copy paste the table somewhere else to create a scatter

Gender Age of Person

Woman 21
Woman 21
Woman 21
Woman 21
Woman 21
Woman 21
Woman 21
Woman 21
Woman 21
Woman 21
Woman 21
Woman 21
Woman 21
Man 21
Man 21
Man 21
Woman 21
Woman 21
Man 21
Woman 21
Woman 21
Woman 21
Woman 21
Woman 21
Man 21
Man 21
Man 21
Man 21
Woman 21
Woman 21
Woman 21
Man 21
Man 21
Woman 21
Man 21
Man 21
Man 21
Woman 21
 Man 21
Man 21
Man 21
Man 21
Man 21
Man 21
Man 21
Man 21
Man 21
Man 21
Man 21
Man 21
Woman 22
Woman 22
Woman 22
Woman 22
Woman 22
Woman 22
Woman 22
Woman 22
Man 22
Man 22
Woman 22
Man 22
Woman 22
Man 22
Man 22
Woman 22
Woman 22
Woman 22
Woman 22
Man 22
Man 22
Woman 22
Man 22
Woman 22
Man 22
Woman 22
Woman 22
Woman 22
Man 22
Man 22
Man 22
Woman 22
Woman 22
Woman 22
Man 22
Woman 22
Woman 22
Man 22
 Man 22
Woman 22
Man 22
Man 22
Man 22
Man 22
Man 22
Man 22
Man 22
Man 22
Woman 23
Woman 23
Woman 23
Woman 23
Man 23
Man 23
Man 23
Man 23
Woman 23
Woman 23
Woman 23
Man 23
Woman 23
Woman 23
Man 23
Man 23
Woman 23
Woman 23
Woman 23
Woman 23
Man 23
Man 23
Man 23
Woman 23
Man 23
Man 23
Man 23
Woman 23
Woman 23
Woman 23
Woman 23
Man 23
Man 23
Man 23
Man 23
Man 23
Man 23
Man 23
Man 23
Man 23
 Man 23
Man 24
Man 24
Woman 24
Man 24
Woman 24
Man 24
Man 24
Woman 24
Man 24
Woman 24
Man 24
Man 24
Man 24
Woman 24
Woman 24
Man 24
Man 24
Woman 24
Woman 24
Woman 24
Woman 24
Man 24
Woman 24
Woman 24
Woman 24
Man 24
Man 24
Woman 24
Woman 24
Man 24
Man 24
Man 24
Woman 24
Man 24
Woman 24
Man 24
Woman 24
Man 24
Woman 24
Woman 24
Man 24
Woman 24
Man 25
Man 25
Woman 25
Woman 25
Woman 25
Man 25
Woman 25
 Man 25
Woman 25
Woman 25
Woman 25
Woman 25
Woman 25
Man 25
Man 25
Man 25
Woman 25
Man 25
Woman 25
Woman 25
Woman 25
Man 25
Woman 25
Man 25
Man 25
Woman 25
Woman 25
Man 25
Man 25
Man 25
Woman 25
Man 25
Woman 25
Man 25
Man 25
Man 25
Woman 25
Woman 25
Man 25
Man 25
Woman 25
Man 25
Man 26
Man 26
Man 26
Woman 26
Woman 26
Woman 26
Man 26
Woman 26
Woman 26
Woman 26
Woman 26
Man 26
Woman 26
Man 26
Woman 26
Woman 26
Woman 26
Man 26
Man 26
Man 26
Woman 26
Woman 26
Man 26
Woman 26
Woman 26
Woman 26
Woman 26
Man 26
Woman 26
Woman 26
Man 26
Woman 26
Woman 26
Woman 26
Man 26
Woman 26
Woman 26
Man 27
Man 27
Man 27
Man 27
Man 27
Man 27
Man 27
Man 27
Man 27
Woman 27
Man 27
Man 27
Woman 27
Man 27
Woman 27
Man 27
Woman 27
Man 27
Woman 27
Woman 27
Woman 27
Woman 27
Woman 27
Woman 27
Woman 27
Woman 27
Woman 27
Woman 27
Woman 27
Man 27
Woman 27
Man 27
Woman 27
Woman 27
Woman 27
Woman 27
Woman 27
Woman 27
Woman 27
Woman 27
Woman 27
Man 28
Man 28
Man 28
Man 28
Man 28
Man 28
Man 28
Man 28
Woman 28
Man 28
Man 28
Woman 28
Man 28
Woman 28
Man 28
Man 28
Woman 28
Woman 28
Woman 28
Woman 28
Man 28
Woman 28
Man 28
Woman 28
Man 28
Man 28
Woman 28
Man 28
Woman 28
Woman 28
Woman 28
Woman 28
Woman 28
Woman 28
Woman 28
Woman 28
Woman 28
Woman 28
Man 29
Man 29
Man 29
Man 29
Man 29
Man 29
Man 29
Man 29
Man 29
Man 29
Woman 29
Woman 29
Man 29
Man 29
Man 29
Woman 29
Woman 29
Man 29
Woman 29
Woman 29
Woman 29
Man 29
Woman 29
Woman 29
Woman 29
Woman 29
Woman 29
Woman 29
Woman 29
Woman 29
Woman 29
Woman 29
Woman 29
Woman 29
Man 30
Man 30
Man 30
Man 30
Man 30
Man 30
Man 30
Man 30
Man 30
Man 30
Man 30
Man 30
Man 30
Man 30
Man 30
 Man 30
Man 30
Man 30
Man 30
Woman 30
Man 30
Man 30
Woman 30
Woman 30
Man 30
Man 30
Woman 30
Man 30
Woman 30
Woman 30
Woman 30
Woman 30
Woman 30
Woman 30
Woman 30
Woman 30
Woman 30
Woman 30
Woman 30
Woman 30
Woman 30
Woman 30
Woman 30
Woman 30
Woman 30
Man 31
Man 31
Man 31
Man 31
Man 31
Man 31
Man 31
Man 31
Man 31
Man 31
Man 31
Man 31
Man 31
Man 31
Man 31
Man 31
Man 31
Man 31
Man 31
Man 31
 Man 31
Woman 31
Woman 31
Woman 31
Woman 31
Woman 31
Woman 31
Woman 31
Woman 31
Woman 31
Woman 31
Woman 31
Woman 31
Woman 31
Woman 31
Woman 31
Woman 31
Woman 31
Woman 31
Woman 31
Woman 31
Woman 31
Woman 31
Woman 31
Man 32
Man 32
Man 32
Man 32
Man 32
Man 32
Man 32
Man 32
Man 32
Man 32
Man 32
Man 32
Man 32
Man 32
Man 32
Man 32
Man 32
Man 32
Man 32
Man 32
Man 32
Man 32
Man 32
Man 32
Woman 32
Woman 32
Woman 32
Woman 32
Woman 32
Woman 32
Woman 32
Woman 32
Woman 32
Woman 32
Woman 32
Man 33
Man 33
Man 33
Man 33
Man 33
Man 33
Man 33
Man 33
Man 33
Man 33
Man 33
Man 33
Man 33
Man 33
Man 33
Man 33
Man 33
Man 33
Man 33
Man 33
Woman 33
Woman 33
Woman 33
Woman 33
Woman 33
Woman 33
Woman 33
Woman 33
Woman 33
Woman 33
Woman 33
Woman 33
Woman 33
Woman 33
Woman 33
Woman 33
Woman 33
Woman 33
Woman 33
Woman 33
Woman 33
Woman 33
Woman 33
Woman 33
Man 34
Man 34
Man 34
Man 34
Man 34
Man 34
Man 34
Man 34
Man 34
Man 34
Man 34
Man 34
Man 34
Man 34
Man 34
Man 34
Man 34
Man 34
Man 34
Man 34
Man 34
Woman 34
Woman 34
Woman 34
Woman 34
Woman 34
Woman 34
Woman 34
Woman 34
Woman 34
Woman 34
Woman 34
Woman 34
Woman 34
Woman 34
Woman 34
Woman 34
Woman 34
Woman 34
Woman 34
Woman 34
Woman 34
Man 35
Man 35
Man 35
Man 35
Man 35
 Man 35
Man 35
Man 35
Man 35
Man 35
Man 35
Man 35
Man 35
Man 35
Man 35
Woman 35
Woman 35
Woman 35
Woman 35
Woman 35
Woman 35
Woman 35
Woman 35
Woman 35
Woman 35
Woman 35
Woman 35
Woman 35
Woman 35
Woman 35
Woman 35
Woman 35
Woman 35
Woman 35
Woman 35
Woman 35
Woman 35
Woman 35
Woman 35
Man 36
Man 36
Man 36
Man 36
Man 36
Man 36
Man 36
Man 36
Man 36
Man 36
Man 36
Man 36
Man 36
Man 36
Man 36
Man 36
 Man 36
Man 36
Woman 36
Woman 36
Woman 36
Woman 36
Woman 36
Woman 36
Woman 36
Woman 36
Woman 36
Woman 36
Woman 36
Woman 36
Woman 36
Woman 36
Woman 36
Woman 36
Man 37
Man 37
Man 37
Man 37
Man 37
Man 37
Man 37
Man 37
Man 37
Man 37
Man 37
Man 37
Man 37
Man 37
Man 37
Woman 37
Woman 37
Woman 37
Woman 37
Woman 37
Woman 37
Woman 37
Woman 37
Woman 37
Woman 37
Woman 37
Woman 37
Woman 37
Woman 37
Woman 37
Woman 37
Woman 37
Woman 37
Woman 37
Woman 37
Woman 37
Woman 37
Man 38
Man 38
Man 38
Man 38
Man 38
Man 38
Man 38
Man 38
Man 38
Man 38
Man 38
Man 38
Man 38
Man 38
Man 38
Man 38
Man 38
Man 38
Man 38
Man 38
Man 38
Man 38
Man 38
Man 38
Man 38
Man 38
Woman 38
Woman 38
Woman 38
Woman 38
Woman 38
Woman 38
Woman 38
Woman 38
Woman 38
Woman 38
Woman 38
Woman 38
Woman 38
Woman 38
Woman 38
Woman 38
Woman 38
Woman 38
Woman 38
Woman 38
Woman 38
Woman 38
Woman 38
Woman 38
Man 39
Man 39
Man 39
Man 39
Man 39
Man 39
Man 39
Man 39
Man 39
Man 39
Man 39
Man 39
Man 39
Man 39
Man 39
Man 39
Man 39
Man 39
Man 39
Man 39
Man 39
Man 39
Man 39
Man 39
Woman 39
Woman 39
Woman 39
Woman 39
Woman 39
Woman 39
Woman 39
Woman 39
Woman 39
Woman 39
Woman 39
Woman 39
Woman 39
Woman 39
Woman 39
Woman 39
Woman 39
Woman 39
Woman 39
Woman 39
Woman 39
Woman 39
Woman 39
Woman 39
Woman 39
Woman 39
Woman 39
Woman 39
Man 40
Man 40
Man 40
Man 40
Man 40
Man 40
Man 40
Man 40
Man 40
Man 40
Man 40
Man 40
Man 40
Man 40
Man 40
Man 40
Man 40
Man 40
Man 40
Man 40
Man 40
Man 40
Man 40
Man 40
Man 40
Man 40
Man 40
Man 40
Man 40
Man 40
Man 40
Man 40
Woman 40
Woman 40
Woman 40
Woman 40
Woman 40
Woman 40
Woman 40
Woman 40
Woman 40
Woman 40
Woman 40
Woman 40
Woman 40
Woman 40
Woman 40
Woman 40
Woman 40
Woman 40
Woman 40
Woman 40
Man 41
Man 41
Man 41
Man 41
Man 41
Man 41
Man 41
Man 41
Man 41
Man 41
Man 41
Woman 41
Woman 41
Woman 41
Woman 41
Woman 41
Woman 41
Woman 41
Woman 41
Woman 41
Woman 41
Woman 41
Woman 41
Woman 41
Woman 41
Woman 41
Woman 41
Woman 41
Woman 41
Woman 41
Woman 41
Woman 41
Woman 41
Woman 41
Woman 41
Man 42
Man 42
Man 42
Man 42
Man 42
Man 42
 Man 42
Man 42
Man 42
Man 42
Man 42
Man 42
Man 42
Man 42
Man 42
Man 42
Man 42
Man 42
Man 42
Man 42
Man 42
Man 42
Man 42
Man 42
Woman 42
Woman 42
Woman 42
Woman 42
Woman 42
Woman 42
Woman 42
Woman 42
Woman 42
Woman 42
Woman 42
Woman 42
Woman 42
Woman 42
Woman 42
Woman 42
Woman 42
Woman 42
Woman 42
Woman 42
Woman 42
Woman 42
Man 43
Man 43
Man 43
Man 43
Man 43
Man 43
Man 43
Man 43
Man 43
Man 43
 Man 43
Man 43
Man 43
Man 43
Man 43
Man 43
Man 43
Man 43
Man 43
Man 43
Man 43
Woman 43
Woman 43
Woman 43
Woman 43
Woman 43
Woman 43
Woman 43
Woman 43
Woman 43
Woman 43
Woman 43
Woman 43
Woman 43
Woman 43
Woman 43
Woman 43
Woman 43
Woman 43
Woman 43
Woman 43
Woman 43
Woman 43
Woman 43
Woman 43
Man 44
Man 44
Man 44
Man 44
Man 44
Man 44
Man 44
Man 44
Man 44
Man 44
Man 44
Man 44
Man 44
Man 44
Man 44
 Man 44
Man 44
Woman 44
Woman 44
Woman 44
Woman 44
Woman 44
Woman 44
Woman 44
Woman 44
Woman 44
Woman 44
Woman 44
Woman 44
Woman 44
Woman 44
Woman 44
Woman 44
Woman 44
Woman 44
Woman 44
Woman 44
Woman 44
Man 45
Man 45
Man 45
Man 45
Man 45
Man 45
Man 45
Man 45
Man 45
Man 45
Man 45
Man 45
Man 45
Man 45
Man 45
Man 45
Man 45
Man 45
Man 45
Man 45
Man 45
Man 45
Man 45
Man 45
Man 45
Woman 45
Woman 45
Woman 45
Woman 45
Woman 45
Woman 45
Woman 45
Woman 45
Woman 45
Woman 45
Woman 45
Woman 45
Woman 45
Woman 45
Woman 45
Woman 45
Woman 45
Woman 45
Woman 45
Woman 45
Woman 45
Woman 45
Woman 45
Woman 45
Woman 45
Woman 45
Man 46
Man 46
Man 46
Man 46
Man 46
Man 46
Man 46
Man 46
Man 46
Man 46
Man 46
Man 46
Man 46
Man 46
Man 46
Man 46
Man 46
Man 46
Man 46
Man 46
Woman 46
Woman 46
Woman 46
Woman 46
Woman 46
Woman 46
Woman 46
Woman 46
Woman 46
Woman 46
Woman 46
Woman 46
Woman 46
Woman 46
Woman 46
Woman 46
Woman 46
Woman 46
Woman 46
Woman 46
Woman 46
Woman 46
Woman 46
Woman 46
Woman 46
Woman 46
Man 47
Man 47
Man 47
Man 47
Man 47
Man 47
Man 47
Man 47
Man 47
Man 47
Man 47
Man 47
Man 47
Man 47
Man 47
Man 47
Man 47
Man 47
Woman 47
Woman 47
Woman 47
Woman 47
Woman 47
Woman 47
Woman 47
Woman 47
Woman 47
Woman 47
Woman 47
Woman 47
Woman 47
Woman 47
Woman 47
Woman 47
Woman 47
Man 48
Man 48
Man 48
Man 48
Man 48
Man 48
Man 48
Man 48
Man 48
Man 48
Man 48
Man 48
Man 48
Man 48
Man 48
Man 48
Man 48
Man 48
Man 48
Woman 48
Woman 48
Woman 48
Woman 48
Woman 48
Woman 48
Woman 48
Woman 48
Woman 48
Woman 48
Woman 48
Woman 48
Woman 48
Woman 48
Woman 48
Woman 48
Man 49
Man 49
Man 49
Man 49
Man 49
Man 49
Man 49
Man 49
Man 49
Man 49
 Man 49
Man 49
Man 49
Man 49
Man 49
Man 49
Man 49
Man 49
Man 49
Man 49
Man 49
Woman 49
Woman 49
Woman 49
Woman 49
Woman 49
Woman 49
Woman 49
Woman 49
Woman 49
Woman 49
Woman 49
Woman 49
Woman 49
Woman 49
Woman 49
Woman 49
Woman 49
Man 50
Man 50
Man 50
Man 50
Man 50
Man 50
Man 50
Man 50
Man 50
Man 50
Man 50
Man 50
Man 50
Man 50
Man 50
Man 50
Man 50
Man 50
Man 50
Man 50
Man 50
Man 50
 Man 50
Woman 50
Woman 50
Woman 50
Woman 50
Woman 50
Woman 50
Woman 50
Woman 50
Woman 50
Woman 50
Woman 50
Woman 50
Woman 50
Woman 50
Woman 50
women were asked to rate the age of member of the opposite sex they find the most attractive.
ach person's age, gender, and the age of a member of the opposite sex they find most attractive.
rson 1 is a 30 year old woman who finds 30 year old men most attractive and a person 2 is a 42 year
ds 27 years old women most attractive.

tTable to help you understand how men and women answer this question differently. Hint: Group by age

atter plots checking the relationship between Age of Person and Age of Opposite Sex They Find Most Attractive.
an only then copy paste the table somewhere else to create a scatter plot only for Man. Repeat the same for Woman.

Age of Opp Sex they find most attractive

18
18 Count of Gender
19 Age of Person Gender
20 21-30 Man
20 21-30 Woman
20 21-30 Total
20 31-40 Man
20 31-40 Woman
20 31-40 Total
20 41-50 Man
20 41-50 Woman
20 41-50 Total
20 Man Count
21 Woman Cou
21 Grand Total
21
21
21
21
21
22
22
22
22
22
22
23
23
23
23
23
24
24
24
24
24
24
24
25
25
25
26
26
26
26
27
27
27
28
28
19
19
19
20
20
20
20
21
21
21
21
21
21
21
21
21
21
21
21
22
22
22
22
22
23
23
23
23
24
24
24
24
24
24
24
24
25
25
25
25
25
25
26
26
27
27
27
28
20
20
20
21
21
21
21
22
22
22
22
23
23
24
24
24
24
24
24
25
25
25
26
26
26
26
26
26
26
26
26
26
27
27
27
27
28
28
28
28
28
21
21
21
21
21
21
22
22
22
22
22
22
23
23
23
23
23
23
24
24
24
24
25
25
25
25
25
26
26
26
26
26
26
26
26
26
27
27
27
27
27
27
21
21
22
22
22
22
22
22
23
23
23
23
23
23
23
23
23
23
23
24
24
25
25
25
25
25
25
25
25
25
27
27
27
27
27
27
27
28
28
28
28
28
21
21
22
23
23
23
23
23
23
23
23
24
24
24
24
25
25
25
25
25
26
27
27
27
27
27
27
27
28
28
28
28
28
28
28
28
28
21
21
22
22
22
22
23
24
24
24
24
24
24
25
25
25
25
25
26
26
26
27
27
27
27
27
28
28
28
28
28
28
29
29
29
29
29
30
30
30
30
21
22
22
23
23
24
25
25
25
25
25
25
26
26
26
26
26
26
26
26
27
27
27
27
28
28
28
28
29
29
29
30
31
31
31
31
31
31
21
22
23
24
24
24
25
26
26
26
26
26
26
26
26
27
27
27
27
28
28
28
29
29
29
29
30
30
30
30
32
32
32
32
21
21
21
22
23
23
23
24
24
25
25
25
26
26
26
27
27
27
27
27
27
27
28
28
28
28
28
28
29
29
29
30
30
30
30
30
30
31
31
32
32
32
32
32
33
21
21
22
22
22
22
22
23
23
24
24
24
25
25
26
26
26
26
26
27
27
28
28
28
29
29
30
30
30
30
31
31
31
31
31
32
32
32
32
33
33
34
34
34
21
22
22
22
23
23
23
23
24
24
24
25
25
25
26
26
26
26
26
27
28
28
28
28
29
29
31
32
32
33
33
34
35
35
35
21
21
22
22
23
23
23
23
24
24
24
24
24
25
26
26
26
26
27
28
30
30
30
30
30
31
31
31
31
31
32
32
32
33
33
34
35
35
35
35
36
36
36
36
21
21
21
21
22
22
22
24
25
26
26
26
26
26
26
27
27
27
28
28
28
31
32
32
32
32
32
32
32
33
33
33
34
34
34
34
35
35
36
36
37
37
21
22
22
23
23
24
25
25
25
25
26
27
27
28
28
32
32
32
32
32
32
32
32
32
33
33
33
34
35
35
36
36
36
37
37
38
38
38
38
21
21
21
21
22
23
24
24
25
26
26
27
27
27
27
28
28
28
33
34
34
34
35
35
36
36
36
36
36
37
37
38
38
39
21
21
22
22
22
23
23
24
25
25
25
26
26
27
28
34
34
34
35
35
36
36
36
37
37
37
37
37
38
38
38
38
39
39
39
40
40
21
21
21
21
22
22
23
23
24
24
24
25
25
25
25
26
26
26
27
27
27
27
28
28
28
28
35
35
36
36
37
37
37
37
38
38
38
39
39
39
39
40
40
40
40
40
41
41
41
41
21
21
21
21
21
21
22
22
22
23
23
23
24
25
25
26
26
26
26
27
27
28
28
28
36
36
36
37
37
37
37
38
38
38
39
39
39
40
40
40
41
41
41
41
41
41
41
42
42
42
42
42
21
21
21
21
22
22
22
23
23
23
23
23
24
24
24
24
25
25
25
25
26
26
26
26
27
27
27
27
27
27
28
28
37
37
37
37
38
38
39
39
39
39
39
40
40
40
41
42
43
43
43
43
21
22
23
24
24
25
26
26
27
27
28
38
38
38
39
39
40
40
41
41
42
42
42
43
43
43
43
43
43
44
44
44
44
44
44
21
21
21
21
22
22
22
24
24
24
24
25
25
25
26
26
26
27
27
27
27
28
28
28
39
39
39
39
40
40
40
41
42
42
42
43
43
44
44
44
44
44
45
45
45
45
21
21
21
22
22
22
22
22
24
24
24
25
25
25
25
26
26
26
26
26
27
40
40
40
40
41
41
41
41
41
42
42
42
42
42
42
43
43
43
43
43
44
45
46
46
21
21
23
24
24
24
25
25
25
25
26
26
26
27
27
27
28
41
41
41
41
42
43
43
44
44
44
44
44
45
45
46
46
46
46
47
47
47
21
21
21
22
22
23
23
24
24
24
25
25
25
25
26
26
26
27
27
27
27
28
28
28
28
42
42
42
42
42
42
43
43
43
43
44
44
44
45
46
46
46
46
47
47
47
48
48
48
48
48
21
21
21
22
22
22
22
24
24
24
24
24
25
26
26
28
28
28
28
28
43
43
43
44
44
44
45
45
45
46
46
47
47
47
47
48
48
48
48
48
48
48
48
49
49
49
21
21
21
21
22
22
23
23
24
24
25
25
26
26
26
27
27
28
44
44
44
45
45
46
47
47
47
48
48
48
49
49
49
49
50
21
21
21
22
22
23
23
23
24
25
26
26
26
26
26
27
27
27
28
45
45
46
46
46
46
47
47
47
48
49
50
51
51
51
51
21
22
22
22
23
23
23
24
24
25
25
26
26
26
26
27
27
27
27
28
28
46
46
46
46
46
46
47
48
48
48
49
49
50
51
51
52
52
21
21
22
22
22
22
22
22
23
24
24
24
24
25
26
26
26
27
27
27
27
28
28
47
48
48
49
50
51
51
51
52
52
52
52
52
52
53
roup by age

Most Attractive.
he same for Woman.

Age of Opp Sex they find most attractive

18-27 28-37 38-47 48-57 Grand Total
89% 11% 0% 0% 100%
69% 31% 0% 0% 100%
79% 21% 0% 0% 100%
89% 11% 0% 0% 100%
0% 68% 32% 0% 100%
45% 39% 16% 0% 100%
90% 10% 0% 0% 100%
0% 0% 74% 26% 100%
44% 5% 38% 14% 100%
89% 11% 0% 0% 100%
24% 33% 35% 9% 100%
56% 22% 18% 4% 100%
Gender Age of Person
Man 21
Man 21
Man 21
Man 21
Man 21
Man 21
Man 21
Man 21
Man 21
Man 21
Man 21
Man 21
Man 21
Man 21
Man 21
Man 21
Man 21
Man 21
Man 21
Man 21
Man 21
Man 21
Man 21
Man 21
Man 21
Man 22
Man 22
Man 22
Man 22
Man 22
Man 22
Man 22
Man 22
Man 22
Man 22
Man 22
Man 22
Man 22
Man 22
Man 22
Man 22
Man 22
Man 22
Man 22
Man 22
Man 22
Man 22
Man 22
Man 23
Man 23
Man 23
Man 23
Man 23
Man 23
Man 23
Man 23
Man 23
Man 23
Man 23
Man 23
Man 23
Man 23
Man 23
Man 23
Man 23
Man 23
Man 23
Man 23
Man 23
Man 23
Man 23
Man 24
Man 24
Man 24
Man 24
Man 24
Man 24
Man 24
Man 24
Man 24
Man 24
Man 24
Man 24
Man 24
Man 24
Man 24
Man 24
Man 24
Man 24
Man 24
Man 24
Man 24
Man 25
Man 25
Man 25
Man 25
Man 25
Man 25
Man 25
Man 25
Man 25
Man 25
Man 25
Man 25
Man 25
Man 25
Man 25
Man 25
Man 25
Man 25
Man 25
Man 25
Man 25
Man 26
Man 26
Man 26
Man 26
Man 26
Man 26
Man 26
Man 26
Man 26
Man 26
Man 26
Man 26
Man 26
Man 27
Man 27
Man 27
Man 27
Man 27
Man 27
Man 27
Man 27
Man 27
Man 27
Man 27
Man 27
Man 27
Man 27
Man 27
Man 27
Man 28
Man 28
Man 28
Man 28
Man 28
Man 28
Man 28
Man 28
Man 28
Man 28
Man 28
Man 28
Man 28
Man 28
Man 28
Man 28
Man 28
Man 28
Man 29
Man 29
Man 29
Man 29
Man 29
Man 29
Man 29
Man 29
Man 29
Man 29
Man 29
Man 29
Man 29
Man 29
Man 29
Man 30
Man 30
Man 30
Man 30
Man 30
Man 30
Man 30
Man 30
Man 30
Man 30
Man 30
Man 30
Man 30
Man 30
Man 30
Man 30
Man 30
Man 30
Man 30
Man 30
Man 30
Man 30
Man 30
Man 30
Man 31
Man 31
Man 31
Man 31
Man 31
Man 31
Man 31
Man 31
Man 31
Man 31
Man 31
Man 31
Man 31
Man 31
Man 31
Man 31
Man 31
Man 31
Man 31
Man 31
Man 31
Man 32
Man 32
Man 32
Man 32
Man 32
Man 32
Man 32
Man 32
Man 32
Man 32
Man 32
Man 32
Man 32
Man 32
Man 32
Man 32
Man 32
Man 32
Man 32
Man 32
Man 32
Man 32
Man 32
Man 32
Man 33
Man 33
Man 33
Man 33
Man 33
Man 33
Man 33
Man 33
Man 33
Man 33
Man 33
Man 33
Man 33
Man 33
Man 33
Man 33
Man 33
Man 33
Man 33
Man 33
Man 34
Man 34
Man 34
Man 34
Man 34
Man 34
Man 34
Man 34
Man 34
Man 34
Man 34
Man 34
Man 34
Man 34
Man 34
Man 34
Man 34
Man 34
Man 34
Man 34
Man 34
Man 35
Man 35
Man 35
Man 35
Man 35
Man 35
Man 35
Man 35
Man 35
Man 35
Man 35
Man 35
Man 35
Man 35
Man 35
Man 36
Man 36
Man 36
Man 36
Man 36
Man 36
Man 36
Man 36
Man 36
Man 36
Man 36
Man 36
Man 36
Man 36
Man 36
Man 36
Man 36
Man 36
Man 37
Man 37
Man 37
Man 37
Man 37
Man 37
Man 37
Man 37
Man 37
Man 37
Man 37
Man 37
Man 37
Man 37
Man 37
Man 38
Man 38
Man 38
Man 38
Man 38
Man 38
Man 38
Man 38
Man 38
Man 38
Man 38
Man 38
Man 38
Man 38
Man 38
Man 38
Man 38
Man 38
Man 38
Man 38
Man 38
Man 38
Man 38
Man 38
Man 38
Man 38
Man 39
Man 39
Man 39
Man 39
Man 39
Man 39
Man 39
Man 39
Man 39
Man 39
Man 39
Man 39
Man 39
Man 39
Man 39
Man 39
Man 39
Man 39
Man 39
Man 39
Man 39
Man 39
Man 39
Man 39
Man 40
Man 40
Man 40
Man 40
Man 40
Man 40
Man 40
Man 40
Man 40
Man 40
Man 40
Man 40
Man 40
Man 40
Man 40
Man 40
Man 40
Man 40
Man 40
Man 40
Man 40
Man 40
Man 40
Man 40
Man 40
Man 40
Man 40
Man 40
Man 40
Man 40
Man 40
Man 40
Man 41
Man 41
Man 41
Man 41
Man 41
Man 41
Man 41
Man 41
Man 41
Man 41
Man 41
Man 42
Man 42
Man 42
Man 42
Man 42
Man 42
Man 42
Man 42
Man 42
Man 42
Man 42
Man 42
Man 42
Man 42
Man 42
Man 42
Man 42
Man 42
Man 42
Man 42
Man 42
Man 42
Man 42
Man 42
Man 43
Man 43
Man 43
Man 43
Man 43
Man 43
Man 43
Man 43
Man 43
Man 43
Man 43
Man 43
Man 43
Man 43
Man 43
Man 43
Man 43
Man 43
Man 43
Man 43
Man 43
Man 44
Man 44
Man 44
Man 44
Man 44
Man 44
Man 44
Man 44
Man 44
Man 44
Man 44
Man 44
Man 44
Man 44
Man 44
Man 44
Man 44
Man 45
Man 45
Man 45
Man 45
Man 45
Man 45
Man 45
Man 45
Man 45
Man 45
Man 45
Man 45
Man 45
Man 45
Man 45
Man 45
Man 45
Man 45
Man 45
Man 45
Man 45
Man 45
Man 45
Man 45
Man 45
Man 46
Man 46
Man 46
Man 46
Man 46
Man 46
Man 46
Man 46
Man 46
Man 46
Man 46
Man 46
Man 46
Man 46
Man 46
Man 46
Man 46
Man 46
Man 46
Man 46
Man 47
Man 47
Man 47
Man 47
Man 47
Man 47
Man 47
Man 47
Man 47
Man 47
Man 47
Man 47
Man 47
Man 47
Man 47
Man 47
Man 47
Man 47
Man 48
Man 48
Man 48
Man 48
Man 48
Man 48
Man 48
Man 48
Man 48
Man 48
Man 48
Man 48
Man 48
Man 48
Man 48
Man 48
Man 48
Man 48
Man 48
Man 49
Man 49
Man 49
Man 49
Man 49
Man 49
Man 49
Man 49
Man 49
Man 49
Man 49
Man 49
Man 49
Man 49
Man 49
Man 49
Man 49
Man 49
Man 49
Man 49
Man 49
Man 50
Man 50
Man 50
Man 50
Man 50
Man 50
Man 50
Man 50
Man 50
Man 50
Man 50
Man 50
Man 50
Man 50
Man 50
Man 50
Man 50
Man 50
Man 50
Man 50
Man 50
Man 50
Man 50
Age of Opp Sex they find most attractive
21
Age of Male vs. Age of Female They Fin
21

Age of Female They Found Attractive

21 30
21 25
22
22 20
23 15
23
24 10
24
5
24
24 0
15 20 25 30 35 40
24
25 Age of Male
25
25
26
26
26
26
27
27
27
28
28
21
21
21
21
21
22
22
22
23
24
24
24
24
25
25
25
25
26
26
27
27
27
28
21
21
21
22
23
24
24
25
25
26
26
26
26
26
27
27
27
27
28
28
28
28
28
21
21
21
21
22
22
22
22
23
23
23
24
25
25
26
26
26
26
26
27
27
21
21
22
22
23
23
23
23
25
25
25
25
25
25
27
27
27
27
28
28
28
21
21
22
23
24
24
25
25
25
27
27
28
28
21
21
22
22
22
22
23
24
24
24
24
25
25
25
28
28
21
22
22
23
23
24
25
25
25
25
26
26
26
27
27
28
28
28
21
22
23
24
24
24
25
26
26
26
26
26
26
27
28
21
21
21
22
23
23
23
24
24
25
25
25
26
26
26
27
27
27
27
27
27
28
28
28
21
21
22
22
22
22
22
23
23
24
24
24
25
25
26
26
26
26
26
27
27
21
22
22
22
23
23
23
23
24
24
24
25
25
25
26
26
26
26
26
27
28
28
28
28
21
21
22
22
23
23
23
23
24
24
24
24
24
25
26
26
26
26
27
28
21
21
21
21
22
22
22
24
25
26
26
26
26
26
26
27
27
27
28
28
28
21
22
22
23
23
24
25
25
25
25
26
27
27
28
28
21
21
21
21
22
23
24
24
25
26
26
27
27
27
27
28
28
28
21
21
22
22
22
23
23
24
25
25
25
26
26
27
28
21
21
21
21
22
22
23
23
24
24
24
25
25
25
25
26
26
26
27
27
27
27
28
28
28
28
21
21
21
21
21
21
22
22
22
23
23
23
24
25
25
26
26
26
26
27
27
28
28
28
21
21
21
21
22
22
22
23
23
23
23
23
24
24
24
24
25
25
25
25
26
26
26
26
27
27
27
27
27
27
28
28
21
22
23
24
24
25
26
26
27
27
28
21
21
21
21
22
22
22
24
24
24
24
25
25
25
26
26
26
27
27
27
27
28
28
28
21
21
21
22
22
22
22
22
24
24
24
25
25
25
25
26
26
26
26
26
27
21
21
23
24
24
24
25
25
25
25
26
26
26
27
27
27
28
21
21
21
22
22
23
23
24
24
24
25
25
25
25
26
26
26
27
27
27
27
28
28
28
28
21
21
21
22
22
22
22
24
24
24
24
24
25
26
26
28
28
28
28
28
21
21
21
21
22
22
23
23
24
24
25
25
26
26
26
27
27
28
21
21
21
22
22
23
23
23
24
25
26
26
26
26
26
27
27
27
28
21
22
22
22
23
23
23
24
24
25
25
26
26
26
26
27
27
27
27
28
28
21
21
22
22
22
22
22
22
23
24
24
24
24
25
26
26
26
27
27
27
27
28
28
 Gender
Woman
e of Female They Find Attractive
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
30 35 40 45 50 55
Woman
Age of Male Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Woman
Age of Person Age of Opp Sex they find most attractive
Age of Female v
21 18
21 18
21 19 60

Age of Male They Find Attractive

21 20 50
21 20
40
21 20
21 20 30
21 20 20
21 20
10
21 20
21 20 0
15 20 25
21 20
21 20
21 21
21 21
21 21
21 22
21 22
21 22
21 22
21 23
21 23
21 23
21 24
21 24
22 19
22 19
22 19
22 20
22 20
22 20
22 20
22 21
22 21
22 21
22 21
22 21
22 21
22 21
22 22
22 22
22 23
22 23
22 23
22 24
22 24
22 24
22 24
22 25
22 25
23 20
23 20
23 20
23 21
23 22
23 22
23 22
23 23
23 24
23 24
23 24
23 24
23 25
23 26
23 26
23 26
23 26
23 26
24 21
24 21
24 22
24 22
24 23
24 23
24 23
24 24
24 24
24 24
24 25
24 25
24 25
24 26
24 26
24 26
24 26
24 27
24 27
24 27
24 27
25 22
25 22
25 22
25 22
25 23
25 23
25 23
25 23
25 23
25 23
25 23
25 24
25 24
25 25
25 25
25 25
25 27
25 27
25 27
25 28
25 28
26 23
26 23
26 23
26 23
26 23
26 23
26 23
26 24
26 24
26 25
26 25
26 26
26 27
26 27
26 27
26 27
26 27
26 28
26 28
26 28
26 28
26 28
26 28
26 28
27 24
27 24
27 25
27 25
27 26
27 26
27 26
27 27
27 27
27 27
27 27
27 27
27 28
27 28
27 28
27 28
27 29
27 29
27 29
27 29
27 29
27 30
27 30
27 30
27 30
28 25
28 25
28 26
28 26
28 26
28 26
28 26
28 27
28 27
28 28
28 29
28 29
28 29
28 30
28 31
28 31
28 31
28 31
28 31
28 31
29 26
29 26
29 27
29 27
29 27
29 28
29 28
29 29
29 29
29 29
29 29
29 30
29 30
29 30
29 30
29 32
29 32
29 32
29 32
30 27
30 28
30 28
30 28
30 29
30 29
30 29
30 30
30 30
30 30
30 30
30 30
30 30
30 31
30 31
30 32
30 32
30 32
30 32
30 32
30 33
31 28
31 28
31 28
31 29
31 29
31 30
31 30
31 30
31 30
31 31
31 31
31 31
31 31
31 31
31 32
31 32
31 32
31 32
31 33
31 33
31 34
31 34
31 34
32 29
32 29
32 31
32 32
32 32
32 33
32 33
32 34
32 35
32 35
32 35
33 30
33 30
33 30
33 30
33 30
33 31
33 31
33 31
33 31
33 31
33 32
33 32
33 32
33 33
33 33
33 34
33 35
33 35
33 35
33 35
33 36
33 36
33 36
33 36
34 31
34 32
34 32
34 32
34 32
34 32
34 32
34 32
34 33
34 33
34 33
34 34
34 34
34 34
34 34
34 35
34 35
34 36
34 36
34 37
34 37
35 32
35 32
35 32
35 32
35 32
35 32
35 32
35 32
35 32
35 33
35 33
35 33
35 34
35 35
35 35
35 36
35 36
35 36
35 37
35 37
35 38
35 38
35 38
35 38
36 33
36 34
36 34
36 34
36 35
36 35
36 36
36 36
36 36
36 36
36 36
36 37
36 37
36 38
36 38
36 39
37 34
37 34
37 34
37 35
37 35
37 36
37 36
37 36
37 37
37 37
37 37
37 37
37 37
37 38
37 38
37 38
37 38
37 39
37 39
37 39
37 40
37 40
38 35
38 35
38 36
38 36
38 37
38 37
38 37
38 37
38 38
38 38
38 38
38 39
38 39
38 39
38 39
38 40
38 40
38 40
38 40
38 40
38 41
38 41
38 41
38 41
39 36
39 36
39 36
39 37
39 37
39 37
39 37
39 38
39 38
39 38
39 39
39 39
39 39
39 40
39 40
39 40
39 41
39 41
39 41
39 41
39 41
39 41
39 41
39 42
39 42
39 42
39 42
39 42
40 37
40 37
40 37
40 37
40 38
40 38
40 39
40 39
40 39
40 39
40 39
40 40
40 40
40 40
40 41
40 42
40 43
40 43
40 43
40 43
41 38
41 38
41 38
41 39
41 39
41 40
41 40
41 41
41 41
41 42
41 42
41 42
41 43
41 43
41 43
41 43
41 43
41 43
41 44
41 44
41 44
41 44
41 44
41 44
42 39
42 39
42 39
42 39
42 40
42 40
42 40
42 41
42 42
42 42
42 42
42 43
42 43
42 44
42 44
42 44
42 44
42 44
42 45
42 45
42 45
42 45
43 40
43 40
43 40
43 40
43 41
43 41
43 41
43 41
43 41
43 42
43 42
43 42
43 42
43 42
43 42
43 43
43 43
43 43
43 43
43 43
43 44
43 45
43 46
43 46
44 41
44 41
44 41
44 41
44 42
44 43
44 43
44 44
44 44
44 44
44 44
44 44
44 45
44 45
44 46
44 46
44 46
44 46
44 47
44 47
44 47
45 42
45 42
45 42
45 42
45 42
45 42
45 43
45 43
45 43
45 43
45 44
45 44
45 44
45 45
45 46
45 46
45 46
45 46
45 47
45 47
45 47
45 48
45 48
45 48
45 48
45 48
46 43
46 43
46 43
46 44
46 44
46 44
46 45
46 45
46 45
46 46
46 46
46 47
46 47
46 47
46 47
46 48
46 48
46 48
46 48
46 48
46 48
46 48
46 48
46 49
46 49
46 49
47 44
47 44
47 44
47 45
47 45
47 46
47 47
47 47
47 47
47 48
47 48
47 48
47 49
47 49
47 49
47 49
47 50
48 45
48 45
48 46
48 46
48 46
48 46
48 47
48 47
48 47
48 48
48 49
48 50
48 51
48 51
48 51
48 51
49 46
49 46
49 46
49 46
49 46
49 46
49 47
49 48
49 48
49 48
49 49
49 49
49 50
49 51
49 51
49 52
49 52
50 47
50 48
50 48
50 49
50 50
50 51
50 51
50 51
50 52
50 52
50 52
50 52
50 52
50 52
50 53
 Age of Female vs. Age of Male They Found Attrac-
tive
60
Age of Male They Find Attractive

50

40

30

20

10

0
15 20 25 30 35 40 45 50 55
Age of Female