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.

Membership TRY NOW
  • Access to 800,000+ Textbook Solutions
  • Ask any question from 24/7 available
    Tutors
  • Live Video Consultation with Tutors
  • 50,000+ Answers by Tutors
OR
Relevant Tutors available to help