Question

AWK Programming - Please show new working code with screenshot please.

Save the following data in a file named teamlist.txt:

Name,Team,First Test, Second Test, Third Test Tom,Red,5,17,22
Joe,Green,3,14,22
Maria,Blue,6,18,21

Fred,Blue,2,15,23 Carlos,Red,-1,15,24 Phuong,Green,7,19,21 Enrique,Green,3,16,20 Nancy,Red,9,12,24

Write an AWK script that will compute the average score for every person in the list, the average score for each test, and the average score for each team. If a score is negative, that means the person missed the test, and the score must not become part of the average.

Print the output to look like the following. In the list by name, the names must be left justified in a field of size 10 (hint: %-10s in printf), and the averages must be seven characters wide with two digits to the right of the decimal point (%7.2f).

Name
--------
Tom
Joe
Maria
Fred
Carlos
Phuong 15.67
Enrique 13.00
Nancy 15.00 --------------------------------- Average for Test 1: 5
Average for Test 2: 15.75 Average for Test 3: 22.125 --------------------------------- Average for Red Team: 16 Average for Green Team: 13.8889 Average for Blue Team: 14.1667

Average ------- 14.67 13.00 15.00 13.33 19.50

1

AWK Programming

The Pseudocode

Below is a pseudo-code to help you write the program.

BEGIN{

set FS to a comma

print the header

}

{
if (NR > 1) # this test skips the first line of the file {

Set individualTotal and individualCount to zero

for (field=3; field <=5; field++) {

if ($field >= 0) {

add contents of $field to individualTotal add one to individualCount

# Now update the testTotal and testCount arrays
# subtract 2 from the field number so that our arrays begin at 1 add contents of $field to testTotal indexed by (field-2)
add 1 to testCount array indexed by (field-2)

# Use contents field 2 as the index for the team array

add contents of $field to teamTotal array indexed by $2

add 1 to teamCount array indexed by $2

} }

print the person's name and his individual average

} }

END {
print "------------------" for (n=1; n<=3; n++) {

print average for test n using testTotal and testCount arrays }

print "------------------"

print average for "Red" team
print average for "Green" team
print average for "Blue" team
(these all use the teamTotal and teamCount arrays)

}

Answer 1

format long pa*inv(a) 0 1.00000008068800 Reset the display to the shorter format using format short format affects only the display of numbers, not the way MATLAB computes or 16 25 49 64 100 36