P
Phil
Hi all,
One of my students, a meterologist, has asked me how to calculate
average wind direction over a period, and I am stumped. He has a column
of numbers, representing direction in degrees, and simply wants the
average direction for the column. However he is coming across what I
guess is a perennial problem, ie:
Wind Direction
355
5
where using =Average will give the result 180 - of course the real
average should be 360.
I've searched this group, and found an earlier post for a similar
problem, that suggested the formula:
=MOD(DEGREES(ATAN2(AVERAGE(COS(RADIANS(A2:A3))),AVERAGE(SIN(RADIANS(A2:A3)))))+360,
360)
However this has only given the result 5
The recipient of this earlier post seemed happy - but I can't get it to
work!
Can anyone suggest an answer? The wind directions are simple numbers,
not formatted as degrees or anything, and it's only the average my
student is trying to obtain.
Just shows the teacher doesn't always know it all!
One of my students, a meterologist, has asked me how to calculate
average wind direction over a period, and I am stumped. He has a column
of numbers, representing direction in degrees, and simply wants the
average direction for the column. However he is coming across what I
guess is a perennial problem, ie:
Wind Direction
355
5
where using =Average will give the result 180 - of course the real
average should be 360.
I've searched this group, and found an earlier post for a similar
problem, that suggested the formula:
=MOD(DEGREES(ATAN2(AVERAGE(COS(RADIANS(A2:A3))),AVERAGE(SIN(RADIANS(A2:A3)))))+360,
360)
However this has only given the result 5
The recipient of this earlier post seemed happy - but I can't get it to
work!
Can anyone suggest an answer? The wind directions are simple numbers,
not formatted as degrees or anything, and it's only the average my
student is trying to obtain.
Just shows the teacher doesn't always know it all!