Using awk, Generate a report containing the lowest, highest and average score for each assignment in the data file. The name of the assignment is located in column $3.$ Your report should be in a tabular format as shown in the sample below;

Name Low High Average

Q$06779586\mathrm{.}80$

L$05409646\mathrm{.}60$

WS $555$

Q$075810078\mathrm{.}80$

L$06609961$

L$07778664\mathrm{.}80$

H$01199047\mathrm{.}80$

H$02479574\mathrm{.}60$

H$03709582\mathrm{.}20$

H$04468065$

H$05549576\mathrm{.}60$

H$06589780\mathrm{.}60$

Q$012510074\mathrm{.}80$

H$07529067$

Q$028410091\mathrm{.}60$

L$01419175$

Q$033310066\mathrm{.}80$

L$02010061\mathrm{.}40$

Q$045510081$

L$038810095\mathrm{.}80$

FINAL $589985\mathrm{.}60$

Q$05549976\mathrm{.}80$

L$044810079\mathrm{.}20$