+ Reply to Thread
Results 1 to 5 of 5

Average of many wind directions

  1. #1
    Registered User
    Join Date
    06-20-2019
    Location
    Bryges
    MS-Off Ver
    2010
    Posts
    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. #2
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often: 2019 but still use also older versions
    Posts
    7,422

    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
    Best Regards,

    Kaper

  3. #3
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often: 2019 but still use also older versions
    Posts
    7,422

    Re: Average of many wind directions

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

  4. #4
    Forum Guru Olly's Avatar
    Join Date
    09-10-2013
    Location
    Darlington, UK
    MS-Off Ver
    Excel 2016, 2019, 365
    Posts
    6,244

    Re: Average of many wind directions

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


    (assuming equal strength wind in all directions...)
    Last edited by Olly; 06-20-2019 at 07:50 AM.
    let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source

    If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE

    Walking the tightrope between genius and eejit...

  5. #5
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    12,365

    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.
    This page does not claim any meteorological expertise, but he has spreadsheet examples: https://www.scadacore.com/2014/12/19...nd-wind-speed/
    The WebMet reference from the previous page: http://www.webmet.com/met_monitoring/622.html

    Perhaps those references will help.
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Average Wind Direction
    By bwalshnl in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-05-2014, 03:31 PM
  2. Replies: 1
    Last Post: 08-16-2013, 05:25 PM
  3. Average of directions wind
    By nunito in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 03-17-2013, 08:31 AM
  4. Averaging Wind Directions
    By Andrew_H92 in forum Excel Formulas & Functions
    Replies: 17
    Last Post: 03-16-2013, 07:38 PM
  5. Average wind direction
    By Phil in forum Excel Formulas & Functions
    Replies: 15
    Last Post: 03-14-2013, 07:56 PM
  6. Average Wind Direction
    By rexmorgan in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-18-2005, 12:05 AM
  7. [SOLVED] How do I average wind directions using excel?
    By Rex Morgan in forum Excel General
    Replies: 2
    Last Post: 10-13-2005, 01:05 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1