Data Analysis Report: Marketing Expenditure and Forecasting Models

This report provides a detailed analysis of marketing expenditure data using various statistical methods. It begins with arranging the data in a tabular structure and then presents it graphically. The report calculates and interprets the mean, median, mode, range, and standard deviation of the data, providing insights into the central tendencies and variability of the marketing expenses. Furthermore, it formulates a forecasting model using a linear equation to predict future expenditure values, demonstrating the application of data analysis in making strategic decisions. The conclusion summarizes the key findings and emphasizes the importance of data analysis in various applications. The report includes all the necessary calculations and interpretations to give a complete overview of the data analysis process.

NUMERACY AND DATA
ANALYSIS

TABLE OF CONTENTS
INTRODUCTION.......................................................................................................................................3
MAIN BODY..............................................................................................................................................3
1. Arranging data in tabular structure:.................................................................................................3
2. Graphical representation of mentioned data set...............................................................................4
3. Representing the computation as follows.........................................................................................4
4. Formulating forecasting model for linear equation as below:..........................................................9
CONCLUSION.........................................................................................................................................11
REFERENCES..........................................................................................................................................12

INTRODUCTION
Data analysis is the systematic procedure of implementing statistical and logical data to
evaluate and obtain require information. In the current era, it is crucial for organization to have
effective data analytical system to obtain sufficient understanding and analysis of available
information so that effective and strategic decision can be taken. The present report will include
tabular arrangement of data along with graphical representation. It will include mean, mode,
median, range, standard deviation and discussion of equation in structured pattern.
MAIN BODY
1. Arranging data in tabular structure:
Serial
Number
Months Money incurred on marketing expenditure (In
pounds)
1 Jan 10
2 Feb 12
3 Mar 5
4 April 45
5 May 12
6 June 42
7 July 34
8 Aug 15
9 Sept 24
10 Oct 26

2. Graphical representation of mentioned data set
Jan
Feb
Mar
April
May
June
July
Aug
Sept
Oct
1 2 3 4 5 6 7 8 9 10
0
5
10
15
20
25
30
35
40
45
50
Money incurred on marketing
expenditure (In pounds)
Money incurred on
marketing expenditure (In
pounds)
Jan
Feb
Mar
April
May
June
July
Aug
Sept
Oct
1 2 3 4 5 6 7 8 9 10
0
5
10
15
20
25
30
35
40
45
50
Money incurred on marketing
expenditure (In pounds)
Money incurred on
marketing expenditure (In
pounds)
3. Representing the computation as follows
I. Determination of mean
Serial Number Months Money incurred
on marketing

expenditure (In
pounds)
1 Jan 10
2 Feb 12
3 Mar 5
4 April 45
5 May 12
6 June 42
7 July 34
8 Aug 15
9 Sept 24
10 Oct 26
Total amount of money spent on
transportation cost 225
Total number of months 10
Mean 22.5
Interpretation
From the above table it can be interpreted that mean has been computed for 10 months
for the marketing expenditures (Belan, 2020). For deriving the result the formula applied is sum
of all moth expenses divided by number of period selected. The outcome derived for the
mentioned period is 22.5 pound. It can be widely take into consideration for making strategic
decisions regarding cost incurred.
II. Computation of Median Value (MV)
Two steps will be taken into procedure in order to derive MV which comprises arranging
data in ascending order and then implementing formula
Step 1:

Arranging statistical information in ascending order
Serial Number Months Money incurred on marketing expenditure (In
pounds)
1 Mar 5
2 Jan 10
3 Feb 12
4 May 12
5 Aug 15
6 Sept 24
7 Oct 26
8 July 34
9 June 42
10 April 45
Step 2
Computation of media through executing formula
Formula = (n+1)/2
Number of observations = 10
Median = (n+1)/ 2
= (5+6)/ 2
= 5.5 cell
For this purpose,
= (15+24)/ 2
= 19.5
Interpretation

From the above calculation it can be interpreted that median for the chosen expenses is
19.5 pound which is calculated by applying the appropriated stated formula (Putranti, 2021).
III. Assessment of mode value
Serial
Number
Months Money incurred on marketing
expenditure (In pounds)
1 Jan 10
2 Feb 12
3 Mar 5
4 April 45
5 May 12
6 June 42
7 July 34
8 Aug 15
9 Sept 24
10 Oct 26
Interpretation
From the evaluation of above illustrated table it can be stated that the frequency that has
been repeated more than once is called mode value. The amount 12 of marketing expenses is
repeated twice which can be referred as mode value in this particular case.
IV. Calculation of Range Value (RV)
Particulars Formula Amount
Maximum expense 45
Minimum expense 5
Higher expense- smaller
value
= (45-5)
= 40
Interpretation

Range is determined by deducting the lower amount of marketing expense from the
higher. From the evaluation of above table it can be stated that higher range of expense is 45 and
lower is 5 regarding specified expenditure (Cao, 2021). The amount derived from the
computation is 40 by deducting 5 from 45.
V. Assessment of Standard Deviation (SD)
Months Money
incurre
d
Mean
(U)
X- U
(X-U)^2
Jan 10 22.5 -12.5 156.25
Feb 12 22.5 -10.5 110.25
Mar 5 22.5 -17.5 306.25
April 45 22.5 22.5 506.25
May 12 22.5 -10.5 110.25
June 42 22.5 19.5 380.25
July 34 22.5 11.5 132.25
Aug 15 22.5 -7.5 56.25
Sept 24 22.5 1.5 2.25
Oct 26 22.5 3.5 12.25
Total 1772.5
SD= Square root of ∑(X-U) ^2/N
= Square root of (1772.5/ 10)
= SQRT OF 177.25
=13.31
Interpretation

From the data it can be stated that SD for this particular scenario regarding marketing
expenses is 13.31 that is associated with moderate variation which shows the moderate risk.
4. Formulating forecasting model for linear equation as below:
Mont
hs
X Y (Money
incurred
on
marketing
expenditur
e)
X*Y X^2
Jan 1 10 10 1
Feb 2 12 24 4
Mar 3 5 15 9
April 4 45 180 16
May 5 12 60 25
June 6 42 252 36
July 7 34 238 49
Aug 8 15 120 64
Sept 9 24 216 81
Oct 10 26 260 100
Total 55 225 1375 385
i. Computation of m value:
m = NΣxy – Σx Σy / NΣ x^2 – (Σx)^2
= (1375) - (55*225)/ (385)-(55)^2
= (1375-12375)/ (385-3025)
= -11000/ -2640
= 4.16
ii. Determination of value c is illustrated below

C = Σy – mΣx / N
= 225-4.16(55) /10
=225- 228.8/10
= -38/ 10
= -0.38
iii. Calculation values of expense for 12 and 14
Calculation in case of 12th which is shown as below:
y = mx + c
= 4.16(12) + (-0.38)
= 49.92 – 0.38
= £49.54
Determination in case of 14th which is shown as following:
y = mx + c
= 4.16 (14) + (0.38)
= 58.24 - 0.38
= £57.86
Interpretation
From the above table it can be interpreted that the expenditure for the period of 12 & 14
calculated with the help of value m and c which are 4.16 and - 0.38 respectively. These values
are placed in the formula given for deriving the required period outcome. The result obtained
from mentioned formula for 12th and 14th period are 49.54 and £57.86 respectively.

CONCLUSION
From the report it can be concluded that data analysis provides crucial information which
can be utilized for several purposes. The current report has comprised tabular, graphical
presentation, computation of mean, mode, median, range and SD to give the appropriate
knowledge regarding the same. Values of m and c has been derived for accomplishing
requirement of determining figures of specified duration.

REFERENCES
Books and Journals
Putranti, S. R. D., 2021. Relationships between Mean, Median and Mode. Aloha International
Journal of Multidisciplinary Advancement (AIJMU). 3(4). pp.87-94.
Cao, W., 2021. Discussion on Mean, Median, Mode and its Validity and Table
Number. Journal of Contemporary Educational Research. 5(3).
Belan, S., 2020. Median and mode in first passage under restart. Physical Review Research.
2(1), p.013243.