Exhibit 11.1 The Following Questions Use the Data Below

question 102

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 root mean squared error in cell C18 of the spreadsheet?

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

Understand the concept of expected value of perfect information and its significance.

Recognize the symbols and elements of a decision tree, including nodes and their meanings.

Understand the various decision-making environments and criteria, including certainty, risk, and uncertainty.

Comprehend the calculation and implication of expected monetary values in decision-making.

---

Definitions:

Nominal Exchange Rate

The rate at which one country's currency can be exchanged for another country's currency without adjusting for inflation rates.

Real Exchange Rate

The rate at which goods and services of one country can be exchanged for those of another, adjusting for price level differences.

Trade Deficit

The economic condition that occurs when a country imports more goods and services than it exports.

Net Exports

The net amount obtained by subtracting a nation's total imports from its total exports.