Pick one of the following problems to do for your interclass problem.

1. Inserting Sums - We worked in class on a method to sum values and place the result in the table. However, we found that our result was somewhat lacking because we didn't have enough control over what to sum or where to place the result. For this option I want you to fix that. Make a more complete method that allows us to specify the range of cells for the sum and where to place the result.

2. Business Decisions - This problem has you working with this CSV file. This is for a spreadsheet with five columns and each one has 15 rows. The first four columns are numbers of items sold of each of four different types. The last column is total sales. I want you to write a method that returns the average of total sales for those entries where the value in one column is larger than another. The method will take two parameters that are column numbers. You only average costs where the first column has a larger value than the second column.

3. Temps By Year - For this problem you will deal with a weather CSV file. I want to know the average year for the ten warmest months and the ten coldest months. To help you figure out how to do this I would not that it is rare for there to be ties in the temperature of these extreme months.

4. Excel Style Indexing - In excel you can specify cells with things like b5 and ranges of cells with a1:d4. Write code that will do a sum and takes a string argument in the Excel style. To help with this I will note that the expression c-'a' where c is a char type will give you the numeric position of a lowercase letter in the alphabet.