Create a gaussian random number generator in excel

Assignment Help Finance Basics

Reference no: EM131086887

Create a Gaussian Random Number Generator in Excel

This model will have two inputs: σ and μ. Use the inverse transform method to create a series of normal variables with a mean of μ and standard deviation of σ. Use the Histogram tool in the Data Analysis toolbox of Excel to create a density function for one static example or use the Excel array function "FREQUENCY (data array, bin array)" and CTRL-SHIFTENTER to create a density function for dynamic data. See Figures 3-5 to 3-8.

Make sure to normalize the histogram-generated density function.
Choose the bins and bin sizes carefully (try different ranges). They will depend on the mean and σ. Start by getting the MIN and MAX points of the generated random numbers and then divide the space in between them into a certain number of bins (say, 40). See equations (3.48) and (3.49).

Generate at least 65,000 random numbers.
Calculate the mean, standard deviation, and kurtosis of the generated random numbers. Compare them to the inputs. Did the process converge?

Reference no: EM131086887

Questions Cloud

Cryptographic tunneling and the osi model : Write a paper consisting of 500-1,000 words (double-spaced) on the security effects of cryptographic tunneling based on an understanding of the OSI (Open Systems Interconnect) model.

The spring stretched a distance x0 due to the weight of wire : The circuit has total resistance R. When the magnetic field is perpendicular to the plane of paper is switched on springs are observed to extend further by the same distance, the magnetic field strength is.

How would incident command system be used to accomplish goal : Establishing control of a terrorist scene and the surrounding area is very important for the safety of emergency responders. How would the Incident Command System (ICS) be used to accomplish this goal?

Contrast symmetric encryption to asymmetric encryption : Compare and contrast symmetric encryption to asymmetric encryption. PKI uses digital certificates to encrypt / decrypt data. Analyze the process of encrypting and decrypting data using a digital certificate.

Create a gaussian random number generator in excel : This model will have two inputs: σ and μ. Use the inverse transform method to create a series of normal variables with a mean of μ and standard deviation of σ.

Generation of control signals using hardwired : In computer architecture what is the difference between the concept of control points and the generation of control signals using hardwired or microprogrammed implementation?

Prepare a job applicant report : Design an algorithm to prepare a job applicant report. Input consists of a series of records that contain the social security number or equivalent, last name, first name, middle initial, verbal test score, science test score, math test score score..

Draw a ladder logic diagram that will turn on a light : Draw a ladder logic diagram that will turn on a light if one or more windows are open or if both doors are open.

Volume adjustment for pairs trading for mcd : Perform a rolling 60-day linear regression of volume adjusted returns of MCD versus XLY (MCD: McDonald's, XLY: Consumer Discretionary Sector SPDR ETF),

User Account

All Pages