Data Analysis & Forecasting

Data Analysis &
Forecasting

Contents
INTRODUCTION.....................................................................................................................................3
MAIN BODY.............................................................................................................................................3
1.Entering data in table............................................................................................................................3
2. Presenting data in two types of chart...................................................................................................3
3. Calculation:.........................................................................................................................................4
4. Linear forecasting method...................................................................................................................9
CONCLUSION........................................................................................................................................11
REFERENCES........................................................................................................................................12

INTRODUCTION
In different kinds of businesses, there are numerous transactions are done which can be
financial and non-financial. Due to financial transactions, different data are collected for
analysis. In this aspect, data analysis technique plays a key role that is related to assessing all
types of financial data so that final outcome can be derived (Cole and Trinh, 2017). The report is
based on implementation of various data analysis techniques in regards to number of phone calls
made in ten consecutive days. In this report different statistical values are calculated like mean,
median, standard deviation etc. on the basis of data of phone calls. In the end of report
forecasting of number of phone calls for different days has been in accordance of linear
programming method.
MAIN BODY
1. Entering data in table.
Number of day Phone calls
1 12
2 15
3 17
4 20
5 25
6 12
7 18
8 20
9 12
10 27
2. Presenting data in two types of chart.
There are a range of charts and graphs which are used for presenting data. These charts
make data visualization more effective and attractive. The above mentioned data of
phone calls are presented in form of such charts:

Line chart- It is a kind of chart in which data are shown in a zig zag line. This line raise
and fall in accordance of nature of data.
1 2 3 4 5 6 7 8 9 10
0
5
10
15
20
25
30
12
15 17
20
25
12
18 20
12
27
Phone calls
Column Chart-This is defined as a form of chart under which data are presented in
vertical columns or pillars (Dimitriadis, Patton and Schmidt, 2019). Similar to above
chart, height of these columns depends on nature of data set.
Phone calls
0
5
10
15
20
25
30
12
15 17
20
25
12
18 20
12
27
PHONE CALLS
1 2 3 4 5 6 7 8 9 10
3. Calculation:
Mean- This is defined as a term of statistics which is computed with an aim of finding
middle value of data set. Below steps for calculating mean of above phone calls data are
mentioned in such manner: