Question: Use EXCEL s regression tools to analyze and forecast future sales

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.


View Solution:


Sale on SolutionInn
Sales0
Views110
Comments
  • CreatedDecember 19, 2014
  • Files Included
Post your question
5000