Mr.

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?

Thank you

By: João Tavares

Leave a Reply

Your email address will not be published. Required fields are marked *