Numeracy and Data Analysis

This report explores numeracy and data analysis, covering topics such as arranging data in a table format, presenting data using charts, and calculating different aspects like mean, mode, and median. It also includes a linear forecasting model and provides insights on how to forecast expenses for future months.

Numeracy and Data
Analysis

Contents
INTRODUCTION.......................................................................................................................................4
MAIN BODY..............................................................................................................................................4
1. Arrangement of the data in a table format...........................................................................................4
2. Presentation of the data using any two types of charts.........................................................................4
3. Calculation of different aspects...........................................................................................................6
CONCLUSION.........................................................................................................................................12
REFERENCES..........................................................................................................................................13

INTRODUCTION
Numeracy includes skills not often taught in the course-the willingness of using figures
and overcome actual-life issues. This requires being able to use numbers and quantitative
methods in all areas of life with faith and ability. Numeracy is of equal value to education. Data
processing is a method of gathering and organizing data so that everyone can extract valuable
knowledge from it (Phillipson, Phillipson and Kewalramani, 2018). The main purpose of data
collection, in many other phrases, is to aim at what the data is attempting to tell us. This
category of analysis of information means viewing or witnessing someone or something else.
This report based on the bill payment that paid by individual. In this report consist of mean,
mode, median and other calculations.
MAIN BODY
1. Arrangement of the data in a table format.
Month Type of bill Amount (in ‘00 pounds)
January Electricity bill 20
February Telephone bill 15
March Water bill 15
April Bank statement 25
May Internet bill 10
June Council taxation bill 20
July Heating bill 15
August Rental charges or bill 10
September Grocery bill 25
October Transportation bill 20
2. Presentation of the data using any two types of charts
Line chart: A line chart has been used over even a consistent period of time to display
the data. Eventually, it's being used to display a factor (or changeable) pattern across period. The
data results are calculated as greatest historical utilizing intersection points. A line graph (also

recognized as just a line map or bar graph) is a diagram that utilizes line to link independent and
dependent variables showing numerical measure over a given time period. Line graphs utilize
data point "markers" which are related by flat surfaces to aid with analysis (Saptono, Soetjipto
and Wahyono, 2019).
Electricity bill
Telephone bill
Water bill
Bank statement
Internet bill
Council taxation bill
Heating bill
Rental charges or bill
Grocery bill
Transportation bill
Janu
ary Febr
uary Mar
ch Apri
l May June July Aug
ust Sept
emb
er
Oct
obe
r
0
10
20
30
20 15 15
25
10
20 15 10
25 20
Amount (in ‘00 pounds)
Amount (in ‘00 pounds)
Scatter plot: A scatter plot is a graphical tool that shows the connection between two
numerical aspects. A normal probability plot is composed of an X axis (the horizontal axis), a Y
axis (the response variable), and a number of lines. Every dot on the scatter plot is a single
measurement from a collection of data. The dot's location on the scatter plot reflects the
meanings X and Y.

0 2 4 6 8 10 12
0
5
10
15
20
25
30
20
15 15
25
10
20
15
10
25
20
Amount (in ‘00 pounds)
Amount (in ‘00 pounds)
3. Calculation of different aspects
Mean: One mean is the precise statistical combination of two or more parts in a series. The
means could be determined in far more for one form for a certain sequence of figures, along with
the weighted arithmetic method that uses the amount of the figures in the sequence, and the mean
absolute system which seems to be the average of the absolute of items. Nevertheless, much of
the time, all the supported by the theory of estimating a basic average yield the same estimated
performance (O’Connor, Kvalsvig and Goldfeld, 2019).
Month Type of bill Amount (in ‘00 pounds)
January Electricity bill 20
February Telephone bill 15
March Water bill 15
April Bank statement 25
May Internet bill 10
June Council taxation bill 20
July Heating bill 15
August Rental charges or bill 10
September Grocery bill 25
October Transportation bill 20
Total 175

Mean = Sum of all values/number of values
= 175/10
= 17.5
Mode: In mathematics, mode is the number that frequently occurs in a specified range.
We may also claim the quality or amount in a set of data is named mode which has a greater
incidence or occurs more commonly. It is one of the key proclivity-measuring methods. Its other
two are average and standard processes. A collection of variables may have one or maybe more
mode, or even no mode whatsoever.
Month Type of bill Amount (in ‘00 pounds)
January Electricity bill 20
February Telephone bill 15
March Water bill 15
April Bank statement 25
May Internet bill 10
June Council taxation bill 20
July Heating bill 15
August Rental charges or bill 10
September Grocery bill 25
October Transportation bill 20
Total 175
The term 15 has higher frequency thus, mode is 15.
Median: The mid number is the median. The figures have already been mentioned in
sequential order in this instance so don't need to update the table. However there is no "upper"
amount and that there are even amounts. Regardless of this, the index median would be the mean
(i.e., the normal average) of the upper two quantities inside the chart (Hirsch, Coppens and
Moeller, 2018).

Month Type of bill Amount (in ‘00
pounds)
January Electricity bill 10
February Telephone bill 10
March Water bill 15
April Bank statement 15
May Internet bill 15
June Council taxation bill 20
July Heating bill 20
August Rental charges or bill 20
September Grocery bill 25
October Transportation bill 25
Total
Higher value = 25
Lower value = 10
Range = 25-10
= 15
Range: It is measured as the change between the significance stronger and the value less.
The range score is considered in the scenario provided earlier in this thread.
Higher value= 25
Lower value= 10
Range= 25-10
= 15
Standard deviation: Standard deviation is calculation of the distribution from its mean
of a group of statistics. The actual uncertainty of a variance is measured; the bigger the variation

or variation, the stronger the sample variance and the stronger the extent of the variance of the
variable from its standard.
Month Type of bill Amou
nt (in
‘00
pound
s)
x-m (x-
m) 2
January Electricity
bill
15
-2.5 6.25
February Telephone
bill
20
2.5 6.25
March Water bill 25
7.5
56.2
5
April Bank
statement
15
-2.5 6.25
May Internet bill 20 2.5 6.25
June Council
taxation bill
10
-7.5
56.2
5
July Heating bill 10
-7.5
56.2
5
August Rental
charges or
bill
15
-2.5 6.25
Septemb
er
Grocery bill 20
2.5 6.25
October Transportati
on bill
25
7.5
56.2
5
262.
5

Variance = [∑(x – mean) 2 / N]
= (262.5/10)
= 26.25
Standard deviation: √ (variance)
= √26.25
= 5.12
1. linear forecasting model which is y = mx + c in order to do below mentioned
calculations:
 Calculation of value m:
Y= mx+c
m= n (∑xy) - (∑x) (∑y)/ n(∑x2)-( ∑x)2
Number
of
month
(x)
Amount
(y)
x2 xy
1 15 1 15
2 20 4 40
3 25 9 75
4 15 16 60
5 20 25 100
6 10 36 60
7 10 49 70

8 15 64 120
9 20 81 180
10 25 100 250
55 175 385 970
= 10(970)-(55)*(175)/10(385) -(55) 2
= 9700- 9625/3850-3025
= 75/825
0.09
Calculation of c:
c= [(∑y) / n]-m(∑x/n)
= (175/10)-0.09(55/10)
= 17.5-0.49
= 17.01
 Forecast the expenses for month 12 and 14:
Forecasting for month 12:
Y = mx+c
= 0.09*12+17.01
= 1.08+17.01
= 18.09
Forecasting for month 14:
= 0.09*14+17.01
= 1.26+17.01

= 18.27
CONCLUSION
As per the above report it has been concluded that to analysis the business activities
require to conduct data analysis. It helps to understand the business activities in proper manner
and calculate different aspects. In this report take 10 bill payments and calculate mean, mode,
median and other aspects.

REFERENCES
Books and Journal
Phillipson, S., Phillipson, S. N. and Kewalramani, S., 2018. Cultural variability in the
educational and learning capitals of Australian families and its relationship with
children’s numeracy outcomes. Journal for the Education of the Gifted. 41(4). pp.348-
368.
Saptono, L., Soetjipto, B. E. and Wahyono, H., 2019. The Influence of Financial Quantitative
Literacy and Subjective Numeracy on Impulsive Consumption with Materialism as the
Mediator Variable. Indian Journal of Marketing. 49(10). pp.23-41.
O’Connor, M., Cloney, D., Kvalsvig, A. and Goldfeld, S., 2019. Positive mental health and
academic achievement in elementary school: new evidence from a matching
analysis. Educational Researcher. 48(4). pp.205-216.
Hirsch, S., Lambert, K., Coppens, K. and Moeller, K., 2018. Basic numerical competences in
large-scale assessment data: Structure and long-term relevance. Journal of experimental
child psychology. 167. pp.32-48.