averaging windspeed

[gpack]

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??

[Kaper]

Attach sample file.
for averaging over hours - best in Ex2007 would be probably Pivot Table
for distribution - FREQUENCY function, but ... attach sample.

[gpack]

Thanks for you're help
please find attached an example worksheet.
Mark

[gpack]

This one may be better. it has some timestamps on it.

[nsv]

Try this, it is just a quick suggestion.
By the way - your figures are 10 min. average, not 10 sec.

Average Windspeed example.xlsx

[Kaper]

To properly addres midnight region I'd change:
=IF(HOUR(E7)>HOUR(E6),AVERAGE(F1:F6),"")
into
=IF(HOUR(E7)<>HOUR(E6),AVERAGE(F1:F6),"")
Note that FREQUENCY is array formula - all region J4:J23 was selected and formula =FREQUENCY(... was committed with Ctrl+Shift+Enter

[newdoverman]

Here is a solution using Pivot tables as the basis of charts.