Wind Speed Analysis: A 10-Day Study in Cairo, Egypt

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

Table of Contents
Introduction...............................................................................................................................................2
Answers......................................................................................................................................................3
1...............................................................................................................................................................3
2...............................................................................................................................................................4
3...............................................................................................................................................................6
4...............................................................................................................................................................8
Conclusion................................................................................................................................................10
References................................................................................................................................................11
Table of Figures
Figure 1 Area Chart.....................................................................................................................................4
Figure 2 Bar Chart.......................................................................................................................................4
Figure 3 Line Chart for Linear Forecasting.................................................................................................8
Tables
Table 1 Table of Data..................................................................................................................................3
Table 2 Table of operations.........................................................................................................................6
Table 3 Table of predictions........................................................................................................................8

Introduction
This report is based on the data analysis techniques which will be used in the assignment. The
requirements of the assignment demands a research of wind speed for 10 consecutive days of any
city or town. The data collected will then be processed to produce a desired output which is
mentioned in the assignment. The analysis will be done by calculating the mode, the median, the
range, the mean and the standard deviation of the data. The data will also be presented in
graphical way for simple understanding. The data will also generated a linear forecasting model
which will provide a way to predict the wind speed theoretically of the future days.

Answers
1.
The information for 10 consecutive days of the wind speed is fetched from the capital of Egypt
i.e. Cairo. The Cairo is the capital of Egypt country. The data is fetched using online sources.
The data is entered in table in excel. The data is presented below:
Table 1 Table of Data
This result is presented in tabular format. The dates of consideration are mentioned in the figure
i.e. from 28th August, 2019 to 06th September, 2019 where 28th August, 2019 is the 1st day and
06th September, 2019 is the last day for consideration. There are 4 time periods in a day and each
time period has its own wind speed therefore, average speed was calculated for the day which
includes all the 4 wind speeds in a day.

2.
The figures below represents the data using graphs in excel.
1 2 3 4 5 6 7 8 9 10
0
2
4
6
8
10
12
14
16
Cairo, Egypt (28-08-209 to 06-09-2019)
Day
Wind Speed (Km/h)
Figure 1 Area Chart
This is the visual representation of data using an area chart. This chart shows the data which was
collected earlier. The y axis represents the wind speed in km/h whereas the x axis represents the
days where 1st day represents 28th September, 2019 and the next numbering goes on.
1
2
3
4
5
6
7
8
9
10
0 2 4 6 8 10 12 14 16
Cairo, Egypt (28-08-209 to 06-09-2019)
Day
Wind Speed (Km/h)
Figure 2 Bar Chart

This is the visual representation of data using an bar chart. This chart shows the data which was
collected earlier. The y axis represents the wind speed in km/h whereas the x axis represents the
days where 1st day represents 28th September, 2019 and the next numbering goes on.

3.
Below mentioned is the table of operations. The table presents the values that are calculated
using various formulas to produce an optimal results for the requirements that are given in the
assignment. The table consists result of all the question that were asked to perform in the
assignment. Adding up, slope and the intercept is also calculated using the data in the table.
Table 2 Table of operations
The formulas which are used for the calculated are as follows:
For calculating mean, “=AVERAGE(B:B)” where first B is the first value of the set and the
second B is the last value of the entire set.
For calculating median, “=MEDIAN(B:B)” where first B is the first value of the set and the
second B is the last value of the entire set.
For calculating range, “=MAX(B:B)-MIN(B:B)” where first B is the first value of the set, the
second B is the last value of the entire set, MAX function is used for finding the maximum value
in the set and MIN function is used for finding the minimum value in the set.
For calculating mode, “=MODE.MULT(B:B)” where first B is the first value of the set and the
second B is the last value of the entire set.
For calculating standard deviation, “=STDEV(B:B,A:A)” where B represents the first number
for data set for y and A represents the second number for data set for x.’
For calculating intercept, “INTERCEPT(B:B,A:A)” where B represents the data set for y and A
represents the data set for x.

For calculating slope, “=SLOPE(B:B,A:A)” where B represents the data set for y and A
represents the data set for x.

4.
This is a line chart which represents the data which is obtained from the research. According to
the data, a trend line is generated in the form of y=mx+c. This line represents the relationship
between the two axes and presents a pattern and direction of the data. This line is used for future
predicts of the data.
Figure 3 Line Chart for Linear Forecasting
According to the figure, the equation is y = -0.0788x + 12.933
Taking reference from equation of straight line i.e. y=mx+c where m is the slope and c is the
intercept, it is clearly shown that the slope is -0.0788 and the intercept is 12.933.
Table 3 Table of predictions
The figure above presents the predictions which were calculated using the equation which is
generated by the researched data. The formula which is used for the prediction of data is,
1 2 3 4 5 6 7 8 9 10
0
2
4
6
8
10
12
14
16
f(x) = − 0.0787878787878788 x + 12.9333333333333
Cairo, Egypt (28-08-209 to 06-09-2019)
Day
Wind speed (Km/h)

“=ROUND(INTERCEPT+(SLOPE*NUMBER OF DAYS),0)” where round function is used for
rounding off the result.

Conclusion
The report encompasses of all the data analysis techniques which were used to process the data
and produce the required outputs. The requirement of the assignment has been duly completed
and the evidence is mentioned in the report. The assignment helped in understanding the
concepts of data analysis and provided a clear headed and better vision to analyze other things.
The description for all the formulas used are provided in the report. The presentation of the data
is clear and accurate. The concepts used in the successful completion of the assignment are
mentioned clearly.

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).
Rayat, C.S., 2018. Applications of Microsoft Excel in Statistical Methods. In Statistical Methods
in Medical Research (pp. 139-146). Springer, Singapore.