LC Sdn Bhd has collected the following data on quantity sold (Q), price (P), income (I), and advertising (A) and you have been appointed as a business consultant to the company.

Period	Quantity	Price	Income	Advertising
1	120	8.0	10	3
2	165	4.0	22	7
3	120	7.0	20	5
4	165	3.0	20	8
5	180	4.0	30	8
6	90	10.0	19	6
7	150	4.0	18	10.2
8	190	1.6	25	9.3
9	160	5.0	30	8
10	200	2.0	35	9.5

1. What are the basic information can you can convey to the company regarding the given data (Hint: explain using graph, chart etc)

2 Propose a regression model that you can build using the above information and use Excel to estimate the model. Write the linear equation that you find.

3 Do the signs of the coefficients make economic sense? Which of the coefficients are significant?

4 Explain how the model can be used as a forecasting technique. Show how it is done