Analyzing Glasgow Wind Speed Data: A Numeracy and Data Report

This report presents a comprehensive analysis of wind speed data collected in Glasgow, United Kingdom. The analysis begins with organizing the data into a table, followed by presenting the data using bar graphs and scatter plots. The report then delves into calculating central tendencies, including mean, median, mode, range, and standard deviation for wind speed, temperature, and wind direction. The findings reveal insights into the average values, distribution, and variability of these parameters over a given period. Furthermore, the report incorporates a forecasting model to predict wind speed for future days. The study concludes with a summary of the key findings and references relevant literature on numeracy and data analysis techniques. This report is a valuable resource for students studying data science and related fields, offering practical examples of data analysis methodologies and interpretation.

Numeracy and Data Analysis

Table of Contents
INTRODUCTION ..........................................................................................................................3
1. Arranging data in a table..........................................................................................................3
2. Present data by using two kind of chart ..................................................................................3
3. calculation of mean, median, mode, range and standard deviation ........................................5
4. using forecasting model...........................................................................................................6
CONCLUSION ...............................................................................................................................6
REFERENCES................................................................................................................................7

INTRODUCTION
Numeracy means the skills and the confidence in using the numbers and the
mathematical approaches in all the aspects of the life. However, data analysis refers to the
process of cleansing, modeling, inspecting and transforming the data with a goal of discovering a
useful information, supporting decision-making and in drawing informing conclusions. The
present study involves the assessment of wind speed in Glasgow, a city that lies in United
Kingdom. Furthermore, it involves computation of central tendencies of all the variables that are
temperature, wind speed and wind direction.
1. Arranging data in a table
Data
Serial no. Day Sum of Temperature Sum of Wind speed Sum of Wind direction
1 24 367.89 318.9 2915.69
2 25 343.4 237.1 3136.07
3 26 305.47 430.87 4863.77
4 27 276.43 303.4 5998.09
5 28 282.12 240.82 6322.25
6 29 297.24 315.16 3906.22
7 30 265.15 289.95 3780.21
8 1 221.07 519.13 1333.55
9 2 190.32 235.55 7222.02
10 3 199.88 427.27 3085.57
Grand
total 2748.97 3318.15 42563.44

2. Present data by using two kind of chart
Bar graph- It refers to the pictorial rendition of the statistical data within which an
independent variable could attain only specific discrete values. In other words it means a
quantitative comparison by using rectangles with the lengths proportional to measure the data or
the things that are being compared.
Scattered chart- It referred as the set of the points plotted on the horizontal and the
vertical axes (Taylor and Byrne-Davis, 2017). Scatter plots are essential as it reflects the extent
of the correlation in between the values of an observed quantities or the phenomena stated as
variables. It is been counted as the simplest technique for assessing the correlation among
variables.
1 2 3 4 5 6 7 8 9 10 11 12 13
0
500
1000
1500
2000
2500
3000
3500
318.9 237.1 430.87 303.4 240.82 315.16 289.95
519.13
235.55 427.27
1181.95
3318.153318.15
Sum of Wind speed

3. calculation of mean, median, mode, range and standard deviation
Mean- It refers to the average value of the variables which us been calculated by adding
up all the values and dividing it by the total observation.
Median- This means middle value of the variables attained when the dataset are arranged
from the least to the largest tor in an order.
Mode- It is been stated as the statistical term which is been found by organizing and
collecting the data in the order for counting frequency of each and every result (Geiger, Goos
and Dole, 2015). The value with the highest count the occurrence is called as mode of the data
which in turn also called as the modal value.
180 200 220 240 260 280 300 320 340 360 380
0
100
200
300
400
500
600
Sum of Wind speed

Range- This measures meant as the complete group the that is been involved in between
the two points on the measurement scale or the quality. It is calculated by subtracting the lowest
value from the largest value or can be said as maximum value minus the minimum value.
Standard deviation- It is the statistical measure which captures a difference in between
the average and an outliers within the dataset (Civil, Stoehr and Salazar, 2019). It is considered
as the measure of dispersion of the dataset or the variables from its mean value.
Serial No. Days
Sum of Wind
speed
Sum of
Temperature
Sum of Wind
direction
1 24 318.9 367.89 2915.69
2 25 237.1 343.4 3136.07
3 26 430.87 305.47 4863.77
4 27 303.4 276.43 5998.09
5 28 240.82 282.12 6322.25
6 29 315.16
Geiger, V., Goos,
M. and Dole, S.,
2015297.24 3906.22
7 30 289.95 265.15 3780.21
8 1 519.13 221.07 1333.55
9 2 235.55 190.32 7222.02
10 3 427.27 199.88 3085.57
Total 3318.15 2748.97 42563.44
Mean 331.815 274.897 4256.344
median 309.28 279.275 3843.215
Mode 0 0 0
Range 283.58 177.57 5888.47
Standard
deviation 96.340084798 58.311393979 1819.0638960569

Interpretation- The above analysis shows that the mean value of wind speed resulted as
331.81 that is evaluated by dividing the total number of the observation with that of the grand
total of values. However, for the other two variables that is temperature and wind direction, the
average value equated to 274.897 & 4256.344. In other words, the median value of wind speed,
temperature and wind direction attained as 309.28, 279.275 & 3843.215. The Mode for all the
three variables computed as nil because no value is seen as repeated with the 10 days. The value
of range evaluated as 283.58 of wind speed, 177.57 of temperature and 5888.47 of wind
direction in Glasgow for the period of 10 consecutive days. Standard deviation for sum of wind
speed resulted as 96.34, for temperature it equates to 58.3 and fro the third variable it is been
valued as 1819.06.
4. using forecasting model
Date Number of
days (X) Total wind speed (Y) XY X^2
22/09/19 1 15.55 15.55 1
23/09/19 2 20.72 41.44 4
24/09/19 3 19.51 58.53 9
25/09/19 4 15.5 62 16
26/09/19 5 25.74 128.7 25
27/09/19 6 20.33 121.98 36
28/09/19 7 19.67 137.69 49
29/09/19 8 17.71 141.68 64

30/09/19 9 22.42 201.78 81
particulars Formula Y = mX + c
m NΣxy – Σx Σy / NΣ x^2 – (Σx)^2
M = 10 (1142.05) - (55 * 200.42) /
(10 * 385) – (55)^2
m = (11420.5 – 11023.1) / (3850 –
3025)
m = 397.4 / 825
m = 0.48169697
c Σy - mΣx / N
c = 200.42 – (0.48169697 * 55) / 10
c = ( 200.42 –26.49333335) / 10
c = 173.92666665 / 10
c =17.392666665
Forecasting
wind speed
for 14 days
Y = mX + c Here x = 14 days
Y = 0.48169697 (14) + 17.392666665
Y = 6.74375758 + 17.392666665
Y = 24.136424245
Forecasting
wind speed
Here x = 21 days
Y = 0.48169697 (21) + 17.392666665

for 21 days Y = mX + c Y = 10.11563637 + 17.392666665
Y = 27.508303035
CONCLUSION
From the above study it has been summarized that with passage of days the sum of wind
speed has been increased in Glasgow. The statistical measures applied within the report also
shows that the average value of the wind speed and the other variable is higher than that of the
median, mode and other measures.