Lab 11: Working with Strings and Files
Using this spreadsheet of hypothetical grades (grades.csv), write a program that will parse a .csv file (using split) and generate a list containing the score values from the second column.
- Write a findMax() function which takes a list as a parameter and returns the maximum score.
- Write a findMin() function which takes a list as a parameter and returns the minimum score.
- Write a findMed() function which takes a list as a parameter and returns the median score.
- Write a findAvg() function which takes a list as a parameter and returns the average score.
Test each function on the grades from the grades.cvs spreadsheet. You should get 98 for the max, 32 for the min, 83 for the median and 74.22 for the average.