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 adj. close to create a chart in excel. Your chart x-axis should show the date. Submit a 1 sheet excel document showing this information. Date Open High Low Close Volume Chg % Chg Adj. Close 04/16/2019 22.38 22.39 22.18 22.29 1.28m -0.04 -0.18% 22.29 04/15/2019 22.30 22.42 22.27 22.33 978.43k 0.07 0.31% 22.33 04/12/2019 22.39 22.43 22.23 22.26 813.31k -0.01 -0.04% 22.26 04/11/2019 22.10 22.40 22.065 22.27 1.39m 0.19 0.86% 22.27 04/10/2019 22.05 22.14 21.95 22.08 1.33m 0.01 0.05% 22.08 04/09/2019 21.89 22.07 21.82 22.07 1.48m 0.19 0.87% 22.07 04/08/2019 21.91 21.93 21.80 21.88 1.85m -0.05 -0.23% 21.88 04/05/2019 22.00 22.02 21.83 21.93 878.64k -0.05 -0.23% 21.93 04/04/2019 21.98 22.04 21.84 21.98 1.27m -0.06 -0.27% 21.98 04/03/2019 22.12 22.13 21.79 22.04 1.94m -0.05 -0.23% 22.04 04/02/2019 22.24 22.37 22.065 22.09 2.33m -0.10 -0.45% 22.09 04/01/2019 22.18 22.24 22.08 22.19 1.63m 0.08 0.36% 22.19 03/29/2019 22.10 22.15 21.98 22.11 1.19m 0.11 0.50% 22.11 03/28/2019 21.86 22.06 21.85 22.00 1.5m 0.11 0.50% 22.00 03/27/2019 22.00 22.06 21.76 21.89 2.02m -0.10 -0.45% 21.89 03/26/2019 21.78 22.01 21.77 21.99 1.78m 0.34 1.57% 21.99 03/25/2019 21.76 21.79 21.45 21.65 1.88m -0.13 -0.60% 21.65 03/22/2019 22.10 22.105 21.69 21.78 2.12m -0.33 -1.49% 21.78 03/21/2019 21.96 22.39 21.87 22.11 1.97m 0.04 0.18% 22.11 03/20/2019 22.04 22.24 22.01 22.07 1.89m 0.05 0.23% 22.07 03/19/2019 22.19 22.20 22.00 22.02 4.24m -0.10 -0.45% 22.02 03/18/2019 22.05 22.19 21.83 22.12 953.3k 0.21 0.96% 22.12

12 WIL PROJECT Program Name: BMAT Project Code: CPL-5559-BMAT-0211-0133-V2 WIL PROJECT WIL PROJECT CASE STUDY ORIENTATION WEEK 4 (Source: https://web.tmxmoney.com/pricehistory.php?qm_symbol=IPL ) Deliverables, Format and Marking Scheme for This Weeks Case Study Evaluation: Creating a chart in excel (3%) X-axis is shows date (1%) Y-axis shows adj close (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.