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,

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!