Have to solve two questions using excel sheet and write a summary on both of those problems. the summary should not exceed two pages.

Please answer all of the following questions. You must email me the excel spreadsheets with one spreadsheet per question where applicable. A (at most two page) printed answer sheet / summary should be submitted on the due date (along with the emailed spreadsheets). Please include the names of all the people in the group in the email and the summary.

The questions are in the file attached below.