to balance inventory at otto's optometry, customer gender and eye condition were collected in data. make a 2x2 pivot table with header in rows and eye condition in columns. the pivot table is

Customer # Eye Condition Gender

1 Farsighted Male

2 Bifocals Male

3 Nearsighted Male

4 Farsighted Male

5 Nearsighted Female

6 Farsighted Male

7 Farsighted Male

8 Nearsighted Female

9 Nearsighted Male

10 Farsighted Male

11 Bifocals Male

12 Farsighted Female

13 Farsighted Male

14 Farsighted Male

15 Farsighted Male

16 Farsighted Male

17 Nearsighted Male

18 Bifocals Female

19 Farsighted Male

20 Farsighted Male

21 Farsighted Male

22 Bifocals Male

23 Farsighted Female

24 Nearsighted Male

25 Nearsighted Female

26 Bifocals Female

27 Nearsighted Female

28 Farsighted Female

29 Bifocals Male

30 Nearsighted Female

31 Farsighted Male

32 Bifocals Female

33 Farsighted Male

34 Bifocals Female

35 Bifocals Female

36 Farsighted Female

37 Bifocals Male

38 Farsighted Male

39 Bifocals Female

40 Bifocals Male

41 Farsighted Male

42 Farsighted Female

43 Bifocals Female

44 Farsighted Female

45 Farsighted Male

46 Farsighted Male

47 Bifocals Female

48 Farsighted Female

49 Farsighted Female

50 Bifocals Male

51 Nearsighted Male

52 Bifocals Female

53 Farsighted Female

54 Farsighted Female

55 Farsighted Male

56 Bifocals Female

57 Farsighted Female

58 Farsighted Male

59 Farsighted Male

60 Nearsighted Male

61 Farsighted Female

62 Nearsighted Male

63 Farsighted Female

64 Farsighted Female

65 Bifocals Female

66 Farsighted Male

67 Bifocals Male

68 Farsighted Female

69 Farsighted Male

70 Farsighted Female

71 Bifocals Female

72 Farsighted Male

73 Bifocals Female

74 Farsighted Female

75 Farsighted Female

76 Farsighted Female

77 Farsighted Female

78 Farsighted Female

79 Farsighted Female

80 Farsighted Female

81 Farsighted Female

82 Farsighted Female

83 Farsighted Female

84 Farsighted Female

CHOICES

Question 15 (4 points) To balance inventory at Otto's Optometry, customer Gender and Eye Condition were collected in DATA. Make a 2x2 pivot table with Gender in rows and Eye Condition in columns. The pivot table is Count of Eye Condition Column Labels Row Labels - Bifocals Farsighted Nearsighted Grand Total Female 22 9 16 47 Male 17 15 5 37 Grand Total 39 24 21 84 Count of Eye Condition Column Labels ~ Row Labels Bifocals Farsighted Nearsighted Grand Total Female 13 27 un 45 Male 8 24 7 39 Grand Total 21 51 12 84 None of the answers match my table Count of Gender Column Labels Row Labels - Bifocals Farsighted Nearsighted Grand Total Female 15 9 20 44 Male 10 15 15 40 Grand Total 25 24 35 84 Count of Eye Condition Column Labels Row Labels Bifocals Farsighted Nearsighted Grand Total Female 29 17 55 9 LD Male 11 29 Grand Total 38 18 28 84