Data Analysis and Forecasting

Data Analysis and Forecasting

Table of Contents
1. Arrange the data in table format..................................................................................................3
2. Present the data in column and bar chart.....................................................................................3
3. Calculation of mean, median, range and standard deviation.......................................................4
i. Mean.........................................................................................................................................4
ii. Median.....................................................................................................................................5
iii. Mode.......................................................................................................................................5
iv. Range......................................................................................................................................6
v. Standard deviation...................................................................................................................6
4. Calculation based on y = mx + c.................................................................................................7
i. Calculation of m.......................................................................................................................8
ii. Calculation of c........................................................................................................................8
iii. Calculation for 12th and 14th day number of calls...................................................................8
References......................................................................................................................................10

Introduction
The given project assignment contains data analyses of random phone calls over 10 consecutive
days. These phone calls data has been analyzed based on various methods such as mean, median,
mode, range and standard deviation. The regression model has been used to predict the phone
calls on 12th and 14th day.
1. Arrange the data in table format
1 Phone calls
Day
s Phone calls
1 80
2 81
3 75
4 65
5 90
6 82
7 79
8 76
9 81
10 83
2. Present the data in column and bar chart
Column chart:

1 2 3 4 5 6 7 8 9 10
0
10
20
30
40
50
60
70
80
90
100
Phone calls
Phone calls
Line chart:
1 2 3 4 5 6 7 8 9 10
0
10
20
30
40
50
60
70
80
90
100
Phone calls
Phone calls
3. Calculation of mean, median, range and standard deviation
i. Mean
Definition: There are different types of means in mathematics, especially in statistics. For the
information index, the arithmetic mean, also known as expected value or average, is the central
value of a particular arrangement of numbers: obviously, the sum of the values divided by the
number of values (Daraganova, Edwards and Sipthorp, 2013).
Days Phone calls