traded
The aim of this assignment is to elaborate a report describing stock market price evolution of two publicly traded companies. Choose two well-known companies listed on the New York stock exchange (or any other stock exchange). For the sake of this exercise please select these companies from two different sectors. Find the data for its daily stock price for the period of at least 5 last years (you need to use the same time span for both companies). I recommend to use the finance.yahoo.com web-page that allow to download a data for publicly traded companies for free. You will need to convert stock prices into returns as than the analysis for two companies will make sense – the easiest way to calculate the daily return is to take: closing price of day t / closing price of day (t-1) – the previous day. Than divide the difference by the price of the previous day to get the return in % terms. In such way you will generate the time series of daily returns for these two companies. Now please prepare a busines report that should be supported with all the necessary analysis (plots, tables etc.) and the excel will that will also form a part of the assignment.
AssignmentTutorOnline
Question1: Present the graph of both the daily price evolution and daily returns – comment on the price changes and the daily returns. Do you observe any extreme changes? What would be an explanation for them (please support any facts that can support your answer)
I need help writing my essay – research paper prepare the measures of the central tendency, dispersion and association of variables and based on this answer the following questions:
Q2: What is the mean stock price return for both companies? What is the meaning of the number you have obtained? I need help writing my essay – research paper compare the results obtained for both companies
Q3: What is the median stock price return for both companies? What is the meaning of the number you have obtained? I need help writing my essay – research paper compare the results obtained for both companies
Q4 Construct a frequency distribution of your choice (the intervals should be chosen by you for showing the distribution of the data in the best way) and percent frequency distribution of the stock price return for the indicated period for both companies. Evaluate the results and compare.
Q5: What is the most frequent stock price return range you observe for each company? Evaluate the results and compare
Q6: What is the variance and the standard deviation of the stock price returns for the indicated period for both companies? Evaluate the results and compare. What can we say about the volatility of the stock price returns for these two companies
Q7: I need help writing my essay – research paper think about the relationship between the stock prices (or stock price returns) of both companies. Would you expect the correlation between these two companies to be positive / negative? Strong or weak? I need help writing my essay – research paper calculate the correlation coefficient. What is the meaning of the results you have obtained? Is that what you have expected?
Q8: If the historical average stock market return is 10% with a standard deviation of about 15% (S&P 500), using the previous data you have provided, would you invest in any of these companies? I need help writing my essay – research paper annualize the average daily returns and the daily standard deviation to achieve quantities comparable (multiply the average daily return by 255 and the average daily standard deviation by sqrt(255), aprox.by 16 times).
I need help writing my essay – research paper remember to support your analysis with all the necessary graph
traded
The goal of this project is to write a report that describes the evolution of stock market prices for two publicly traded corporations. Choose two well-known corporations that are publicly traded in New York (or any other stock exchange). I need help writing my essay – research paper choose these companies from two separate industries for the sake of this assignment. Find data on its daily stock price for at least the last five years (you need to use the same time span for both companies). I recommend visiting finance.yahoo.com, which offers free data downloads for publicly traded firms. Because the study for two firms will make sense if stock prices are converted into returns, the simplest way to compute the daily return is to take: closing price of day t / closing price of day (t-1) – the previous day. Then multiply the difference by the previous day’s price to get the percent return. As a result, the time series of daily returns for these two companies will be generated. Now, please write a business report that includes all relevant analyses (plots, tables, etc.) as well as an excel spreadsheet that will be included in the assignment.
AssignmentTutorOnline
Question 1: Show the daily price development and daily returns graphs and remark on the price changes and daily returns. Do you see any drastic changes? What would be their explanation? (please support any facts that can support your answer)
Prepare the measurements of central tendency, dispersion, and association of variables, and then answer the following questions based on this information:
Q2: For both companies, what is the average stock price return? What is the significance of the number you’ve gotten? I need help writing my essay – research paper compare the findings for each businesses.
Q3: For both companies, what is the median stock price return? What is the significance of the number you’ve gotten? I need help writing my essay – research paper compare the findings for each businesses.
Q4 Construct a frequency distribution and percent frequency distribution of the stock price return for both firms for the provided period (intervals should be set by you to best display the distribution of the data). Compare and evaluate the outcomes.
Q5: For each company, what is the most common stock price return range you see? Compare and evaluate the outcomes.
Q6: For both companies, what is the variance and standard deviation of stock price returns over the stated period? Compare and evaluate the outcomes. What can we say about the stock price returns for these two firms’ volatility?
Q7: Consider the relationship between both firms’ stock prices (or stock price returns). Would you foresee a good or negative connection between these two companies? Is it better to be strong or weak? Calculate the correlation coefficient for me. What does the significance of your findings mean? Is that what you were hoping for?
Q8: Using the preceding data you supplied, would you invest in any of these companies if the historical average stock market return is 10% with a standard deviation of roughly 15% (S&P 500)? To make the figures similar, multiply the average daily return by 255 and the average daily standard deviation by sqrt(255), aproximately 16 times.
I need help writing my essay – research paper ensure to include all necessary graphs in your analysis.
