Question

Use EXCEL’s regression tools to analyze and forecast future sales.
a. Create a spreadsheet with the following data about targeted emails, click ads, and unit sales:

.:.
b. Create a scatter graph to illustrate the relationship between targeted emails and unit sales. Display the regression equation and the R2 between the two variables on the chart.
c. Create a scatter graph to illustrate the relationship between click ads and unit sales. Display the regression equation and the R2 between the two variables on the chart.
d. Which variable (targeted emails or click ads) has the greater influence on unit sales? How do you know?
e. Use the “=Forecast “function to display the forecasted sales for 200,000 targeted emails and for 200 click ads.



$1.99
Sales0
Views79
Comments0
  • CreatedDecember 19, 2014
  • Files Included
Post your question
5000