Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I average wind directions using excel?
I have a data set of wind directions in degrees, rounded to the nearest 10
degrees. I am attempting to take a average of that data set. Any help would be greatly appreciated. |
#2
|
|||
|
|||
Hi. That's a good question because the average of 350° and 10° is due
north, and not the average (180°) I "Think" that one way is to take the average of the East-West, and North-South components. With given Degrees in Column A names "Rng", see if this Array Formula will work... =DEGREES(ATAN2(AVERAGE(COS(RADIANS(Rng))),AVERAGE( SIN(RADIANS(Rng))))) If the answer is negative, then add 360. (ie if -10, then add 360: - 350°) HTH :) -- Dana DeLouis Win XP & Office 2003 "Rex Morgan" <Rex wrote in message ... I have a data set of wind directions in degrees, rounded to the nearest 10 degrees. I am attempting to take a average of that data set. Any help would be greatly appreciated. |
#3
|
|||
|
|||
Are all these directions from the same quadrant or within 90 degrees (min/max)? Not sure how useful an average will be if they vary more than that. ANYWAY... Assuming that your data set is in col A, use the AVERAGE function in a formula in a separate cell; ie: =AVERAGE(A2:A10). If you precede this with the Round function, you can eliminate the decimal fraction as well: =ROUND(AVERAGE(A2:A10),0). -- neopolitan ------------------------------------------------------------------------ neopolitan's Profile: http://www.excelforum.com/member.php...nfo&userid=611 View this thread: http://www.excelforum.com/showthread...hreadid=475877 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Microsoft Excel in Microsoft works - how to open | Excel Discussion (Misc queries) | |||
Value Errors with EXCEL XP not showing up in EXCEL 2000 | Links and Linking in Excel | |||
excel moving average | Excel Worksheet Functions | |||
Difference in number of Excel NewsGroups | Excel Discussion (Misc queries) | |||
Excel 2002 and 2000 co-install. Control Which Starts ? | Excel Discussion (Misc queries) |