Question: Write a VBA program which reproduces the lognormal frequency distribution for an arbitrary number of runs. That is, this program should Produce N normal

Write a VBA program which reproduces the lognormal frequency distribution for an arbitrary number of runs. That is, this program should

• Produce N normal random deviates.

• For each deviate produce a lognormal price relative exp [μΔt + σZ√Δt].

• Classify each price relative into a set of bins running from 0, 0.1, … , 3.

• Put the frequencies on the spreadsheet and produce a frequency graph such as the one in section 26.5.

Step by Step Solution

★★★★★

3.46 Rating (153 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

Sub LognormalDistribution Dim N As Integer Dim i As Intege... View full answer

blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Financial Modeling Questions!

Q:

In this assignment, you are writing a program that converts common texting abbreviations to English words to allow people like yours truly can understand. For the assignment, you are provided with a...

Q:

An energetic student can manage to get 9 sled runs down a hill, on average, within a 30 minute time period. a. Find an upper bound on the probability that the student achieves 12 or more runs during...

Q:

This exercise continues the study of the robustness of the Students t method for constructing confidence intervals. The following figure shows graphs of probability density functions for the N(0, 1)...

Q:

Write a program (either in VBA or R) that reproduces the lognormal frequency distribution for an arbitrary number of runs. That is, this program should: Produce N normal random deviates. For each...

Q:

1. A player throws a fair die and simultaneously flips a fair coin. If the coin lands heads, then she wins twice, and if tails, then one-half of the value that appears on the die. Determine her...

Q:

CHAPTER 9 Hypothesis Tests CONTENTS 9.4 POPULATION MEAN: UNKNOWN One-Tailed Test Two-Tailed Test Summary and Practical Advice 9.5 POPULATION PROPORTION Summary 9.6 HYPOTHESIS TESTING AND DECISION...

Q:

Need Help With This Table Need Help With This Table 1: Files to be Submitted Class/FileName Description MyList Interface for ArrayList MyAbstractList Abstract Parent for ArrayList MyArrayList Program...

Q:

Need Help With This Table 1: Files to be Submitted Class/FileName Description MyList Interface for ArrayList MyAbstractList Abstract Parent for ArrayList MyArrayList Program uses 3 ArrayLists: (1):...

Q:

Microkernel operating systems aim to address perceived modularity and reliability issues in traditional "monolithic" operating systems. (i) Describe the typical architecture of a microkernel...

Q:

1. Calculate the sample size needed given these factors: one-tailed t-test with two independent groups of equal size small effect size (see Piasta, S.B., & Justice, L.M., 2010) alpha =.05 beta = .2...

Q:

I) As part of a consistent journey to enhance the loss absorption capacity and resilience of the banks through increasing the capital and improving the quality thereof, Bangladesh Bank has given...

Q:

In the recent past, Zambia, which is a net importing economy has passed through some serious macroeconomic turbulences and balance of payment challenges. Under a floating exchange rate regime, a...

Q:

Elaborate CPM model.

Q:

5.3 In a manufacturing plant, workers use a specialized machine to produce belts. A new labor-saving machine is introduced. With the new machine, the firm uses fewer workers to produce the same...

Q:

In the following table you will fi nd annual return data for six furniture companies between the years 1982 and 1992. Use these data to calculate the variancecovariance matrix of the returns. A B 1 E...

Q:

Calculate the envelope set for the following four assets and show that the individual assets all lie within this envelope set. You should get a graph which looks something like the following: A B C...

Q:

Consider the following data for six furniture companies: a. Given this matrix, and assuming that the risk-free rate is 0 percent, calculate the effi cient portfolio of these six fi rms. b. Repeat,...

Q:

A color code personality test categorizes people into four colors - Red (Power), Blue (Intimacy), Green (Peace), and Yellow (Fun). In general, 25% of people are Red, 35% Blue, 20% Green, and 20%...

Q:

You manage an equity fund with an expected risk premium of 11.6% and a standard deviation of 30%. The rate on Treasury bills is 6.2%. Your client chooses to invest $60,000 of her portfolio in your...

Q:

Cautions about correlation A data set was graphed using a scatterplot 30 25 20 15 10 5 0 5 10 15 20 25 30 The correlation coefficient, r, is 0.813 Which of the following statements explains how the...