Control.com - Nerds in Control

Dear experts,

I am trying to analyze weather data obtained from one of the AWS installed in my location. The problem is, in Averaging Wind Directions. I have data sets of Wind direction of 30 minutes interval.
Steps I tried using excel sheet are:

1. Converting degrees to radians(RAD)

2. Sin(RAD)and Cos(RAD)

3. Wind Speed*Sin(RAD)-Y

4. Wind Speed*Cos(RAD)-X.

5. Then averaged as per required interval

6. and then tried finding Atan(y/x) and then converting to degrees but the result isn't good

For instant, if the data is 122 degree at half an hour reading and 225 degree at one hour reading, the average obtained from above is something 300 (around) degrees in which case it should be between 122 and 225.

Any suggestions will be appreciated!

Pems,

Your general method is correct. If you have implemented what you said correctly you should get 173.5 degrees for the average direction. If you got something around 300 then there must be something wrong with your implementation.