Question

mobile ownership
spreadsheet scenario
the student council at a high school surveyed students regarding their spending habits, specifically if they spend their allowance on books or games, and whether they participate in extracurricular activities. a total of 400 students were surveyed.

	a	b	c	d
2	yes	b2 (books)	c2 (games)	d2
3	no	b3 (books)	c3 (games)	d3
4	total	b4 (books)	c4 (games)	d4

given the setup, the following values are known:

• 250 students participated in extracurricular activities.
• 150 students do not participate in extracurricular activities.
• 100 students in total spend their money on games.
• 100 of the nonparticipating students spent their money on games.

once all other values are determined, how should you calculate the value for cell b3 (students not participating and spending on books)?

• subtract c4 from 400 to find b3
• d3 minus c3
• add b2 and c2, then subtract from 400
• 400 minus the sum of b2, c2, and c3

Explanation:

We know the total number of students surveyed is 400. The students can be divided into four groups: those who participate and spend on books (B2), participate and spend on games (C2), don't participate and spend on games (C3), and don't participate and spend on books (B3). To find B3, we subtract the sum of the other three groups (B2, C2, C3) from the total number of students (400). So the formula is \( 400-(B2 + C2 + C3) \), which means we calculate 400 minus the sum of B2, C2, and C3.

Answer:

400 minus the sum of B2, C2, and C3