Using the Excel file Forecasting Sales Using Ad Dollars Data use Excel to create a forecast of Sales $ using Ad $.

Analyze the data using simple linear regression in Excel to answer the following questions.

1. Does more ad spending increase, decrease, or have no effect on sales $?
2. What is the regression equation? Write it and its numerical values.
3. Using the regression equation calculate predicted sales and error values and enter them into the Excel spreadsheet in the appropriate spaces.

Home Insert Draw Page Layout View Share Comments P vm A - , % Formulas Data Review Conditional Formatting v ting Format as Table Cell Styles Ov Paste Font Alignment Number Editing Ideas H8 X fx C F G H I J K L M N O P Predicted Sales Error D E Ad $ in Thousands Sales $ in Millions Ad $ Sales $ 41 1250 1380 1425 1425 1450 1300 1400 1510 1575 1650 Sheet1 Sheet2 Sheet3 + @ - G O + 100%