Data Analysis and Forecasting: A Comprehensive Report

Desklib provides solved assignments and past papers to help students succeed.

DATA ANALYSIS AND FORECASTING
1

Table of Contents
Main Body..................................................................................................................................2
References..................................................................................................................................6
Table of Figures
Figure 1: Weather Data..............................................................................................................2
Figure 2: Pictograph (Vertical)..................................................................................................2
Figure 3: Pictograph (Horizontal)..............................................................................................3
Figure 4: Calculated Data...........................................................................................................3
Figure 5: Forecasted Data..........................................................................................................5
2

Main Body
In the first part, the data of the weather is entered in the form of the tables. The data shown
below in the form of the table is of the city of Kingston. The data is of 10 consecutive days in
the month of January.
Figure 1: Weather Data
The next part contains the visualization of the data in the form of the charts. The below-
shown charts are the pictographs one is the horizontal one and the other one is vertical. The
Pictographs are represented as:
Pictograph (Vertical)
3

Figure 2: Pictograph (Vertical)
The above-shown pictograph is based on the humidity noticed on each day for 10 consecutive
days (Frownfelter-Lohrke, C., 2017). The X-axis here represents the days whereas the Y-axis
represents the humidity.
Pictograph (Horizontal)
4

Figure 3: Pictograph (Horizontal)
The above-shown pictograph is based on the barometer noticed on each day for 10
consecutive days. The X-axis here represents the Barometer values whereas the Y-axis
represents the Days.
The third part contains the calculations of the various requirements. The calculated values
are:
Figure 4: Calculated Data
5

1. Mean
Step No. 1 – Selection of the Data is done here.
Step No. 2- Writing the Formula that has to be used.
=Average (number1, number2…)
Temperature = -15
Wind = 10.5
Humidity = 0.784
Barometer = 1026.7
Visibility = 13.5
2. Median
Step No. 1 – Selection of the Data is done here.
Step No. 2- Writing the Formula that has to be used.
=Median (number1, number2…)
Temperature = -12.5
Wind = 6.5
Humidity = 0.835
Barometer = 1028
Visibility = 16
3. Mode
Step No. 1 – Selection of the Data is done here.
Step No. 2- Writing the Formula that has to be used.
=Mode (number1, number2…)
6

Temperature = -11
Wind = 4
Humidity = 0.88
Visibility = 16
4. Range
Step No. 1 – Selection of the Data is done here.
Step No. 2- Writing the Formula that has to be used.
For Low Range
=Min (number1, number2…)
For High Range
=Max (number1, number2…)
Temperature (LR) = -26
Temperature (HR) = -11
Wind (LR) = 2
Wind (HR) = 30
Humidity (LR) = 0.5
Humidity (HR) = 0.9
Barometer (LR) = 1017
Barometer (HR) = 1035
Visibility (LR) = 2
Visibility (HR) = 16
5. SD
Step No. 1 – Selection of the Data is done here.
Step No. 2- Writing the Formula that has to be used.
=stdev (number1, number2…)
Temperature = 5.20
7

Wind = 9.50
Humidity = 0.155
Barometer = 6.42
Visibility = 5.31
The fourth part is the last part that further includes some of the sub-parts-
a). The first part contains the calculation of the x value. Here, the x value is considered as the
temperature of all the ten consecutive days (Häcker, J. and Ernst, D., 2017). It is being used
in the forecast formula in order to calculate the temperature for the coming days.
b). The second part explains the C value that is considered to be constant. Value of C can also
be zero.
c). The third part contains the calculation of the temperature on the 15th day as well as on the
23rd day of the January month using the formula:
=forecast(x, known x’s values, known y’s values)
Figure 5: Forecasted Data
8

References
Häcker, J. and Ernst, D., 2017. Workshop Excel Part II. In Financial Modeling (pp. 143-201).
Palgrave Macmillan, London.
Frownfelter-Lohrke, C., 2017. Teaching good Excel design and skills: A three spreadsheet
assignment project. Journal of Accounting Education, 39, pp.68-83.
9