I have a list of wind directions and I want to get the average. Obviously, there is an issue since the average of a northwest (330) and northeast (030) wind is 360, not 180. I've got several formulas in the attached spreadsheet, but none seem to give the correct results. Has anyone figured this out?
Thanks
1st observation: it appears you are trying to use method 1 described here by the US NOAA: http://www.ndbc.noaa.gov/wndav.shtml
It appears to me that each of the three formulas you are using is referring to the angle in radians in column B -- then trying to convert to radians again. I think you just need to take out the degrees-radians function in these formulas, or adjust them to refer to column A where the wind direction is in degrees.
Originally Posted by shg
Thanks; that seems to have fixed the problem.
... never mind
Entia non sunt multiplicanda sine necessitate
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks