# Average of many wind directions

1. ## Average of many wind directions

Hi to everyone,

I have a problem.
The average of two wind directions i.e. 350 and 10 is 360/0. ok I have already find a solution to this.
Which is the solution if we have many directions (over 5 ) and we want to find them average. and especially when these directions are 350/10/140/190/40 . Which is their average?

Thank you

2. ## Re: Average of many wind directions

Hi,

I do not think it is just excel question it is more about data representation, or other "pure mathematics" problem.

In your particular case, I'd describe these directions as
-10
10
140
190
40

or (equivalent):
350
370
500
550
400

because this representation leads to lowest standard deviation (ca. 87)
So the average direction would be 74 degrees

Note that any other representationgives higher standard deviation values:

350 350 350 350 350
10 370 370 370 370
140 140 140 500 500
190 190 190 190 550
40 40 400 400 400
SD
135 141 117 112 87

3. ## Re: Average of many wind directions

But as we are on Excelforum - you may see how did I checked it in attached file

4. ## Re: Average of many wind directions

Is it not:
Formula:
`Please Login or Register  to view this content.`

(assuming equal strength wind in all directions...)

5. ## Re: Average of many wind directions

I know that there are special considerations for averaging wind speed and direction, so not only is this probably more math than Excel, but it probably also needs a discussion specific to meteorology.

Here's a brief page from the US government's NOAA: https://www.ndbc.noaa.gov/wndav.shtml Basically it says that the standard approach to averaging wind speed and direction is to get a scalar average of the wind speeds and a unit vector average of the wind direction. This usually boils down to an ATAN() or, better yet, an ATAN2() function.
The WebMet reference from the previous page: http://www.webmet.com/met_monitoring/622.html

Perhaps those references will help.

There are currently 1 users browsing this thread. (0 members and 1 guests)