Question: Question 17 (4 points) Saved To balance inventory at Otto's Optometry, customer Gender and Eye Condition were collected in DATA. Make a 2x2 pivot

Question 17 (4 points) Saved 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 29 9 17 55 Male 9 9 11 29 Grand Total 38 18 28 84 Count of Eye Condition Column Labels Row Labels Bifocals Farsighted Nearsighted Grand Total Female 22 9 16 Male 17 15 Grand Total 39 24 52 47 37 21 84 Count of Eye Condition Column Labels Row Labels Female Male Grand Total Farsighted Nearsighted Grand Total Bifocals 13 27 82 21 225 24 51 572 45 39 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 Customer Eye Condition Gender 1 Bifocals Female 2 Bifocals Male 3 Nearsighted Male 4 Nearsighted Female 5 Nearsighted Female 6 Nearsighted Female 7 Bifocals Female 8 Nearsighted Female 9 Bifocals Female 10 Farsighted Male 11 Nearsighted Female 12 Bifocals Male 13 Nearsighted Male 14 Nearsighted Female 15 Nearsighted Male 16 Farsighted Male 17 Nearsighted Female 18 Farsighted Male 19 Farsighted Male 20 Farsighted Male 21 Farsighted Male 22 Bifocals Male 23 Nearsighted Female 24 Bifocals Female 25 Nearsighted Male 26 Bifocals Female 27 Bifocals Female 28 Bifocals Female 29 Nearsighted Male 30 Nearsighted Female 31 Bifocals Male 32 Nearsighted Male 33 Bifocals Female 34 Nearsighted Female 35 Farsighted Male 36 Bifocals Female 37 Bifocals Male 38 Nearsighted Male 39 Nearsighted Male 40 Farsighted Male 41 Bifocals Male 42 Nearsighted Female 43 Farsighted Male 44 Nearsighted Male 45 Nearsighted Female 46 Farsighted Male 47 Bifocals Male 48 Bifocals Female 49 Nearsighted Female 50 Farsighted Male 51 Farsighted Male 52 Bifocals Female 53 Bifocals Female 54 Nearsighted Male 55 Nearsighted Male 56 Nearsighted Female 57 Nearsighted Female 58 Nearsighted Male 59 Farsighted Male 60 Nearsighted Male 61 Nearsighted Male 62 Bifocals Male 63 Nearsighted Female 64 Farsighted Male 65 Nearsighted Male 66 Bifocals Male 67 Bifocals Female 68 Nearsighted Female 69 Nearsighted Female 70 Nearsighted Female 71 Farsighted Male 72 Nearsighted Female 73 Bifocals 74 Bifocals Male Female 75 Bifocals 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
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
