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

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!