Numeracy and Data Analysis

Numeracy and Data Analysis
INTRODUCTION...........................................................................................................................3
MAIN BODY..................................................................................................................................3
1. Arrangement of data................................................................................................................3
2. Using above arranged data represent two different charts.......................................................3
3. Calculate the following terms..................................................................................................5
4. Calculate y=mx+c by using linear forecasting model.............................................................7
CONCLUSION................................................................................................................................9
REFERENCES..............................................................................................................................10
1

INTRODUCTION
Data processing is a process of collecting and analysing data that helps us to gain valuable
information (Friese, 2019). Data analysis is mainly supposed to examine what information relies
on perception, whatever it might entail. The research focuses mainly on data processing, wherein
data are related to multi-month bill payment.
In this project, data is arrange into table, chart are drawn, calculation of Mean, Median,
Mode, Range and Standard Deviation. In addition, y = mx + c is use to define the value of m, C
and forecast the expenses for day 12 and day 14.
MAIN BODY
1. Arrangement of data
Months Type of bill Amount (in ‘00 pounds)
January Telephone bill 15
February Water bill 7
March Council taxation bill 22
April Rental charges or bill 15
May Bank statement 20
June Internet bill 15
July Transportation bill 10
August Grocery bill 25
September Electricity bill 7
October Heating bill 7
total 143
2. Using above arranged data represent two different charts
Column Chart:
Column chart is a graph by which the row viewpoint is articulated in such a line
approximately equal to the principles shown for each segment. Column views are also known as
charts with vertical lines. Payment of specific month's bill is listed below:
2

Telephone bill
Water bill
Council taxation bill
Rental charges or bill
Bank statement
Internet bill
Transportation bill
Grocery bill
Electricity bill
Heating bill
0
5
10
15
20
25
30
Bar Chart:
Graphs are a chart displaying numerical numbers, with vertical lines referring to their
rates or ranges (Landtblom, 2018). The bars can be of vertical or horizontal shape. The bar graph
below shows the various amounts of bills.
Telephone bill
Water bill
Council taxation bill
Rental charges or bill
Bank statement
Internet bill
Transportation bill
Grocery bill
Electricity bill
Heating bill
0 5 10 15 20 25 30
3. Calculate the following terms
Months Amount (in ‘00 pounds)
January 15
February 7
March 22
April 15
May 20
3