Average Mean and Geometric Mean Assignment

find the average mean and geometric mean of the stocks, individual risks, CV, Beta

select the best stock to be included in the portfolio, the correlation for each pairing

•            find the coefficient of correlation for each pairing

•            Find the minimum variance portfolio for the best pairing

•            Find the portfolio return/risk for the best pairing

•            find portfolio return of all four/five stocks

•            find portfolio risk of all four/five stocks

And Sharpe/Treynor/Jensen model.

{Please show in excel. This is my assignment} [stocks, NYSE: Alibaba, Under Armor.][German: RWE, Zooplus] date- 30th September 2018 – 2nd January 2019

Date BABA RWE {pair 1} UA zooplus {pair 2}
01/10/2018 162 20.96 19.34 149.899994
02/10/2018 160.23 21.13 18.52 151.899994
03/10/2018 162.37 20.43 18.85 150.100006
04/10/2018 156.13 18.69 18.290001 148.5
05/10/2018 154.63 18.13 17.809999 145.399994
08/10/2018 151.14 17.67 17.68 143.300003
09/10/2018 146.94 17.105 17.719999 140.399994
10/10/2018 138.29 17.32 16.809999 139.100006
11/10/2018 141.9 17.52 16.82 138.699997
12/10/2018 147.29 17.475 17.27 136.899994
15/10/2018 144.16 17.62 17.309999 141.300003
16/10/2018 149.6 17.56 17.91 143.899994
17/10/2018 148.14 17.625 17.559999 143
18/10/2018 142.02 17.995 17.139999 144.399994
19/10/2018 142.93 18 16.799999 146.5
22/10/2018 148.8 17.725 17.040001 145.100006
23/10/2018 146.65 17.655 16.940001 147.5
24/10/2018 139.61 17.71 16.74 146.699997
25/10/2018 144.6 17.245 17.030001 145.899994
26/10/2018 142.87 17.295 16.549999 145.600006

Get Finance homework help today

Calculate the price
Make an order in advance and get the best price
Pages (550 words)
*Price with a welcome 15% discount applied.
Pro tip: If you want to save more money and pay the lowest price, you need to set a more extended deadline.
We know how difficult it is to be a student these days. That's why our prices are one of the most affordable on the market, and there are no hidden fees.

Instead, we offer bonuses, discounts, and free services to make your experience outstanding.
How it works
Receive a 100% original paper that will pass Turnitin from a top essay writing service
step 1
Upload your instructions
Fill out the order form and provide paper details. You can even attach screenshots or add additional instructions later. If something is not clear or missing, the writer will contact you for clarification.
Pro service tips
How to get the most out of your experience with Australia Assessments
One writer throughout the entire course
If you like the writer, you can hire them again. Just copy & paste their ID on the order form ("Preferred Writer's ID" field). This way, your vocabulary will be uniform, and the writer will be aware of your needs.
The same paper from different writers
You can order essay or any other work from two different writers to choose the best one or give another version to a friend. This can be done through the add-on "Same paper from another writer."
Copy of sources used by the writer
Our college essay writers work with ScienceDirect and other databases. They can send you articles or materials used in PDF or through screenshots. Just tick the "Copy of sources" field on the order form.
See why 20k+ students have chosen us as their sole writing assistance provider
Check out the latest reviews and opinions submitted by real customers worldwide and make an informed decision.
Good work. Looking foward to future contributions.
Customer 463463, October 29th, 2022
good job
Customer 456821, October 8th, 2022
English 101
Satisfactory. However, always go through instructions before submitting to identify omissions.
Customer 462843, April 11th, 2022
Great effort.
Customer 456821, May 11th, 2022
Customer 463001, June 21st, 2022
Good Job!
Customer 454777, July 8th, 2020
Customer 463473, November 14th, 2022
IT, Web
The new writer was amazing and followed the instructions perfectly! Thank you so much for tackling all requirements on short notice and a HUGE thank you to the support team for remaining in contact with me until a resolution was received.
Customer 452455, January 13th, 2023
Writer did do a good job in answering my question and assignment!
Customer 454777, July 8th, 2020
Excellent job.
Customer 456821, May 11th, 2022
Computer science
Excellent report.
Customer 462881, April 21st, 2022
Good job
Customer 456821, January 2nd, 2023
Customer reviews in total
Current satisfaction rate
3 pages
Average paper length
Customers referred by a friend
15% OFF your first order
Use a coupon FIRST15 and enjoy expert help with any task at the most affordable price.
Claim my 15% OFF Order in Chat