Need to check if there is a trend in wind speed along the hours of the day for a 2 month period.
So in Column A I have the hours in 00:00 to 23:00 format for each day of the series, from day 1 of month 1 until day 30th of month 2.
In Column B I have the average max wind speed during that hour interval. For example from 00:00 to 01:00 of tre first day of the series, 11kts. Form 01:00 to 02:00 of the first day of the series, 14kts, and so on
In Column C I have the data series for the wind average speed during that same hour interval. For example from 00:00 to 01:00 of tre first day of the series, 5kts. Form 01:00 to 02:00 of the first day of the series, 6kts, and so on.
So the Ranges are: Hour, Max average, Average
Of course, the hours repeat themselves along their column avery 24 hours.
How can I group averages of max wind speed and average wind speed by the hour.
I need to know in a 24 hour table, the average max wind speed for every hour of the day during those 2 months, and the average wind speed for the same every hour of the day during those 2 months.
Is this possible?
By: João Tavares