In an Excel Spreadsheet Set Up for an Exponential Smoothing

question 19

Multiple Choice

In an Excel spreadsheet set up for an exponential smoothing forecast model,if alpha is in cell B4,the demand for period 3 is in cell B11,and the forecast for period 3 is in cell C11 the Excel formula for the forecast for period 4 in cell C12 is

• A)=B4*B11*1-B4)*C11
• B)=B4*B11+1-B4)*C11
• C)=B11*B4+1-B11)*C11
• D)=B4*C11+1-C11)*B11

---

Definitions:

Risky Shift

Is the phenomenon where groups tend to make riskier decisions together than individuals would on their own, often attributed to the diffusion of responsibility.

Selective Perception

The process where individuals selectively interpret what they see based on their interests, background, experience, and attitudes.

Perceptual Bias

is the tendency for perception to be affected by recurring thoughts, beliefs, or attitudes, leading to distorted interpretations of information.

Attribution Bias

A cognitive bias that affects the way people deduce the causes of their own and others' behaviors, often attributing them incorrectly.