Data Analysis and Forecasting of Bill Payments

Numeracy and data
analysis

Contents
INTRODUCTION...........................................................................................................................2
MAIN BODY..................................................................................................................................2
CONCLUSION................................................................................................................................9
REFERENCES..............................................................................................................................10

INTRODUCTION
The data analysis is a data collection and processing method, which allows everyone to
obtain valuable knowledge. In other terms, data analysis is mainly meant to examine what data is
dependent upon interpretation, whatever it seeks to tell others (Landtblom, 2018). This report is
mostly about data collection, where data is related to bill payment of different months. Under the
project report, vital range of calculations is done such as mean, mode, median as well as
forecasting is also done.
MAIN BODY
1. Arrangement of the data in a table format.
Month Type of bill Amount (in ‘00 pounds)
January Electricity bill 15
February Telephone bill 20
March Water bill 25
April Bank statement 15
May Internet bill 20
June Council taxation bill 10
July Heating bill 10
August Rental charges or bill 15
September Grocery bill 20
October Transportation bill 25
2. Presentation of the data using any two types of charts.
Column chart- A column diagram is a graphical representation where the height of the
row proportionate to the values displayed is represented by a row for each segment. Often
known as vertical bar charts are column displays.

Electricity bill
Telephone bill
W ater bill
Bank statement
Internet bill
Council taxation bill
Heating bill
Rental charges or bill
Grocery bill
Transportation bill
January Februar
y March April May June July August Septem
ber Octobe
r
0
10
20
30
15 20 25
15 20
10 10 15 20 25
Amount (in ‘00 pounds)
Amount (in ‘00 pounds)
Bar chart- A bar chart or bar graph is a graph displaying categorical statistics with rectangular
lines that are proportionate to their heights or distances. The bars are either horizontal or vertical
(Beyer, 2019).