Numeracy and Data Analysis Assignment: London Wind Speed

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

Numeracy and Data Analysis

Contents
Introduction:...............................................................................................................................3
Que. 1: Table of wind speed for ten days...................................................................................4
Que. 2 Present the data in the chart forms as:............................................................................4
Que. 3 Calculate different steps:................................................................................................5
Que. 4 Calculate y = mx+c.........................................................................................................8
References:...............................................................................................................................10

Introduction:
The assignment of numeracy and data analysis is to collect wind speed data of the selected
city. Select London as city to collect data for consecutive ten days. Use online source to
collect data and perform different task to present data in graphical, chart and different forms.
Calculate different steps to find mean, median, mode and others. Use linear forecasting model
to get forecast wind speed for next days.

Que. 1: Table of wind speed for ten days
Ans. Select London as city to get ten days wind speed data and represent in table as below:
Date Wind Speed (KM/H)
Tue, 20th Aug, 2019 14
Tue, 21st Aug, 2019 9
Tue, 22nd Aug, 2019 12
Tue, 23rd Aug, 2019 6
Tue, 24th Aug, 2019 7
Tue, 25th Aug, 2019 7
Tue, 26th Aug, 2019 5
Tue, 27th Aug, 2019 7
Tue, 28th Aug, 2019 14
Tue, 29th Aug, 2019 14
(bbc, 2019)
Que. 2 Present the data in the chart forms as:
Ans. Create line and column chart in with the above given data as below:
Line chart:
20th
Aug 21st
Aug 22nd
Aug 23rd
Aug 24th
Aug 25th
Aug 26th
Aug 27th
Aug 28th
Aug 29th
Aug
0
2
4
6
8
10
12
14
16
Wind Speed (KM/H)
Wind Speed (KM/H)

Column Chart
Wind Speed (KM/H)
0
2
4
6
8
10
12
14
16
20th Aug
21st Aug
22nd Aug
23rd Aug
24th Aug
25th Aug
26th Aug
27th Aug
28th Aug
29th Aug
Que. 3 Calculate different steps:
Ans. Calculate different steps of the given below data:
Date Wind Speed (KM/H)
Tue, 20th Aug, 2019 14
Tue, 21st Aug, 2019 9
Tue, 22nd Aug, 2019 12
Tue, 23rd Aug, 2019 6
Tue, 24th Aug, 2019 7
Tue, 25th Aug, 2019 7
Tue, 26th Aug, 2019 5
Tue, 27th Aug, 2019 7
Tue, 28th Aug, 2019 14
Tue, 29th Aug, 2019 14

(1) Mean
Steps: Sum of all the numbers divide by total number
14+9+12+6+7+7+5+7+14+14 / 10
95/10 = 9.5
(2) Median
 Calculate median of the given set of numbers 14, 9, 12, 6, 7, 7, 5, 7, 14, 14
 Arrange the set of number of in ascending order as: 5, 6, 7, 7, 7, 9, 12, 14, 14, 14
 Find two middle number pair & get median of the data set as:
 The middle numbers are: 5, 6, 7, 7, 7, 9, 12, 14, 14, 14
 Add the middle numbers and divide by 2 as: 7+9 = 16/2 = 8
 The median of the data set is = 8
(3) Mode
 Find mode in the given data set: 5, 6, 7, 7, 7, 9, 12, 14, 14, 14
 Find the number that repeated most times: 7 repeated 3 times as same 14.
 So there are two modes in the given data set & this is called “bimodal”
 The two modes are: 7 & 14
(4) Range
 Find the range of the given data set: 5, 6, 7, 7, 7, 9, 12, 14, 14, 14
 Range = highest value – lowest value
 Highest value = 14, lowest value = 5
 Range of the data set: 14-5 = 9
(5) Standard Deviation
The given data set is: 14, 9, 12, 6, 7, 7, 5, 7, 14, 14
Fine the mean of the given data set (μ) = 9.5
In the next phase: subtract the mean from the list of given data set and square the result
as:
(14-9.5)2 = (4.5)2 = 20.25

(9-9.5)2 = (-0.5)2 = .25
(12-9.5)2 = (2.5)2 = 6.25
(6-9.5)2 = (-3.5)2 = 12.25
(7-9.5)2 = (-2.5)2 = 6.25
(7-9.5)2 = (-2.5)2 = 6.25
(5-9.5)2 = (-4.5)2 = 20.25
(7-9.5)2 = (-2.5)2 = 6.25
(14-9.5)2 = (4.5)2 = 20.25
(14-9.5)2 = (4.5)2 = 20.25
The result is: 20.25, .25, 6.25, 12.25, 6.25, 6.25, 20.25, 6.25, 20.25, 20.25
Apply formula to get standard deviation as:
Here N = 10 the total numbers
Calculate the mean different with add the result and multiply by 1/N (1/10)
The total of result is:
20.25 + .25 + 6.25 + 12.25 + 6.25 + 6.25 + 20.25 + 6.25 + 20.25 + 20.25 = 118.5
The squared difference mean is = (1/10) * 118.5 = 11.85
Get the result with square root of 11.85 =
σ = √11.85 = 3.4423829

Que. 4 Calculate y = mx+c
Ans. Calculate the value of m & c to put in the above equation as
I. Calculate m value:
Find the value of m with using the formula as:
∑ ( x−x ) ( y − y )
∑ ( x−x ) 2
II. Calculate c value:
Calculate the formula or equation to get the value of c is =
c = y - mx
III. Calculate forecast wind speed for day 14 & 21 as:
Calculate m & c with the below table:
x y x-x y- y (x-x)(y- y) (x-x)^2
1 14 1-5.5 = -4.5 4.5 -20.25 20.25
2 9 2-5.5 = -3.5 -0.5 1.75 12.25
3 12 3-5.5 = -2.5 2.5 -6.25 6.25
4 6 4-5.5 = -1.5 -3.5 5.25 2.25
5 7 5-5.5 = -0.5 -2.5 1.25 0.25
6 7 6-5.5 = 0.5 -2.5 -1.25 0.25
7 5 7-5.5 = 1.5 -4.5 -6.75 2.25
8 7 8-5.5 = 2.5 -2.5 -6.25 6.25
9 14 9-5.5 = 3.5 4.5 15.75 12.25
10 14 10-5.5 = 4.5 4.5 20.25 20.25
x=5.5 y= 9.5 Total = 3.5 Total: 82.50
m = 3.5/82.5
m = 0.04242
c = 9.5 – (0.04242) 5.5
c = 9.26669

Calculate forecast wind speed for day 14 & 21 as:
Day 14:
y = mx+c
y = 0.04242 (14) + 9.2669 = 9.86078
Wind speed on day 14 is = 9.86078
Around 10KM/H
Day 21:
y = mx+c
y = 0.04242 (21) + 9.2669 = 10.15772
Wind speed on day 21 is = 10.15772
Around 10KM/H

References:
bbc (2019). London - BBC Weather. [online] BBC Weather. Available at:
https://www.bbc.com/weather/2643743 [Accessed 9 Sep. 2019].
Gupta, D. (2018). Mathematics for Machine Learning : Linear Regression & Least Square
Regression. [online] Medium. Available at: https://towardsdatascience.com/mathematics-for-
machine-learning-linear-regression-least-square-regression-de09cf53757c [Accessed 9 Sep.
2019].
worldweatheronline (2019). London Historical Weather. [online] WorldWeatherOnline.
Available at: https://www.worldweatheronline.com/lang/en-in/london-weather-history/city-
of-london-greater-london/gb.aspx [Accessed 9 Sep. 2019].