Comprehensive Data Analysis and Forecasting Project: London Wind Speed

This project provides a detailed analysis of London's wind speed over a 10-day period in October 2019. The analysis begins with presenting the data in a tabular format, followed by visual representations using column and bar charts. Descriptive statistics, including mean, median, mode, range, and...Read More

Project on data analysis
and forecasting
1

Table of Contents
INTRODUCTION...........................................................................................................................3
1) Data in table format.................................................................................................................3
2) Chart types...............................................................................................................................3
3) Calculate the values.................................................................................................................4
4) Use linear forecasting model...................................................................................................5
1) Steps for calculating m value..................................................................................................6
2) Steps for calculating c value....................................................................................................6
3) Forecasting m and c value for day 14 and 21..........................................................................6
CONCLUSION................................................................................................................................7
REFERENCES................................................................................................................................8
2

INTRODUCTION
Numeracy and data analysis are very important in this present generation as it shows
capability for understanding numerical analysis. The present report is giving brief analysis of
wind speed of London of 10 days as it is gathered through authentic online sources. The data will
be analysed in tabular format and reflected in visual presentation as column and line chart. In the
same series, this will provide description of speed of wind with help of descriptive analysis such
as mean, median, mode and standard deviation in detail manner. It will represent about linear
forecasting model was Y = mX + c with calculation m, c along with forecast of day 14 and 21.
1) Data in table format
In this the wind speed of city of London is taken for next 10 days which is as follows :-
Date Wind Speed
5 Oct 19 13km/h
6 Oct 19 22km/h
7 Oct 19 13km/h
8 Oct 19 25km/h
9 Oct 19 19km/h
10 Oct 19 23km/h
11 Oct 19 20km/h
12 Oct 19 34km/h
13 Oct 19 12km/h
14 Oct 19 20km/h
2) Chart types
Column chart
3

Bar chart
3) Calculate the values
There are certain steps followed in order to calculate values in excel. They are defined
below :-
Mean = 20.1
4

Step 1- write all values in excel and below that write the formula for mean that is = Average
(values)
Step 2- Select the values for which mean is to be calculated.
Step 3- After selecting press enter key
Median= 20
Step 1- Write formula for median below the values that is = median (values)
Step 2- Select the values for which median is to be calculated
Step 3- Press enter key after selecting values
Mode = 13
Step 1- Open excel and write all values in it.
Step 2- Write formula of mode below the values = mode (values)
Step 3- Select the column to calculate answer
Step 4- Press enter key to generate result
Range = 22
Step 1 – In excel note down all values
Step 2- Write formula for range which is = max (value) – min (value)
Step 3- Select column for which range is to be calculated
Step 4 – Press enter key
Standard deviation -6.64
Step 1- Open excel and insert values in it.
Step 2 – Write formula for standard deviation below it which is = Stdev (value)
Step 3- After pressing enter key note down the answer
It can be analyzed from statistics that mean value of wind speed is 20.1 km/h. The
median value is 20 km/h which is similar to mean. However, mode of data is 13 that is repeated
2 times. Moreover, range is 22 and standard deviation is 6.64.
4) Use linear forecasting model
Days Days (x) Wind speed (in km/h) XY X^2
05/10/19 1 13 13 1
06/10/19 2 22 44 4
07/10/19 3 13 39 9
5

08/10/19 4 25 100 16
09/10/19 5 19 95 25
10/10/19 6 23 138 36
11/10/19 7 20 140 49
12/10/19 8 34 272 64
13/10/19 9 12 108 81
14/10/19 10 20 200 100
Total 55 201 1149 385
a) Steps for calculating m value
Particulars Details
m NΣxy – Σx Σy / NΣ x^2 – (Σx)^2
(10 * 1149) – (55 * 201) / (10 * 385) – (55)^2
(11490-11055 ) / (3850-3025)
0.52
b) Steps for calculating c value
Particulars Details
c Σy - m Σx / N
(201 – (0.52 * 55))/10
17.24
c) Forecasting m and c value for day 14 and 21
Forecast of 14th day
Y = mX + C
Y 0.52 (X) + 17.24
X 14
Y 0.52 (14) + 17.24
6

24.52
Forecast of 21th day
Y = mX + C
Y 0.52 (X) + 17.24
X 21
Y 0.52 (21) + 17.24
28.16
CONCLUSION
From the above report, it could be concluded that numeracy and data analysis are very
significant for analysing any details as it has shown in this with use of weather data of London. It
has reflected wind speed and for avoiding any argument there is representation of visual and
tabular format. Moreover, it has provided descriptive statistics of data set and reflected
application of linear forecasting model where on day 14th wind speed will be 24.52 km/h and on
21st it will be 28.16 km/h.
7

REFERENCES
Books and journals
8