To balance inventory at Otto's Optometry customers Gender and eye condition were collected data below . Make a two-way pivot table with gender in a row and eye condition column The pivot table is:

Data:

Customer #	Eye Condition	Gender	Customer #	Eye Condition	Gender	Customer #	Eye Condition	Gender
1	Bifocals	Female	36	Bifocals	Female	71	Farsighted	Male
2	Bifocals	Male	37	Bifocals	Male	72	Nearsighted	Female
3	Nearsighted	Male	38	Nearsighted	Male	73	Bifocals	Male
4	Nearsighted	Female	39	Nearsighted	Male	74	Bifocals	Female
5	Nearsighted	Female	40	Farsighted	Male	75	Bifocals	Female
6	Nearsighted	Female	41	Bifocals	Male	76	Farsighted	Female
7	Bifocals	Female	42	Nearsighted	Female	77	Farsighted	Female
8	Nearsighted	Female	43	Farsighted	Male	78	Farsighted	Female
9	Bifocals	Female	44	Nearsighted	Male	79	Farsighted	Female
10	Farsighted	Male	45	Nearsighted	Female	80	Farsighted	Female
11	Nearsighted	Female	46	Farsighted	Male	81	Farsighted	Female
12	Bifocals	Male	47	Bifocals	Male	82	Farsighted	Female
13	Nearsighted	Male	48	Bifocals	Female	83	Farsighted	Female
14	Nearsighted	Female	49	Nearsighted	Female	84	Farsighted	Female
15	Nearsighted	Male	50	Farsighted	Male
16	Farsighted	Male	51	Farsighted	Male
17	Nearsighted	Female	52	Bifocals	Female
18	Farsighted	Male	53	Bifocals	Female
19	Farsighted	Male	54	Nearsighted	Male
20	Farsighted	Male	55	Nearsighted	Male
21	Farsighted	Male	56	Nearsighted	Female
22	Bifocals	Male	57	Nearsighted	Female
23	Nearsighted	Female	58	Nearsighted	Male
24	Bifocals	Female	59	Farsighted	Male
25	Nearsighted	Male	60	Nearsighted	Male
26	Bifocals	Female	61	Nearsighted	Male
27	Bifocals	Female	62	Bifocals	Male
28	Bifocals	Female	63	Nearsighted	Female
29	Nearsighted	Male	64	Farsighted	Male
30	Nearsighted	Female	65	Nearsighted	Male
31	Bifocals	Male	66	Bifocals	Male
32	Nearsighted	Male	67	Bifocals	Female
33	Bifocals	Female	68	Nearsighted	Female
34	Nearsighted	Female	69	Nearsighted	Female
35	Farsighted	Male	70	Nearsighted	Female