I have this data file which I want to sort out by making an awk file. I want to find the average rate within certain range of ages. For example, from  10<age<20and 20<age<30. And I can't find a way to calculate averages only for those people. How can I do this?name rate hours age sexAIDAN 3.5 19 22 MAMELIA 5.25 16 13 FNOAH 4.5 24 25 MISABELLA 4.25 17 15 FLIAM 4.5 23 23 MAVA 5.5 24 25 FCAYDEN 6 21 28 M
How can I designate range within an column when making an awk file?
awk;array