Reference no: EM13537411

The table below shows the marketing expenditure and corresponding sales figures on a month by month basis for SM Heating Products.

You are asked to produce an analysis of these figures for inclusion in a report to be presented to the board of directors. In doing this you will need to establish trends over the period shown for both expenditure and revenue and determine the relationship between these. This will require the use of statistical analysis tools available in Excel.

You will need to select appropriate trend-lines and relationship functions to bring the data into an understandable form. You must justify your selection.

Finally you should write a summary of the techniqueused in the analysis and critically evaluate your results.

Month	Marketing Expenditure (£000's)	Sales (£000's)
Jul-08	300	530
Aug-08	346	635
Sep-08	834	1000
Oct-08	723	938
Nov-08	130	274
Dec-08	624	793
Jan-09	345	536
Feb-09	768	1450
Mar-09	464	800
Apr-09	624	826
May-09	270	373
Jun-09	389	403
Jul-09	917	1592
Aug-09	836	1632
Sep-09	613	804
Oct-09	741	1064
Nov-09	456	582
Dec-09	246	425
Jan-10	734	903
Feb-10	824	946
Mar-10	234	306
Apr-10	423	623
May-10	682	835
Jun-10	234	352

Table of Results