Exhibit 7.1 The Following Questions Are Based on the Problem Below

question 8

Multiple Choice

Exhibit 7.1
The following questions are based on the problem below.
A company wants to advertise on TV and radio. The company wants to produce about 6 TV ads and 12 radio ads. Each TV ad costs $20,000 and is viewed by 10 million people. Radio ads cost $10,000 and are heard by 7 million people. The company wants to reach about 140 million people, and spend about $200,000 for all the ads. The problem has been set up in the following Excel spreadsheet.
-Refer to Exhibit 7.1. What formula goes in cell B9?

• A) =SUM(B6:B8)
• B) =B6+B7-B8
• C) =B6-B7+B8
• D) =B10-B8

---

Definitions:

Dependent Variable

In a scientific study, a measure of an assumed effect of an independent variable.

Performance

Performance refers to the act of carrying out a task or function, often evaluated in terms of effectiveness, efficiency, or skill.

Socioeconomic Status

A combined measure of an individual's or family's economic and social position relative to others, based on income, education, and occupation.

Sexual Orientation

An inherent or immutable enduring emotional, romantic, or sexual attraction to other people.