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

  Statistics-probability assignment

MATH1550H: Assignment:  Question:  A word is selected at random from the following poem of Persian poet and mathematician Omar Khayyam (1048-1131), translated by English poet Edward Fitzgerald (1808-1883). Find the expected value of the length of th..

  What is the least number

MATH1550H: Assignment:  Question:     what is the least number of applicants that should be interviewed so as to have at least 50% chance of finding one such secretary?

  Determine the value of k

MATH1550H: Assignment:  Question:     Experience shows that X, the number of customers entering a post office during any period of time t, is a random variable the probability mass function of which is of the form

  What is the probability

MATH1550H: Assignment:Questions: (Genetics) What is the probability that at most two of the offspring are aa?

  Binomial distributions

MATH1550H: Assignment:  Questions:  Let’s assume the department of Mathematics of Trent University has 11 faculty members. For i = 0; 1; 2; 3; find pi, the probability that i of them were born on Canada Day using the binomial distributions.

  Caselet on mcdonald’s vs. burger king - waiting time

Caselet on McDonald’s vs. Burger King - Waiting time

  Generate descriptive statistics

Generate descriptive statistics. Create a stem-and-leaf plot of the data and box plot of the data.

  Sampling variability and standard error

Problems on Sampling Variability and Standard Error and Confidence Intervals

  Estimate the population mean

Estimate the population mean

  Conduct a marketing experiment

Conduct a marketing experiment in which students are to taste one of two different brands of soft drink

  Find out the probability

Find out the probability

  Linear programming models

LINEAR PROGRAMMING MODELS

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