Data Analysis and Forecasting of Wind Speed in Havana, Cuba

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

Table of Contents
Introduction...............................................................................................................................................2
Solution......................................................................................................................................................3
Conclusion..................................................................................................................................................6
References..................................................................................................................................................7
Tables
Table 1 Data................................................................................................................................................3
Table 2 Operations......................................................................................................................................3
Table 3 Prediction table...............................................................................................................................5
Table of Figures
Figure 1 Bar graph.......................................................................................................................................4
Figure 2 Line graph.....................................................................................................................................4
Figure 3 Linear forecasting model...............................................................................................................5

Introduction
In this report, the assignment requirements are fulfilled. The scenario demands a research of 10
consecutive days for any city in the work for collecting their wind speed. After the collection, the
assignment demands data analysis using functions like mean, median, range, standard deviation,
etc. The assignment also mentions the requirement for predicting the wind speed for 14th and 21st
day according to the linear forecasting model.

Solution
The weather reports from the capital of Cuba i.e. Havana is being considered for the data
analysis. The wind speed details throughout the data is being considered. The information is via
reliable internet resources and are genuine. The table below represents the average data speed in
km/h for the past 10 days.
Table 1 Data
Table 2 Operations
The above table is the evidence of the operations performed on the data fetched from the
available resources. The table mentions all the operations which were required to be performed
in the assignment such as mean, median, range, mode, standard deviation, slope and intercept.

1 2 3 4 5 6 7 8 9 1 0
13
15
12
9
7
5
7
10
11
14
Havana, Cuba (10-09-209 to 19-09-
2019)
Days
SPEED (KM/H)
Figure 1 Bar graph
This graph above represents the relationship between the days and the average wind speed of the
data fetched using the internet sources.
0 2 4 6 8 10 12
0
2
4
6
8
10
12
14
16
Havana, Cuba (10-09-209 to 19-09-2019)
Days
Speed (Km/h)
Figure 2 Line graph
This graph above is the line graph which represents the relationship between the days and the
average wind speed of the data fetched using the internet sources.

1 2 3 4 5 6 7 8 9 10
0
2
4
6
8
10
12
14
16
13
15
12
9
7
5
7
10 11
14
f(x) = − 0.224242424242424 x + 11.5333333333333
Havana, Cuba (10-09-209 to 19-09-2019)
Days
Speed (Km/h)
Figure 3 Linear forecasting model
This graph shows the forecasting predictions using Trendline function in excel. The linear
equation is used for the predictions related to the wind speed.
y = -0.2242x-11.533
The basic line equation is y=mx+c where m is the slope and c is the intercept.
Here, slope is -0.2242 and the intercept is 11.533.
Table 3 Prediction table
The table above presents the prediction of 14th and 21st day using the equation above.

Conclusion
The report fulfills all the requirements mentioned in the assignment. The data is being collected
which is mentioned in the report. The data analysis operations were performed and the table is
mentioned in the report. The predictions using the linear forecasting model are also calculated
and presented in the report. All the tasks are completed successfully.

References
Bree, R.T. and Gallagher, G., 2016. Using Microsoft Excel to code and thematically analyse
qualitative data: a simple, cost-effective approach. AISHE-J: The All Ireland Journal of Teaching
and Learning in Higher Education, 8(2).
Patten, M.L. and Newhart, M., 2017. Understanding research methods: An overview of the
essentials. Routledge.