Exhibit 11.18 The Following Questions Use the Data Below

question 15

Essay

Exhibit 11.18
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 multiplicative seasonal method.
-Refer to Exhibit 11.18. What formulas should go in cells E3:G16 of the spreadsheet if the multiplicative seasonal method is used to forecast sales?

---

Definitions:

Hypothesis

A proposed explanation for a phenomenon, made as a starting point for further investigation, that can be tested through experimentation or observation.

Desirable Feature

A trait or characteristic of a product, person, or concept that is attractive and makes it preferable.

P Value

A statistical measure that indicates the probability of obtaining the observed results of a study by chance alone, often used to test hypotheses.

Correlational Study

A research method that examines the relationship between two or more variables to determine whether and how they change together.