Homework & Coursework Questions

BEGIN{FS=",";print"DEPARTMENTS & SALARIES"
print"Department Workers TotalSalary Average"
print"---------------------------------------------------------"}

awk -F, '{
		if(/CUS|CIS|SRT/)
		{
		  Dep_sal[$4]+=$NF
		  Dep_cnt[$4]++
		}
         }

      END{
	    dash = sprintf("%0*d", 50, 0);gsub(/0/,"-",dash)

	    print "DEPARTMENTS & SALARIES\nDepartment","Workers","TotalSalary","Average\n"dash

             for(i in Dep_sal )
	     {
		print i,Dep_cnt[i],Dep_sal[i],Dep_sal[i]/Dep_cnt[i]
		total_worker += Dep_cnt[i]
		total_salary += Dep_sal[i] 
             }
		
	     print dash"\nGRAND TOTAL",total_worker,total_salary,total_salary/total_worker

         }' OFS='\t' yourfile

$ ./tester
DEPARTMENTS & SALARIES
Department	Workers	TotalSalary	Average
--------------------------------------------------
 SRT	3	4600	1533.33
 CUS	4	6600	1650
 CIS	3	4000	1333.33
--------------------------------------------------
GRAND TOTAL	10	15200	1520