QUESTION 1 A company has 12 branchese. The number of employee and the monthly sales of each branch are given in the table below: Branch Number of Monthly Sales Employee Sales($000's) A 4 204 B. 5 241 4 251 D 7 366 E 6 321 F 9 501 G 7 406 H 8 421 I 6 331 J 7 306 K 4 286 L 5 301 a) Represent the data on a scatter graph. [5 marks] b) Write down excel function for the correlation r (0.914467) and make comment on it. [5 marks). c) Write down excel function for Slope (46.633) and Intercept (48.116) of the regression line of best fit and add it to your scatter graph. [5 marks] d) Use the equation to forecast the monthly sales for a new store where it is planned to employ 8 sales assistants. [5 marks]