Utilize the concepts and business applications of computer information systems. This Weeks Detailed Case Study Information Shortly after graduation from Lambton College in Toronto, you started working at a local bank. Your job requires a lot of analysis, and you make sure to utilize the available technology to accomplish this task. Your manager was discussing the below investment with you and provided you with some data, which is listed below. The manager is not sure how to present this data. Youd like to make sure that its easy to understand the information for the unsophisticated investor. So, you decided to use excel to accomplish this task. Use the Last & Date to create three charts in excel. Your chart x-axis should show the date. Make sure to group calls maturing at the same time in the same chart. Submit a 1 sheet Microsoft Excel document showing this information. Calls Last Strike Apr 12, 2019 1.84 20.50 Apr 12, 2019 1.34 21.00 Apr 12, 2019 0.84 21.50 Apr 12, 2019 0.31 22.00 Apr 12, 2019 0.03 22.50 Apr 12, 2019 0.03 23.00 Apr 12, 2019 0.03 23.50 Apr 12, 2019 0.03 24.00 Apr 18, 2019 1.32 21.00 Apr 18, 2019 0.35 22.00 Apr 18, 2019 0.03 23.00

Apr 18, 2019 0.03 24.00 Apr 26, 2019 1.82 20.50 Apr 26, 2019 1.32 21.00 Apr 26, 2019 0.82 21.50 Apr 26, 2019 0.35 22.00 Apr 26, 2019 0.06 22.50 Apr 26, 2019 0.03 23.00 Apr 26, 2019 0.03 23.50 Apr 26, 2019 0.03 24.00 Apr 26, 2019 0.03 24.50

Evaluation: Creating three charts in excel (3%) X-axis is shows date (1%) Grouping the correct data together (1%) Note: assume any missing information. Clearly state your assumptions in your submissions. Your submission should be in the form of a Microsoft Excel/Access file.