Data Analysis and Numeracy Assignment Solution - [Course Name]

This assignment solution focuses on numeracy and data analysis, presenting a step-by-step approach to understanding and interpreting data. The document begins with arranging data on bill payments over ten days and then proceeds to create column and bar charts to visualize the data. It includes detailed calculations of key statistical terms such as mean, median, mode, range, and standard deviation. Furthermore, it applies a linear forecasting model (y=mx+c) to predict future bill payments. The solution also provides a conclusion summarizing the importance of data interpretation and its application in strategic decision-making, alongside a list of references. This comprehensive approach allows for a complete understanding of the data analysis process.

Numeracy and Data Analysis

INTRODUCTION...........................................................................................................................1
MAIN BODY..................................................................................................................................1
1. Arrange the available data.......................................................................................................1
2. Produce Column or Bar chart by using above mention data...................................................1
3. Calculate the following terms..................................................................................................3
4. Calculate y=mx+c by using linear forecasting model.............................................................5
CONCLUSION................................................................................................................................7
REFERENCES................................................................................................................................8

INTRODUCTION
Data analysis is a process of collecting and manipulating data which allows organizations to
gain useful knowledge (Kombi, 2018). It help the managers of researchers to formulate strategies
to improve the overall efficiency according to the requirement. In other words, data analysis is
mainly intended to examine what information relies on perception, which it may require. The
research focuses mainly on data processing, in which data are related to ten days
consecutive payment of different bills. A large number of measurements such as mean, phase,
medium, and forecasts are also included in the project report.
MAIN BODY
1. Arrange the available data
Days Type of bill payment Amount (in ‘00 pounds)
1 Bank payment bill 10
2 Rental charges bill 7
3 Electricity bill 15
4 Internet bill 20
5 Transportation bill 18
6 Grocery bill 15
7 Telephone bill 16
8 Water bill 9
9 water bill 9
10 Council taxation bill 8
2. Produce Column or Bar chart by using above mention data
Column Chart:
It is a graphical representation which represent the bill payment of for regular ten days.
Column chart display the number of bill payments on each single day until next ten days
(Pensiero and Green, 2018). Below mention graph provide better understanding:
1

Above mention graoh helps in repareseting the highest number of bill paymnet on 4th day
and iot also shows the fluctuation as well in the payment of bills from last 10 days.
Bar Chart:
It is graph which shows the numerical figures, with rectangular lines compared
to different ranges. The bar chart below shows the various payments of bills for different days:
.
2

3. Calculate the following terms
Days Amount (in ‘00 pounds)
1 10
2 7
3 15
4 20
5 18
6 15
7 16
8 9
9 9
10 8
3

Mean 12.7
Median 12.5
Mode 15
Maximum 20
Minimum 7
Range 13
Mean: Its most popular phrase for an average is a standardized measurement of a single
specific sample which would be the total number of all variables (Soler-Hampejsek And et.al.,
2018). To evaluate this, incorporate and split down the significances of both words in a
multitude ways. The average score of the payment of bills is evaluated below:
Formula:
Mean= Sum of all observations /number of observations
= 127 /10
= 12.7
Median Within the series of numbers, even if there's no number and no element in the
series, the "median" is the observer's middle value. It is determined according to a formula:
Formula:
When data set is even= {N/2th item + N/2th item + 1}2
When data set is odd= (N+1) /2th item.
Total observation is N= 10
M= (10/2th item + 10/2th item + 1)/2
= (5th item+ 6th item)/2
= 5.5th item
= 12.5
Mode: This is the value which is repeated the most in the available series. Mode of the
series mentioned below:
Mode = 15
Range: It is the difference between maximum or minimum value of the series and its
calculation mentioned below:
4

Formula:
Range = Max - Min
Higher Value = 20
Lower Value = 7
Range of the series is 13.
Standard deviation: The numbers are being used to measure the range of mean or expected
age (Vetter And et.al., 2018). Many predictions are unlikely to be anything less than average. In
numbers high standard deviations is more reliably expressed. The prediction will be as follows:
Formula:
SD = √ [∑(x – mean) 2 / N]
Days Type of bill Amount (in ‘00 pounds)
(X)
(X-
Mean)
(X-
Mean)^2
1 Bank payment bill 10 -5.6 31.36
2 Rental charges bill 7 -8.6 73.96
3 Electricity bill 15 -0.6 0.36
4 Internet bill 20 4.4 19.36
5 Transportation bill 18 2.4 5.76
6 Grocery bill 15 -0.6 0.36
7 Telephone bill 16 0.4 0.16
8 Water bill 9 -6.6 43.56
9 water bill 9 -6.6 43.56
10 Council taxation bill 8 -7.6 57.76
276.2
S.D = √ (276.2)/10
= √ 27.62
= 5.25
4. Calculate y=mx+c by using linear forecasting model
Step 1: Prepare table
Number of Days Amount (Y) X2 XY
5

(X)
1 10 1 10
2 7 4 14
3 15 9 45
4 20 16 80
5 18 25 90
6 15 36 90
7 16 49 112
8 9 64 72
9 9 81 81
10 8 100 80
∑ 55 ∑ 127 ∑ 385 ∑ 674
Step 2: Calculation of the value of M:
Formula:
M = [ N ∑XY - ∑x ∑y ] / [ N ∑X2 - (∑x)2 ]
= [ 10 * 674 – (55 * 127) ] / [10*385- (55)2 ]
= [6740 – 6985] / [3850 – 3025]
= -245 / 825
= -0.29
Step 3: Calculation of value of C:
Formula: C = {∑y - m ∑x} / N
= (127 – {-0.29 * 55}) / 10
= (127 + 15.95) / 10
= 142.95 / 10
= 14.29
Step 4: Number of bill payments on 12th Month:
Formula: Y = mx + c
= -0.29 * 12 + 14.29
= -3.48 + 14.29
= 10.81
6

Step 5: Number of bill payments on 14th Month:
Formula: Y = mx + c
= -0.29 * 14 + 14.29
= -4.06 + 14.29
= 10.23
CONCLUSION
The findings suggest that data interpretation is too important to determine the particular
result of data sets compilation. This research identified different properties such as mean, mode,
median, and many more. Additionally the linear method to predict the amount of bills paid for
the 12 and 14 days. These methods used by the organizations to measure the different types of
data. Finding of these calculations helps the company’s managers to make strategic decisions and
further implemented in order to maximise the overall efficiency as well as effectiveness.
7

REFERENCES
Books & Journals
Komba, A. A., 2018. Financing Mechanisms for Pre-Primary Education and Their Implications
for Equity and Children’s Literacy and Numeracy Development in Tanzania.
Pensiero, N. and Green, A., 2018. The effects of post‐compulsory education and training systems
on literacy and numeracy skills: A comparative analysis using PISA 2000 and the 2011
survey of adult skills. European Journal of Education. 53(2). pp.238-253.
Soler-Hampejsek, E. And et.al., 2018. Reading and numeracy skills after school leaving in
southern Malawi: A longitudinal analysis. International Journal of Educational
Development. 59. pp.86-99.
Vetter, M. And et.al., 2018. Learning “math on the move”: effectiveness of a combined
numeracy and physical activity program for primary school children. Journal of Physical
Activity and Health. 15(7). pp.492-498.
8