1. You use the Excel Analysis ToolPak to run a regression. Using the statistics that the regression returned, you want to develop a forecast based on a $100 per day increase in social media advertising. How should you go about this? Select an answer:

a. Add your $100 assumption to the coefficient.

b. Divide the coefficient by your $100 assumption.

c. Multiply the coefficient by your $100 assumption.

2. You run a regression to identify the most significant variables that drive sales. Which statistic will provide you with this information?

Select an answer:

• the t-stat

• the coefficient

• the P-value

3.Your regression returned a coefficient of 1.56, an R-squared of 2.95, and a standard error of 164450. Which statistic tells you how accurate the prediction is?

Select an answer:

• the coefficient

• the R-squared

• the standard error

4. You run a regression in Excel for your six sales regions. How can you create a hedonic model from the results?

Select an answer:

• Multiply the coefficients by your y variable.

• Multiply the coefficients by your R-squared.

• Multiply the coefficients by your x variable.