Overview
You are to complete question 8-10 from the questions set provided, and all yellow parts of the excel.
Please provide 2 separate excel files for the completion of this assignment set.
This assignment is to be finished in excel. Please do not take this if you aren't experience with using excel.
Related course content is uploaded in the C2 file.
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