Download this worksheet. It looks like this:
The data is for a course like the one you're taking now. It shows the number of exercises each student completed, and their total scores on exams.
Some of the data is missing. The cells are empty. Other than that, you can assume all of the data is valid.
Write a program that shows the mean exam scores for people who did 30 or more exercises, and the mean exam scores for people who did fewer than 30 exercises. Include counts are well. Highlight lines that have data missing. Don't include those lines in the means or counts.
Make sure that the program would still work if the amount of data changed. That is, don't assume that the amount of data will always be the same.
Here's some output:
Round the means to one decimal place. (There's a page for that in Tips and Tricks.)
The usual coding standards apply.
Upload your worksheet.
(If you were logged in as a student, you could submit an exercise solution, and get some feedback.)
