New Tab Week 3 Forecasting Sales Problem ws/kelly/Downloads/Week%203%20Forecasting%20Sales%20Problem.pdf x | + Week 3 Simple Regression Forecasting Sales Problem Homework Assignment 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. Week 3 Forecasting Sales Using Ad Dollars Data - Protected Save On Home Insert Draw Page Layout Formulas Data Review View Help PROTECTED VIEW Be careful-files from the Internet can contain viruses. Unless you need to edit, it's safer to stay D F H E G B Week 3 Simple Regression Forecasting Sales Problem Homework Assignment Ad $ in Thousands Sales $ in Millions Ad $ Sales $ Predicted Error 41 1250 54 1380 63 1425 54 1425 48 1450 46 1300 62 1400 61 1510 64 1575 71 1650 10 3 4 5 16 17 18 19 20 21 22 23 24 25 Sheet1