View the step-by-step solution to:

Question

I'd like to double check my work. I'm attaching a snippit of the question, as well as the DATA points.

Thank you.


Q17.F.png

Q17.F.png

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
Customer Eye Condition Gender
Row Labels
Bifocals
Farsighted Nearsighted Grand Total
Male
Female
22
9
16
47
IO U A W N K
Nearsighted
Female
47
Bifocals
Male
15
37
Bifocals
Male
48
Bifocals
Male
Grand Total
20
24
84
Nearsighted
Female
49
Bifocals
Female
Nearsighted
Male
50
Bifocals
emale
Bifocals
Female
51
Farsighted
ONone of the answers match my table
Nearsighted
Female
52
Bifocals
Female
1 00
Nearsighted
Female
53
Farsighted
Male
Bifocal
Male
54
Bifocals
Male
Count of Eye Condition Column Labels
Bifocals
55
Bifocals
Female
Row Labels
Bifocals
Farsighted Nearsighted Grand Total
10
Bifocals
emale
56
Bifocals
Female
Female
9
55
29
11
Farsighted
Male
57
Nearsighted
Male
Male
Grand Total
20
19
84
12
Bifocals
Male
58
Nearsighted
Female
13
Female
59
Bifocals
Male
Count of Gender Column Labels
14
Nearsighted
Female
60
Nearsighted
Male
Row Labels - Bifocals
Farsighted Nearsighted Grand Total
15
Bifocals
Male
61
Bifocals
Male
Female
15
9
20
44
16
Bifocals
Female
62
Farsighted
Male
Male
10
15
15
17
Bifocals
Female
Grand Total
25
24
25
Bifocals
Female
18
Farsighted
Male
Bifocals
Male
19
Bifocals
Farsighted
Male
Count of Eye Condition Column Labels
20
Nearsighted
Male
66
Bifocals
Male
Row Labels
Farsighted Nearsighted Grand Total
21
Bifocals
Male
Farsighted
Male
Female
13
27
22
Nearsighted
68
Nearsighted
Female
Male
24
23
Nearsighted
69
Bifocals
Female
Grand Total
21
51
84
24
Bifocals
Female
70
Farsighted
Male
25
Bifocals
Female
71
Nearsighted
Female
26
Farsighted
Male
72
Farsighted
Male
27
Nearsighted
Female
73
Nearsighted
Female
28
Farsighted
Male
74
Bifocals
Female
29
Bifocals
75
Farsighted
Male
30
Bifocals
Female
76
Farsighted
Female
31
Farsighted
Male
Farsighted
Female
32
Farsighted
Male
78
Farsighted
Female
33
Bifocals
emale
79
Farsighted
Female
34
Nearsighted
Female
80
Farsighted
Female
35
Bifocals
Female
81
Farsighted
Female
36
Bifocal
Male
82
Farsighted
Female
37
Bifocals
Male
83
Farsighted
Female
38
Nearsighted
Female
84
Farsighted
Female
39
Nearsighted
Male
40
Nearsighted
41
Bifocals
Female
Bifocals
Female
43
Bifocals
Male
44
Bifocals
45
Farsighted
Male
46
Nearsighted
Female

Top Answer

Sign up to view the full answer

Why Join Course Hero?

Course Hero has all the homework and study help you need to succeed! We’ve got course-specific notes, study guides, and practice tests along with expert tutors.

-

Educational Resources
  • -

    Study Documents

    Find the best study resources around, tagged to your specific courses. Share your own to gain free Course Hero access.

    Browse Documents
  • -

    Question & Answers

    Get one-on-one homework help from our expert tutors—available online 24/7. Ask your own questions or browse existing Q&A threads. Satisfaction guaranteed!

    Ask a Question
Ask a homework question - tutors are online