QUESTION 2 (28 MARKS)

1. Research a data analytical tool of your choice and explain how it works. What are some of the advantages

and disadvantages of the tools? [8 marks]

2. New car sales for a dealer in Cook County, Illinois, for the past year are shown in the following table, along with monthly indexes (seasonal relatives), which are supplied to the dealer by the regional distributor.

Month	Units sold
Jan	640
Feb	648
Mar	630
Apr	761
May	735
Jun	850
Jul	765
Aug	805
Sep	840
Oct	828
Nov	840
Dec	800

a) Capture this data in excel and plot the data. You should take a snapshot of the graph you created and paste it into your assignment. [2 marks] b) Does there seem to be a pattern? Explain. [3 marks]

c) What forecasting technique will you suggest for the above data? Justify your answer [ 3marks]

2.3 Give three practical scenarios where you will be required to use qualitative techniques and three scenarios where you will be required to use quantitative techniques. [12 marks]