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)

---

Definitions:

Conditioned Stimulus

A previously neutral stimulus that, after becoming associated with the unconditioned stimulus, eventually triggers a conditioned response.

Unconditioned Stimulus

A stimulus that naturally and automatically triggers a response without the need for prior learning.

Variable-interval

In the context of psychology, a schedule of reinforcement where a response is rewarded after an unpredictable amount of time has passed.

Reinforcement Principles

Psychological concepts that involve strengthening a behavior by providing a desirable consequence or removing an undesirable one.