Utilize the concepts and business applications of computer information systems. This Week’s Detailed Case Study Informat

[answerhappygod]

Utilize the concepts and business applications of computer
information systems. This Week’s 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.
You’d like to make sure that it’s 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.