Task Instructions

Use the fill handle to copy the formula in cell E$4$ to cells

E$5$:E$11.$

To which scenario would predictive business analytics best be applied?

A$.$ A company would like to budget for new employees in its five$-$year plan.

C$.$ A sales department is looking at various future pricing possibilities to compare the

B$.$ A manufacturer looks at past years' inventory numbers to view trends.

D$.$ The marketing department would like to produce a list of current customers sorted by

state.