Get Instant Help From 5000+ Experts For

Writing Get your essay and assignment written from scratch by PhD expert

Rewriting: Paraphrase or rewrite your friend's essay with similar meaning at reduced cost

# ECOM2001 Quantitative Techniques For Business 3

6 Pages / 1,419 Words Published On: 31-01-2020
Question:
Introduction

The aim of this project is to prepare, evaluate and analyse portfolios composed of four financial assets. It requires deep understanding of both the statistics and the mathematics components of the unit. You should be able to do parts of the project as the unit progresses. It is recommended that you work on a weekly basis.

Data

Download the stockprices_sem2_2018.csv from Blackboard. The file contains daily stock prices for Apple (AAPL), Hewlett Packard (HQP), Intel (INTC) and Microsoft (MSFT), sourced from www.nasdaq.com.

The Analysis
1. Plot the prices of each asset separately against time using software such as EXCEL or Tableau. Succinctly describe in words the historical time evolution of each of the four time series (limit: 100 words for each series).
1. Calculate the returns of each asset using thefollowing:

r  = 100ln (  Pt/t Pt–1 )

Where Pt is the asset price at time t. Plot the returns for each asset.

1. Create a histogram for each of the returns series. Also, report their descriptive statistics in a table including mean, median, mode, variance, standard deviation, skewness and kurtosis. What conclusion can you draw by examining the kurtosis in each case?
1. Under the assumption that the returns of each asset are drawn from an independently and identically distributed normal distribution, are the expected returns statistically different from zero for each asset? State clearly the null and alternative hypothesis in each case.
1. Assume the returns of each asset are independent from each other, are the mean returns statistically different from each other?
1. Calculate the correlation matrix of the returns.
1. Is the assumption of independence realistic? If not, re-test the hypotheses in Question 5 using appropriate test statistics. Compare the results to the results obtained in Question 5.
1. If you can only choose maximum of two assets into a portfolio, which will you choose? What are the optimal weights and the optimal expected returns? State clearly your objective function and provide step-by-step derivations.
1. Bonus question: Why is it not realistic to assume these prices follow a normal distribution?

Cite This Work

My Assignment Help (2020) ECOM2001 Quantitative Techniques For Business 3 [Online]. Available from: https://myassignmenthelp.com/free-samples/ecom2001-quantitative-techniques-for-business-3
[Accessed 05 June 2023].

My Assignment Help. 'ECOM2001 Quantitative Techniques For Business 3' (My Assignment Help, 2020) <https://myassignmenthelp.com/free-samples/ecom2001-quantitative-techniques-for-business-3> accessed 05 June 2023.

My Assignment Help. ECOM2001 Quantitative Techniques For Business 3 [Internet]. My Assignment Help. 2020 [cited 05 June 2023]. Available from: https://myassignmenthelp.com/free-samples/ecom2001-quantitative-techniques-for-business-3.

Stuck on Any Question

Writing Get your essay and assignment written from scratch by PhD expert

Rewriting: Paraphrase or rewrite your friend's essay with similar meaning at reduced cost

250 words
5% Cashback

On APP - grab it while it lasts!