BEGIN {
	FS=",";
	printf("Name       Average\n")
	printf("----       -------\n")
	numPeople=0
}

{
	if (1<NR)
	{
	   printf("%-10s %7.2f\n",$1,($3+$4+$5)/3.0)
	   numPeople++
	   sumTest[0]=sumTest[0]+$3
	   sumTest[1]=sumTest[1]+$4
	   sumTest[2]=sumTest[2]+$5
	   if ("Red"==$2) sumTeam["Red"]=sumTeam["Red"]+$3+$4+$5
	   if ("Blue"==$2) sumTeam["Blue"]=sumTeam["Blue"]+$3+$4+$5
	   if ("Green"==$2) sumTeam["Green"]=sum["Green"]+$3+$4+$5
	}
}

END {
	printf("------------------\n")
	printf("Average for Test 1: %f\n",sumTest[0]/numPeople)
	printf("Average for Test 2: %f\n",sumTest[1]/numPeople)
	printf("Average for Test 3: %f\n",sumTest[2]/numPeople)
	printf("------------------\n")
	printf("Average for Red Team: %f\n",sumTeam["Red"]/9.0)
	printf("Average for Green Team: %f\n",sumTeam["Green"]/9.0)
	printf("Average for Blue Team: %f\n",sumTeam["Blue"]/6.0)
}