ECOM 2001-Term Project & Analyses Stock Market Data – Statistics Assignment Help

Assignment Task

Task 

Introduction
The aim of this project is to prepare, evaluate and analyse stock market data and to recommend an optimal portfolio consisting of two stocks. You have been assigned three stocks, all three must be included in the analysis which works towards your recommendation of a final optimal portfolio. The project requires a deep understanding of both the statistics and the mathematics components of this unit. It is recommended that you work on this on a weekly basis.

Refer to the rubric at the end of this document to understand how this assessment will be graded. In particular, note that all figures need to be numbered and labelled, and you need to include all the steps to involved with arriving at each of your answers.
Your final report should be a pdf document. An RMarkdown document to get you started is available on the unit Blackboard site. Show all of your coding by keeping echo = TRUE. Make sure to update your name and student ID in the YAML of the document.

1 Import Data
Import the adjusted stock prices for the three stocks which you have been assigned. See the Markdown file for hints.

2 The Analysis

2.1 Plot prices over time
Plot the prices of each asset over time separately. Succinctly describe in words the evolution of each asset over time. 

2.2 Calculate returns and plot returns over time
Calculate the daily percentage returns of each asset using the following formula:

Where Pt is the asset price at time t. Then plot the returns for each asset over time.Term Project

2.3 Histogram of returns
Create a histogram for each of the returns series (explain how you determined the number of bins to use).

2.4 Summary table of returns
Report the descriptive statistics in a single table which includes the mean, median, variance, standard deviation, skewness and kurtosis for each series. What conclusions can you draw from these descriptive statistics?

2.5 Are average returns significantly different from zero?
Under the assumption that the returns of each asset are drawn from an independently and identically distributed normal distribution, are the expected returns of each asset statistically different from zero at the 1% level of significance? Provide details for all 5 steps to conduct a hypothesis test, including the equation for the test statistic. Calculate and report all the relevant values for your conclusion and be sure to provide an interpretation of the results.

2.6 Are average returns different from each other?
Assume the returns of each asset are independent from each other. With this assumption, are the mean returns statistically different from each other at the 1% level of significance? Provide details for all 5 steps to conduct each of the hypothesis tests using what your have learned in the unit. Calculate and report all the relevant values for your conclusion and be sure to provide and interpretation of the results. (Hint: You need to discuss the equality of variances to determine which type of test to use.)

2.7 Correlations
Calculate and present the correlation matrix of the returns. Discuss the direction and strength of the correlations.

2.8 Testing the significance of correlations
Is the assumption of independence of stock returns realistic? Provide evidence (the hypothesis test including all 5 steps of the hypothesis test and the equation for the test statistic) and a rationale to support your conclusion.

2.9 Advising an investor
Suppose that an investor has asked you to assist them in choosing two of these three stocks to include in their portfolio. The portfolio is defined by

Where E(r) is the expected return of the portfolio, and Var(r) is the variance of the portfolio.1
Given your values forE(r1), E(r2), Var(r1), Var(r2) and Cov(r1, r2) which portfolio would you recommend to the investor? What is the expected return to this portfolio?
Provide evidence to support your answer, including all the steps undertaken to arrive at the result. (*Hint: review your notes from tutorial 6 on portfolio optimisation. A complete answer will include the optimal weights for each possible portfolio (pair of stocks) and the expected return for each of these portfolios.)

2.10 The impact of financial events on returns
Two significant financial events have occurred in recent history. On September 15, 2008 Lehman Brothers declared bankruptcy and a Global Financial Crisis started. On March 11, 2020 the WHO declared COVID-19 a pandemic. Use linear regression to determine if

a. Any of the stocks in your data exhibit positive returns over time.
b. Either of the two events had a significant impact on returns.

Report the regression output for each stock and interpret the results to address these two questions. How would you interpret this information in the context of your chosen portfolio?

This Statistics Assignment has been solved by our Statistics Expert at TV Assignment Help. Our Assignment Writing Experts are efficient to provide a fresh solution to this question. We are serving more than 10000+ Students in Australia, UK & US by helping them to score HD in their academics. Our Experts are well trained to follow all marking rubrics & referencing Style. Be it a used or new solution, the quality of the work submitted by our assignment experts remains unhampered. 

You may continue to expect the same or even better quality with the used and new assignment solution files respectively. There’s one thing to be noticed that you could choose one between the two and acquire an HD either way. You could choose a new assignment solution file to get yourself an exclusive, plagiarism (with free Turn tin file), expert quality assignment or order an old solution file that was considered worthy of the highest distinction.