Question: Read the instructions thoroughly and complete all the steps. This assignment is on data and variables. One gets 0 for not submitting the assignment on

Read the instructions thoroughly and complete all the steps. This assignment is on data and variables. One gets 0 for not submitting the assignment on time or for academic dishonesty. Please ensure that you are submitting the correct file(s) - check and recheck. Show and keep all your works/formulas etc. on Excel. Submit only Excel file(s) and one word document to answer all the questions. To get the assigned stocks download Company Assignment file. Use only the three stocks assigned to you. Download the adjusted closing prices (NOT the closing price) of the stocks assigned to you from Yahoo finance in an Excel file (do not work on a .csv file) and calculate the monthly returns from 1st January 2019 to 31st December 2023. Monthly return for a month = (Adjusted closing price of next month - Adjusted closing price of this month)/Adjusted closing price of this month OR (Adjusted closing price of next month / Adjusted closing price of this month) - 1 Draw a single 2-D line chart showing dates on the x-axis and all the three returns on the y-axis (all three stocks must be shown on the same chart). Compare these returns using summary and descriptive statistics. Use the descriptive statistics functionality under data analysis tool. Find the correlations between these returns (not the stock price). Use CORREL() function or generate correlation matrix (under data analysis tool). How many months had positive and negative returns for each of these stocks? Use appropriate formulas for this. Write a coherent, meaningful, and complete paragraph stating your analysis, observations, and findings on a word document. Use Times New Roman 11 font, double spaced. Submit both the Excel and Word files. Ensure that all your works are properly titled. Keep all the formulas on the Excel file. Please note that all the analysis and charts should be of the stock returns, and not of the stock prices. Submit the correct files. Check before and after submissions
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
