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

  Investment portfolio diagram for three stocks

Expand the above table to show the change in Ms A's investment portfolio over the year, and construct a suitable diagram to illustrate that information.

  Problem regarding the global transportation

What risks and perils are present in global transportation? Discuss how exporters and importers can manage these risks.

  Significant effect on aggression using an alpha level

Does drug have significant effect on aggression? Use an alpha level of .05, two tails.

  Conclusion as type one-two error or a correct decision

Suppose that the null hypothesis is rejected and alternate hypothesis is accepted. Discuss the conclusion as a Type I error, a Type II error, or a correct decision, if in fact the defendant is innocent.

  What is the margin of error

A quality control inspector wants to determine the percentage of cracked eggs (not broken, just cracked) sold in a store. The inspector checked 3 cartoons (36 eggs) of eggs and found two eggs that were cracked. Determine a 90% confidence interv..

  Given the monthly incomes for 16 randomly selected people

given the monthly incomes for 16 randomly selected people with a bachelors degree in business4832.15 5222.36 4917.71

  Hypothesis testing of pie company

A pie company claims that the number of pies it sells daily is 1600. The President of the company wants to test the accuracy of this claim. He finds a random sample of 36 days' sales shows that the average daily sales were 1500 pies.

  Probability that newspaper-s sample will lead to defeat

Suppose the budget has the support of 52% of the voters. What is the probability that the newspaper's sample will lead it to predict defeat?

  Pairwise differences and make a normal probability

Calculate the pairwise differences and make a normal probability plot of them for each test procedure (wash/no wash). For each of the two test methods test to see if there is a change in ratings over time. Test, using a = 0.05, and explain what..

  Customers arrive at a thrift bank according to a poisson

customers arrive at a thrift bank according to a poisson distribution with a mean of 45 customers per hour.

  We break a stick at a uniformly chosen random location find

we break a stick at a uniformly chosen random location. find the probability that the shorter piece is less than 15th

  You are asked if there is a real difference between the

a researcher conducts a study of asians and hispanics attitudes toward the police in her community. the percentage of

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