# Use EXCELs regression tools to analyze and forecast future sales. a.Create a spreadsheet with the following data about targeted emails,

## 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.

## This problem has been solved!

## Step by Step Answer:

**Related Book For**

## Accounting Information Systems

**ISBN:** 978-0133428537

13th edition

**Authors:** Marshall B. Romney, Paul J. Steinbart

**View Solution**

**Cannot find your solution?**