Overview
You are to complete question 1,2,5,6,7 from the questions set provided, and all yellow parts of the excel.
Please provide two separate excel files for the completion of this assignment set.
The question set is in the last page of the pdf uploaded.
If you are already strong with these concepts, try using Excel functions such as arrays and named ranges to answer the question elegantly. If you are already strong with Excel, try coding up the answers in R.
This assignment is to be finished in excel. Please do not take this if you aren't experience with using excel.