Hello,
I have a column titled wind speed(m/s) in F3 which shows the average wind speed every 10 seconds, populating F4, F5 etc all the way down to F40000.
I need to turn this into an averaged hourly wind speed data.
I then need put this hourly wind speed data into bins (of .5m/s, 1m/s, 1.5m/s, 2m/s etc up to 25 and create a wind speed distribution chart with wind speed on the x axis and number of hours on the y axis.
I am really struggling to perform this challenge.
Can anyone help me??