Calculate the mean variance and standard deviation

Assignment Help Other Subject

Reference no: EM133720787

Problem: Mutual Fund Performance Analysis

Using your Excel skills, calculate the mean, variance, standard deviation, Sharpe Ratio, and the compound return of one of the mutual funds (Pioneer, Alkeon, and Cullen EE) and the funds' indexes.

While we haven't necessarily covered all of the calculations, do some basic research on the interpretation of the findings In your excel file for each and explain your findings (especially about performance Sharpe ratio and alpha relative to its index).

Also, find the Jensen's alpha showing excess return (ie. Alpha). Upload your excel solution.

The Compound Return is a little difficult to find in the text. In order to help you in this endeavor, please use:

Compound Return: Average Return - (0.5 * Standard Deviation ^ 2).

Reference no: EM133720787

Questions Cloud

What device do you use to access the internet most often : What device do you use to access the Internet most often? What is Fear of Missing Out (FOMO) and how has social media played a part in it?

What mistakes did hudson make : What mistakes did Hudson make? What are the lessons to be learned from this case - He was confident that he had the requisite technical expertise to excel

Concept of double consciousness : The term double consciousness indicates that we have to be vigilant and stay informed about the policies and practices of law enforcement.

Explain how medicaid has influenced health industry : Explain how Medicaid has influenced the health industry. Decreased the incidence of diabetes in elderly people Improved health care access for individuals

Calculate the mean variance and standard deviation : Using your Excel skills, calculate the mean, variance, standard deviation, Sharpe Ratio and compound return of one of the mutual funds and the funds' indexes.

Propose why health policy is important for americans : Propose why health policy is important for Americans. For pregnant women to receive guideline-directed prenatal care

Briefly describe one disorder of consciousness : Briefly describe one disorder of consciousness or executive function and explain its possible neurology and treatment methods.

Predict the impact that environmental health policy : Predict the impact that environmental health policy has on the health care industry. People who are living in cities with contaminated water supply spend less m

Calculate accurate financial formulas : Calculate accurate financial formulas to assess the business's current financial health. Specifically, calculate the following formulas using the Ratios

User Account

All Pages