Exhibit 11.6 The Following Questions Use the Data Below

question 96

Multiple Choice

Exhibit 11.6
The following questions use the data below.
A store wants to predict quarterly sales. The owner has collected 3 years of sales data and wants your help in analyzing the data using the double moving average model with k = 4.
-Refer to Exhibit 11.6. What formula should be entered in cell H9 to compute the trend using the double moving average model with k = 4?

• A) =2*(AVERAGE(E9,F9))/4
• B) =2*(E9-F9)/(4-1)
• C) =2*(E9-F9)/(4*2)
• D) =2*(D9-F9)/(4-1)

---

Definitions:

Guinness Book

A reference book published annually, listing world records both of human achievements and the extremes of the natural world.

Tertiary

Refers to the third level or stage in a sequence; in education, it commonly relates to post-secondary education such as universities and colleges.

Quaternary

Relating to the fourth stage or division, often used in context of geological periods or the sector of the economy that deals with knowledge-based activities.

Historiography

The study of the methods and principles through which history is written, including the different perspectives and interpretations.