Question: Pivot Table Question 17 (4 points) To balance inventory at Otto's Optometry, customer Gender and Eye Condition were collected in DATA. Make a 2x2
Pivot Table Question 17 (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 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 47 Male 17 15 5 37 Grand Total 39 24 21 84 None of the answers match my table Count of Eye Condition Column Labels Row Labels Bifocals Farsighted Nearsighted Grand Total Female 13 27 5 45 Male 8 24 7 39 Grand Total 21 51 12 84 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
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
