Data Analysis and Forecasting

Data Analysis and
Forecasting

Table of Contents
INTRODUCTION...........................................................................................................................1
MAIN BODY...................................................................................................................................1
1. Data in table format.................................................................................................................1
2. Using two types of chart.........................................................................................................1
3. Calculation and highlight final value......................................................................................2
4. Linear forecasting model.........................................................................................................5
CONCLUSION................................................................................................................................7
REFERENCES................................................................................................................................8

INTRODUCTION
Forecasting is a procedure of making assumptions of the future based on past and present
data and most ordinarily by investigation of trends. In can context, data must be updated in order
to predict to accurate and possible things in future In many cases data predict for the variable of
interest is itself forecast (Zhang and et.al, 2019). To conduct any business activities require to
analysis data to carry out all important information that supports in decision making procedure in
business. This report based on the total expenses per month. For the analysis of such expenses
use different techniques of data analysis like mean, mode, median and standard deviation.
MAIN BODY
1. Data in table format
Month Monthly
Expenses
Jan 5000
Feb 12000
March 8000
April 7000
May 4000
June 6000
July 5000
Aug 15000
Sep 10000
Oct 9000
2. Using two types of chart
Column chart: This chart is used to compare values of data from various categories that
compare data in specified period of time. Since all column begin from the same baseline of 0 and
it is simple to compare of columns against each other. For the understanding of changes require
1

to presenting data in proper manner. In an entity the owner wants to compare their profits of
different department so for this prepare of this budget that helps to present profitability and
analysis easily (Ahmad and Chen, 2018).
Ja n
Ma rc h
Ma y
July
S ep
0 2000 4000 6000 8000 10000 12000 14000 16000
5000
12000
8000
7000
4000
6000
5000
15000
10000
9000
M o n t h ly E x p e n s e s
Monthly E x pe ns e s
Bar chart: This chart represents the collection of data using rectangular bars and presents
the comparison between discrete categories. It is mainly using with vertical columns,
comparative bars and staked bars. In this chart represents financial analysis of displaying data
that depicts profitability distribution of data as sample.
Ja n Fe b Ma rch April Ma y June July Aug S ep
0
2000
4000
6000
8000
10000
12000
14000
16000
5000
12000
8000 7000
4000
6000 5000
15000
10000
M o n t h ly E x p e n s e s
Monthly E x pe ns e s
2