Estimate descriptive statistics for each investment

Assignment Help Basic Statistics
Reference no: EM131055865

Problem Description: It is a well known principle of finance that when investing, there is a trade off between risk and return, i.e. in order to earn a higher return, one must assume greater risk . Stock returns are calculated as the percentage change in price over a given period. Risk is measured by the variability (or volatility) of these returns. You are part of an analytical team working for a large investment bank. Management is considering two investments: A or B. Before doing so, they have asked your team to prepare a report on the risk and return profiles of these two investments. You will use descriptive statistics and your knowledge of continuous distributions to complete this task. The returns data (measured annually) for the two investments are given in the Excel file: investment Monday.xls Required:

a. Estimate descriptive statistics for each investment via Excel. Compare the two investments. Be sure to comment on the central tendency, variability and shape of these two investments (Note: use the most appropriate measure when comparing the variability of two distributions). Based on your findings, which investment would you choose and why?

b. For your chosen investment, assume that the returns are normally distributed with a mean and standard deviation (as estimated in (a) rounded to the nearest integer). Answer the following questions:

i. Find the probability that returns will exceed 55%

ii. Find the probability that returns will be between 22% and 36%

iii. Find the probability of making a loss

iv. If you are given a choice between the top 3% of returns and a return of 48%, which option would you choose? v. Between what two values of returns (symmetrically distributed around the mean) will 48.6% of all possible returns contained?

c. What are the limitations of your analysis?

Reference no: EM131055865

Questions Cloud

Population of all gasoline mileages : Suppose that the population of all gasoline mileages is normally distributed with mean µ = 31.5 mpg and standard deviation σ = 0.8 mpg. Let y denote a mileage randomly selected from this population. Find the probabilities:
Probability that a female customer : Furthermore, the data shows that 35% of the females who visited his store purchased a cell phone, while 20% of the males who visited his store purchased a cell phone. What is the probability that a female customer will purchase a cell phone?
Format and structure appropriate to the rhetorical situation : This assignment is intended to help you reflect in very specific detail on how your writing, critical thinking, critical reading, and visual literacy skills have developed over the course of the semester. Your audience for this project is me, your..
Confidence intervals for the population mean annual : A sample of 400 First time home buyers found that the mean of annual household income was $60,000 and the sample standard deviation in income was $14,500. Construct 95% confidence intervals for the population mean annual household income for the f..
Estimate descriptive statistics for each investment : Estimate descriptive statistics for each investment via Excel. Compare the two investments. Be sure to comment on the central tendency, variability and shape of these two investments
Complete within the contracted time period : A large construction firm estimates that 25% of the jobs that it manages are not completed within the contracted time period. It looks at a random sample of 8 jobs that it has managed.  a. What is the probability that less than 3 of the jobs were ..
Createa gantt chart from the work break down structure : Using the schedule data in the schedule table above, create a Gantt chart comparing actual versus planned schedule performance. Summarize in words what you see project status to beat this time.What do you predict regarding the final cost and final ..
Question regarding the withdrawals or deposits : After two years, he stops making monthly contributions, because the interest rate changes to 15% per year compounded every two months, if no withdrawals or deposits are made for 4 years, what will the balance be in this account?
Do an audit of the kgc ltd mine in png : HI6026 AUDITING AND ASSURANCE SERVICES - If the inherent risk of the KGC Ltd. mine in PNG is estimated as 80% and the control risk and detection risk are estimated at, respectively, 10% and 50%, should your audit firm accept the role of doing an au..

Reviews

Write a Review

Basic Statistics Questions & Answers

  A prize is hidden at random behind one of three doors if

a prize is hidden at random behind one of three doors. if you pick the correct door you get the prize that is behind

  A box contains 4 balls numbered 1 2 3 and 4 two balls will

a box contains 4 balls numbered 1 2 3 and 4. two balls will be drawn at random without replacement and the numbers in

  Terms of convergent subnets

Compactness can be characterized in terms of convergent subnets (e.g. Kelley, 1955, Theorem 5.2), but only for nonstrict subnets; see also Kelley (1955, p. 70 and Problem 2.E).

  What assumption tests should be used

What assumption tests should be used? A fifth grade science teacher want to know if there is a relationship between final exam scores and overall course points after adjusting for a quiz score.

  Standard deck without replacement

7 cards are drawn from a standard deck without replacement. What is the probability that at least one of the cards drawn is an ace? Express your answer as a fraction or a decimal number rounded to four decimal places.

  Find the z score on comparison distribution for sample score

The comparison distribution at which the null hypothesis should be rejected, (b) the Z score on the comparison distribution for the sample score, and (c) your conclusion. Assume that all populations are normally distributed.

  Organize the data in frequency distribution

The Quick Change Oil Company has a number of outlets in the Seattle area. The daily number of oil changes at outlet in past twenty days are:

  Relationship between the number of miles

A manager wishes to determine the relationship between the number of miles (in hundreds of miles) the manager's sales representatives travel per month and the amount of sales (in thousands of dollars) per month. Find the equation of the regression..

  Governance affects stock market liquidity identify

How Governance Affects Stock Market Liquidity Identify some of the key factors that can allow for stronger governance and therefore increase participation and trading activity in a stock market.

  Expected commercial value forcast

Expected Commercial Value Forcast

  Difference between the percentage of actual and expected

Apply the Law of Large Numbers: Explain how the following scenario is possible using a coin toss and fictitious data: As the number of trials increases

  Proportion of americans drink more than eight servings

Servings of water is approximately normally distributed with a standard deviation of 1.4 serving, what proportion of americans drink a. more than the recommended 8 servings.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd