Using any Forecasting Software, solve following problems. In preparing your homework, show the steps of the solution supported by screenshots .

I NEED THE SOLVING ON PAPER AND EXCEL PLEASE

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.

1. What is the regression line.