Exhibit 11.1 The Following Questions Use the Data Below

question 60

Multiple Choice

Exhibit 11.1
The following questions use the data below.
Honest Al's Used Cars wants to predict how many cars are sold each month. He has collected data for 12 months. He needs your help in analyzing this data using moving averages.
-Refer to Exhibit 11.1. What Excel function will compute the mean squared error in cell C18 of the spreadsheet?

• A) =SUMXMY2(B7:B14,C7:C14)
• B) =SUMXMY2(B3:B14,C3:C14)/COUNT(C3:C14)
• C) =SUMXMY2(B7:B14,C7:C14)/COUNT(C7:C14)
• D) =SUMPRODUCT(B7:B14,C7:C14)/COUNT(C7:C14)

Recognize the importance of environmental factors and community infrastructure in disease prevention.

Understand the historical development of public health initiatives and their impact on community health.

Analyze the role of government and non-governmental organizations in the advancement of public health.

Identify key figures and their contributions to public health and nursing.

---

Definitions:

Pink-Collar Workers

Employees working in job sectors traditionally considered to be dominated by women, such as nursing, teaching, and clerical work.

Economic "Booms"

Periods of significant growth and expansion in economic activity characterized by increased production, employment, and often inflation.

Economic "Busts"

Periods characterized by economic decline, where there is a significant reduction in economic activity across an economy.

Union Density

The number of union members in a given location and time as a percentage of nonfarm workers. It measures the organizational power of unions.