Exhibit 11.1 The Following Questions Use the Data Below

question 95

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. If predicting the cars sold for time period 14, what formula must be placed in cell B16?

• A) =AVERAGE(B12:B15)
• B) =AVERAGE(B12:B15)/4
• C) =TREND(B12:B15)
• D) =B14

---

Definitions:

Prevalence

Proportion of the population who have a specific disorder at a given point or period in time.

Chronic Insomnia

A long-standing difficulty in falling asleep or staying asleep, despite the opportunity to do so, affecting someone's day-to-day functioning.

Mental Disorders

Health conditions characterized by alterations in thinking, mood, or behavior associated with distress and impaired functioning.

Adults

Refers to individuals who have reached the age of majority, typically signifying the transition from childhood into legal independence and societal responsibilities.