$12\mathrm{.}12$ B$$C$$ PBOBLM

Use DXCBL$\text{'}$s regression tools to analyze and forceast future sales. $($Iitints The article "Dorecasting with Breel," by James A$.$ WKisel in the February to perform the following tasks using etther Dxcel $2003$ or Dreel $2007).$

a$.$ Create a spreadsheet with the following data about targeted emails, cliek ads, and unit saless Use the Breel file already loaded.

d$.$ Which vifiable $($targeted emails or elick ads$)$ has the greater infiluence on unit saless How do you know?

Targeted emails have a greater effect on unit sales than do click ads as shown by the higher $R^2$ for the regression formula.

e$.$ Use the $=$ Dorecast "function to display the forecasted sales for $200,000$ targeted emails and for $200$ click ads.

Formula to forecast sales given number of click ads $($cell C$32)$:

FFORECAST$($B$32,$ C$2$:C$31,$ B$2$:B$31)$

Answer. Forecasted sales for $200$ click ads is $14,956$

Formula to forecast sales given number of targeted emails $($cell C$33)$:

$=$PORECAST$($A$33,$C$2$:C$31,$A$2$:A$31)$

Answer. Forecasted sales for $200,000$ targeted emails is $16,610$