Elementary Statistics Using Excel (6th Edition)
Elementary Statistics Using Excel (6th Edition)
6th Edition
ISBN: 9780134506623
Author: Mario F. Triola
Publisher: PEARSON
bartleby

Videos

Question
Book Icon
Chapter 4.5, Problem 1BSC
To determine

Check whether the simulation behave in a way that is similar to actual dice.

Explain the answer.

Blurred answer
Students have asked these similar questions
In this problem, we consider a Brownian motion (W+) t≥0. We consider a stock model (St)t>0 given (under the measure P) by d.St 0.03 St dt + 0.2 St dwt, with So 2. We assume that the interest rate is r = 0.06. The purpose of this problem is to price an option on this stock (which we name cubic put). This option is European-type, with maturity 3 months (i.e. T = 0.25 years), and payoff given by F = (8-5)+ (a) Write the Stochastic Differential Equation satisfied by (St) under the risk-neutral measure Q. (You don't need to prove it, simply give the answer.) (b) Give the price of a regular European put on (St) with maturity 3 months and strike K = 2. (c) Let X = S. Find the Stochastic Differential Equation satisfied by the process (Xt) under the measure Q. (d) Find an explicit expression for X₁ = S3 under measure Q. (e) Using the results above, find the price of the cubic put option mentioned above. (f) Is the price in (e) the same as in question (b)? (Explain why.)
Problem 4. Margrabe formula and the Greeks (20 pts) In the homework, we determined the Margrabe formula for the price of an option allowing you to swap an x-stock for a y-stock at time T. For stocks with initial values xo, yo, common volatility σ and correlation p, the formula was given by Fo=yo (d+)-x0Þ(d_), where In (±² Ꭲ d+ õ√T and σ = σ√√√2(1 - p). дго (a) We want to determine a "Greek" for ỡ on the option: find a formula for θα (b) Is дго θα positive or negative? (c) We consider a situation in which the correlation p between the two stocks increases: what can you say about the price Fo? (d) Assume that yo< xo and p = 1. What is the price of the option?
We consider a 4-dimensional stock price model given (under P) by dẴ₁ = µ· Xt dt + йt · ΣdŴt where (W) is an n-dimensional Brownian motion, π = (0.02, 0.01, -0.02, 0.05), 0.2 0 0 0 0.3 0.4 0 0 Σ= -0.1 -4a За 0 0.2 0.4 -0.1 0.2) and a E R. We assume that ☑0 = (1, 1, 1, 1) and that the interest rate on the market is r = 0.02. (a) Give a condition on a that would make stock #3 be the one with largest volatility. (b) Find the diversification coefficient for this portfolio as a function of a. (c) Determine the maximum diversification coefficient d that you could reach by varying the value of a? 2

Chapter 4 Solutions

Elementary Statistics Using Excel (6th Edition)

Ch. 4.1 - In Exercises 9-12, assume that 50 births are...Ch. 4.1 - In Exercises 9-12, assume that 50 births are...Ch. 4.1 - In Exercises 13-20, express the indicated degree...Ch. 4.1 - 14. SAT Test When making a random guess for an...Ch. 4.1 - In Exercises 13-20, express the indicated degree...Ch. 4.1 - In Exercises 13-20, express the indicated degree...Ch. 4.1 - 17. Randomness When using a computer to randomly...Ch. 4.1 - Prob. 18BSCCh. 4.1 - Prob. 19BSCCh. 4.1 - Prob. 20BSCCh. 4.1 - In Exercises 21-24, refer to the sample data in...Ch. 4.1 - In Exercises 21-24, refer to the sample data in...Ch. 4.1 - In Exercises 21-24, refer to the sample data in...Ch. 4.1 - In Exercises 21-24, refer to the sample data in...Ch. 4.1 - In Exercises 25-32, find the probability and...Ch. 4.1 - In Exercises 25-32, find the probability and...Ch. 4.1 - Prob. 27BSCCh. 4.1 - Prob. 28BSCCh. 4.1 - Prob. 29BSCCh. 4.1 - Prob. 30BSCCh. 4.1 - Prob. 31BSCCh. 4.1 - In Exercises 25-32, find the probability and...Ch. 4.1 - Prob. 33BSCCh. 4.1 - Prob. 34BSCCh. 4.1 - Prob. 35BSCCh. 4.1 - Prob. 36BSCCh. 4.1 - Prob. 37BSCCh. 4.1 - Prob. 38BSCCh. 4.1 - Prob. 39BSCCh. 4.1 - Prob. 40BSCCh. 4.1 - Prob. 41BBCh. 4.1 - Prob. 42BBCh. 4.1 - Prob. 43BBCh. 4.1 - Prob. 44BBCh. 4.2 - 1. Notation When randomly selecting an adult, A...Ch. 4.2 - 2. Notation When randomly selecting adults, let M...Ch. 4.2 - 3. Sample for a Poll There are 15,524,971 adults...Ch. 4.2 - Prob. 4BSCCh. 4.2 - Prob. 5BSCCh. 4.2 - Prob. 6BSCCh. 4.2 - Prob. 7BSCCh. 4.2 - Prob. 8BSCCh. 4.2 - In Exercises 9-20, use the data in the following...Ch. 4.2 - In Exercises 9-20, use the data in the following...Ch. 4.2 - In Exercises 9-20, use the data in the following...Ch. 4.2 - In Exercises 9-20, use the data in the following...Ch. 4.2 - In Exercises 9-20; use the data in the following...Ch. 4.2 - Prob. 14BSCCh. 4.2 - In Exercises 9-20, use the data in the following...Ch. 4.2 - In Exercises 9-20, use the data in the following...Ch. 4.2 - In Exercises 9-20, use the data in the following...Ch. 4.2 - In Exercises 9-20, use the data in the following...Ch. 4.2 - In Exercises 9-20, use the data in the following...Ch. 4.2 - In Exercises 9-20, use the data in the following...Ch. 4.2 - Prob. 21BSCCh. 4.2 - Prob. 22BSCCh. 4.2 - Prob. 23BSCCh. 4.2 - In Exercises 21-24, use these results from the...Ch. 4.2 - Prob. 25BSCCh. 4.2 - Prob. 26BSCCh. 4.2 - Prob. 27BSCCh. 4.2 - Prob. 28BSCCh. 4.2 - Prob. 29BSCCh. 4.2 - Prob. 30BSCCh. 4.2 - Prob. 31BBCh. 4.2 - 32. Same Birthdays If 25 people are randomly...Ch. 4.2 - Prob. 33BBCh. 4.2 - Prob. 34BBCh. 4.3 - 1. Language: Complement of “At Least One” Let A =...Ch. 4.3 - 2. Probability of At Least One Let A = the event...Ch. 4.3 - 3. Notation When selecting one of your Facebook...Ch. 4.3 - 3. Notation When selecting one of your Facebook...Ch. 4.3 - At Least One. In Exercises 5-12, find the...Ch. 4.3 - 6. Probability of a Girl Assuming that boys and...Ch. 4.3 - At Least One. In Exercises 5-12, find the...Ch. 4.3 - At Least One. In Exercises 5-12, find the...Ch. 4.3 - At Least One. In Exercises 5-12, find the...Ch. 4.3 - At Least One. In Exercises 5-12, find the...Ch. 4.3 - Prob. 11BSCCh. 4.3 - At Least One. In Exercises 5-12, find the...Ch. 4.3 - Denomination Effect. In Exercises 13-16, use the...Ch. 4.3 - Prob. 14BSCCh. 4.3 - Prob. 15BSCCh. 4.3 - Denomination Effect. In Exercises 13-16, use the...Ch. 4.3 - Prob. 17BSCCh. 4.3 - In Exercises 17-20, refer to the accompanying...Ch. 4.3 - Prob. 19BSCCh. 4.3 - Prob. 20BSCCh. 4.3 - Prob. 21BSCCh. 4.3 - Prob. 22BSCCh. 4.3 - Prob. 23BSCCh. 4.3 - 24. Composite Water Samples The Fairfield County...Ch. 4.3 - Prob. 25BBCh. 4.4 - 1. Notation What does the symbol ! represent? Six...Ch. 4.4 - Prob. 2BSCCh. 4.4 - Prob. 3BSCCh. 4.4 - Prob. 4BSCCh. 4.4 - In Exercises 5–36, express all probabilities as...Ch. 4.4 - 6. Social Security Numbers A Social Security...Ch. 4.4 - Prob. 7BSCCh. 4.4 - 8. Soccer Shootout In soccer, a tie at the end of...Ch. 4.4 - 9. Grading Exams Your professor has just collected...Ch. 4.4 - 10. Radio Station Call Letters If radio station...Ch. 4.4 - 11. Scheduling Routes A presidential candidate...Ch. 4.4 - 12. Survey Reliability A survey with 12 questions...Ch. 4.4 - Prob. 13BSCCh. 4.4 - Prob. 14BSCCh. 4.4 - Prob. 15BSCCh. 4.4 - Prob. 16BSCCh. 4.4 - Prob. 17BSCCh. 4.4 - Prob. 18BSCCh. 4.4 - 19. ZIP Code If you randomly select five digits,...Ch. 4.4 - Prob. 20BSCCh. 4.4 - Prob. 21BSCCh. 4.4 - Prob. 22BSCCh. 4.4 - Prob. 23BSCCh. 4.4 - Prob. 24BSCCh. 4.4 - Prob. 25BSCCh. 4.4 - Prob. 26BSCCh. 4.4 - Prob. 27BSCCh. 4.4 - Prob. 28BSCCh. 4.4 - 29. Mega Millions As of this writing, the Mega...Ch. 4.4 - Prob. 30BSCCh. 4.4 - Prob. 31BSCCh. 4.4 - Prob. 32BSCCh. 4.4 - Prob. 33BSCCh. 4.4 - Prob. 34BSCCh. 4.4 - Prob. 35BSCCh. 4.4 - Prob. 36BSCCh. 4.4 - Prob. 37BBCh. 4.4 - Prob. 38BBCh. 4.5 - Simulating Dice When two dice are rolled, the...Ch. 4.5 - Prob. 2BSCCh. 4.5 - Prob. 3BSCCh. 4.5 - Prob. 4BSCCh. 4.5 - Prob. 5BSCCh. 4.5 - Prob. 6BSCCh. 4.5 - Prob. 7BSCCh. 4.5 - Prob. 8BSCCh. 4.5 - Prob. 9BSCCh. 4.5 - Prob. 10BSCCh. 4.5 - Prob. 11BSCCh. 4.5 - Prob. 12BSCCh. 4.5 - Prob. 13BSCCh. 4.5 - Prob. 14BSCCh. 4.5 - Prob. 15BSCCh. 4.5 - Prob. 16BSCCh. 4.5 - Prob. 17BBCh. 4.5 - Prob. 18BBCh. 4 - Prob. 1CQQCh. 4 - Prob. 2CQQCh. 4 - Prob. 3CQQCh. 4 - Prob. 4CQQCh. 4 - Prob. 5CQQCh. 4 - Prob. 6CQQCh. 4 - Prob. 7CQQCh. 4 - Prob. 8CQQCh. 4 - Prob. 9CQQCh. 4 - Prob. 10CQQCh. 4 - Prob. 1RECh. 4 - In Exercises 1–10, use the data in the...Ch. 4 - In Exercises 1–10, use the data in the...Ch. 4 - Prob. 4RECh. 4 - Prob. 5RECh. 4 - Prob. 6RECh. 4 - Prob. 7RECh. 4 - Prob. 8RECh. 4 - Prob. 9RECh. 4 - Prob. 10RECh. 4 - Prob. 11RECh. 4 - Prob. 12RECh. 4 - Prob. 13RECh. 4 - Prob. 14RECh. 4 - Prob. 15RECh. 4 - Prob. 16RECh. 4 - Prob. 17RECh. 4 - Prob. 18RECh. 4 - Prob. 1CRECh. 4 - Prob. 2CRECh. 4 - Prob. 3CRECh. 4 - Prob. 4CRECh. 4 - Prob. 5CRECh. 4 - Prob. 6CRECh. 4 - Prob. 1EPCh. 4 - Prob. 1FDDCh. 4 - Prob. 2FDDCh. 4 - Prob. 3FDDCh. 4 - Prob. 4FDDCh. 4 - Prob. 5FDDCh. 4 - Prob. 6FDDCh. 4 - Prob. 7FDDCh. 4 - Prob. 8FDDCh. 4 - Prob. 9FDD
Knowledge Booster
Background pattern image
Statistics
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, statistics and related others by exploring similar questions and additional content below.
Similar questions
SEE MORE QUESTIONS
Recommended textbooks for you
Text book image
MATLAB: An Introduction with Applications
Statistics
ISBN:9781119256830
Author:Amos Gilat
Publisher:John Wiley & Sons Inc
Text book image
Probability and Statistics for Engineering and th...
Statistics
ISBN:9781305251809
Author:Jay L. Devore
Publisher:Cengage Learning
Text book image
Statistics for The Behavioral Sciences (MindTap C...
Statistics
ISBN:9781305504912
Author:Frederick J Gravetter, Larry B. Wallnau
Publisher:Cengage Learning
Text book image
Elementary Statistics: Picturing the World (7th E...
Statistics
ISBN:9780134683416
Author:Ron Larson, Betsy Farber
Publisher:PEARSON
Text book image
The Basic Practice of Statistics
Statistics
ISBN:9781319042578
Author:David S. Moore, William I. Notz, Michael A. Fligner
Publisher:W. H. Freeman
Text book image
Introduction to the Practice of Statistics
Statistics
ISBN:9781319013387
Author:David S. Moore, George P. McCabe, Bruce A. Craig
Publisher:W. H. Freeman
12. Searching and Sorting; Author: MIT OpenCourseWare;https://www.youtube.com/watch?v=6LOwPhPDwVc;License: Standard YouTube License, CC-BY
Algorithms and Data Structures - Full Course for Beginners from Treehouse; Author: freeCodeCamp.org;https://www.youtube.com/watch?v=8hly31xKli0;License: Standard Youtube License