Dear Sir,
Please find attached file.
I am trying to find the frequency of interval 348.75 to 11.25 using the frequency function.
I only know how to find from 0 to 11.25 but do not know how to find for 348.75 to 11.25
regards & Thanks
Dear Sir,
Please find attached file.
I am trying to find the frequency of interval 348.75 to 11.25 using the frequency function.
I only know how to find from 0 to 11.25 but do not know how to find for 348.75 to 11.25
regards & Thanks
Last edited by AppleMonster; 04-06-2014 at 07:51 AM.
A B C D E F G 1DD Direction Count 2 128N 1223 3 207NNE 548 4 249NE 285 5 310ENE 289 6 263E 249 7 252ESE 321 8 231SE 486 9 237SSE 558 10 169S 603 11 253SSW 342 12 5SW 355 13 136WSW 362 14 145W 341 15 13WNW 654 16 10NW 810 17 131NNW 1334
The array formula in G2:G17 is
=FREQUENCY(MOD(A2:A8761+11.25, 360), 360*{1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16}/16)
Entia non sunt multiplicanda sine necessitate
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks