Get Instant Help From 5000+ Experts For
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

Editing:Proofread your work by experts and improve grade at Lowest cost

loader
Phone no. Missing!

Enter phone no. to receive critical updates and urgent messages !

Add File

Error goes here

Files Missing!

Please upload all relevant files for quick & complete assistance.

Guaranteed Higher Grade!

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?
 
Download Sample Now

Earn back the money you have spent on the downloaded sample by uploading a unique assignment/study material/research material you have. After we assess the authenticity of the uploaded content, you will get 100% money back in your wallet within 7 days.

up arrow icon

Upload
Unique Document

Clipboard Icon

Document
Under Evaluation

wallet

Get Money
into Your Wallet

Total 6 pages

Cite This Work

To export a reference to this article please select a referencing stye below:

My Assignment Help. (2020). ECOM2001 Quantitative Techniques For Business 3. Retrieved from https://myassignmenthelp.com/free-samples/ecom2001-quantitative-techniques-for-business-3.

"ECOM2001 Quantitative Techniques For Business 3." My Assignment Help, 2020, https://myassignmenthelp.com/free-samples/ecom2001-quantitative-techniques-for-business-3.

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

Our best expert will help you with the answer of your question with best explanation.

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

Editing: Proofread your work by experts and improve grade at Lowest cost

question
We will use e-mail only for:

arrow Communication regarding your orders

arrow To send you invoices, and other billing info

arrow To provide you with information of offers and other benefits

Phone no. Missing!

Enter phone no. to receive critical updates and urgent messages !

loader
250 words
Error goes here

Error goes here

Files Missing!

Please upload all relevant files for quick & complete assistance.

Other Samples
icon
5% Cashback

On APP - grab it while it lasts!

Download app now (or) Scan the QR code

*Offer eligible for first 3 orders ordered through app!

screener
ribbon
callback request mobile
Have any Query?
close
Subtraction Payment required!

Only one step away from your solution of order no.