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

  Suppose x1 x2 xnnbsp is random sample from a distribution

suppose x1 x2 ... xnnbsp is random sample from a distribution with the ff. pdfnbsp fx 2xnbsp oltxlt1find the

  Hypothesis testing-mean number of customers

Your population mean has always been 9 customers per hour. The sample standard deviation is 4. The sample size is 25. The sample mean is 8.

  What can be said about the percentage of salaries

Professors at a local university earn an average salary of $80000 with a standard deviation of $6000. The salary distribution is approximately bell-shaped. What can be said about the percentage of salaries that are at least $74,000

  A basketball team at a university is composed of ten

a basketball team at a university is composed of ten players. the team is made up of players who play the position of

  An electrical engineer has two boxes containing different

an electrical engineer has two boxes containing different types of resistors. the first box contains 3 resistors of one

  A distribution has a mean of 110 and a standard deviation

a distribution has a mean of 110 and a standard deviation of 20 if nothing is known about the shape of distribution

  A food company wanted to know if the amount of taste

a food company wanted to know if the amount of taste enhancer added to one of its products has any effect. it ran a

  Determine whether the following statement is true or false

determine whether the following statement is true or false and justify your answer if e and f are mutually exclusive

  Construct a 95 confidence interval for the average amount

a major department store chain is interested in estimating the average amount its credit card customers spent on their

  Making confidence interval

Two teams of workers assemble automobile engines at a manufacturing plant in Michigan. Quality control personnel inspect a random sample of the teams assemblies and judge

  Over-identified case

Last chance for bonus points. In the over-identified case, we could estimate σ2 by fitting (6) to the data, and dividing the sum of the squared residuals by q - p. What's wrong with this idea?

  The number of calls received by a phone operator at an

the number of calls received by a phone operator at an emergency department between 10-11am has a poisson distribution

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