Purchase Solution

Use NORMSINV(RAND()) to generate spreadsheet

Not what you're looking for?

Ask Custom Question

Financial analysts often use the following model to characterize changes in stock prices:

Pt = Po*e^(u-0.5s^2)t+s*Z*t^0.5

where Po = current stock price
Pt - price at time t
u - mean (logarithmic) change of the stock price per unit time
s = (logarithmic) standard deviation of price change
Z = standard normal random variable

This model assumes that the logarithm of a stock's price is a normally distributed random variable. Using historical data, one can estimate the values for u and s. Suppose that the average daily change for a stock is $0.003227, and the standard deviation is 0.026154. Develop a spreadsheet to stimulate the price of the stock over the next 30 days, if the current price is $53. Use the Excel function NORMSINV(RAND()) to generate values for Z. Construct a chart showing the movement in the stock price.

See attached file.

Attachments
Purchase this Solution
Solution Summary

The solution provides detailed explanation how to Use NORMSINV(RAND()) to generate spreadsheet

Purchase this Solution
Free BrainMass Quizzes
Measures of Central Tendency

This quiz evaluates the students understanding of the measures of central tendency seen in statistics. This quiz is specifically designed to incorporate the measures of central tendency as they relate to psychological research.

Know Your Statistical Concepts

Each question is a choice-summary multiple choice question that presents you with a statistical concept and then 4 numbered statements. You must decide which (if any) of the numbered statements is/are true as they relate to the statistical concept.

Measures of Central Tendency

Tests knowledge of the three main measures of central tendency, including some simple calculation questions.

Terms and Definitions for Statistics

This quiz covers basic terms and definitions of statistics.

View More Free Quizzes
Related BrainMass Solutions

  • Multipling using Rand

    70880 Multipling using Rand Use Rand to produce 2 positive one digit integers. Please see the attached file.

  • Usnig the Excel countif function for estimated tire miles

    See the attached spreadsheet. It is a template used to help with randomization and uses the countif and rand functions. You will see the formulas laid out for you and come to use this template quite often.

  • Computer Languages to Generate Random Numbers

    247557 Computer Languages to Generate Random Numbers Most computer languages include a function that can be used to generate random numbers. In Excel, the RAND function can be used to generate random numbers between 0 and 1.

  • Calculations of Populations using Random-number generations

    Deviation = s = 80 Step 3: Generate 40 random numbers between 1 to 1000. Use RAND function, roundup the number for the third decimal place and mutiply by 1000. Step4: Pick the data number from the population for sample.

  • Java Programming with Commented Code

    You need to use at least one repetition statement, at least one array and the random method in this code. For generating random numbers you should use the random() static method of class Math.

  • Rand Company - Closing Entries

    Excel spreadsheet attached provides the closing entries and retained earning account to disclose ending balance for Rand Company.

  • Generating a Simple Random Sample

    Use Excel to generate a simple random sample of size 25 from the given frame. B. Compute the point estimate of the population mean from the sample selected in part a. What is the sampling error in this case?

  • frequency analysis using Matlab

    Question: What frequencies should we expect to see in the spectrum? Lab 5: Activity 1 (a). Generate a random input signal x(t) in MATLAB by using the command rand. In particular, let x = rand(1000,1)-0.5.

  • Convergence of probability value

    If you wanted to simulate coin tossing in Excel, you could use its =rand() function. rand() produces a random decimal number between 0 and 1.

View More Related Solutions