Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

3. Utilize the concepts and business applications of computer information systems. This Weeks Detailed Case Study Information Shortly after graduation from Lambton College in Toronto,

3. 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.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Financial Management For Nurse Managers

Authors: J. Michael Leger

5th Edition

1284230937, 9781284230932

More Books

Students also viewed these Finance questions