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
Pages (550 words)
\$0.00
*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
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.
Testimonials
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
Military
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
Military
Great effort.
Customer 456821, May 11th, 2022
History
GOOD WORK.
Customer 463001, June 21st, 2022
Ethics
Good Job!
Customer 454777, July 8th, 2020
Retail
great
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
Ethics
Writer did do a good job in answering my question and assignment!
Customer 454777, July 8th, 2020
Military
Excellent job.
Customer 456821, May 11th, 2022
Computer science
Excellent report.
Customer 462881, April 21st, 2022
Military
Good job
Customer 456821, January 2nd, 2023
11,595
Customer reviews in total
96%
Current satisfaction rate
3 pages
Average paper length
37%
Customers referred by a friend