Question: Using any Forecasting Software that you may find it on the internet free of charge, solve following problems. In preparing your homework, show the steps
Using any Forecasting Software that you may find it on the internet free of charge, solve following problems. In preparing your homework, show the steps of the solution supported by screenshots .
2. MOBA is a furniture retailer in Konya. The Marketing Manager wants to prepare a media budget based on the next quarter's business plan. The manager wants to decide the mix of radio advertising and newspaper advertising needed to generate varying levels of Weekly Gross Revenue. The manager has collected data for the past five weeks, and has recorded the following average Weekly Gross Revenues and expenditures for Weekly Radio (X1) and Newspaper (X2) advertising:
| WEEK |
AVERAGE WEEKLY GROSS REVENUE ($000) | AVERAGE WEEKLY RADIO ADVERTISING ($000) | AVERAGE WEEKLY NEWSPAPER ADVERTISING ($000) |
| 1 | 60 | 6 | 1 |
| 2 | 45 | 3 | 3 |
| 3 | 55 | 4 | 2 |
| 4 | 70 | 5 | 3 |
| 5 | 40 | 2 | 1 |
Use multiple regression model to obtain the regression line.
-
What is the regression line
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
