Does your answer to Q2 approximately equal your answer to Q3? Why or why not? Explain in detail.


Question: Generate 10,000 random cash flow values (i.e., x values) such that the probability of getting an x value in any fixed x interval between 1.2 and 3.7 is a constant. Use Excel's RAND() function. You will modify it by adding a number and/or multiplying by another number. Just fiddle with it and you can figure it out. After entering 10,000 data points be sure to copy them and then paste them “by value" to keep them from changing every time you change anything on the spreadsheet.

What is the average value and standard deviation of your 10,000 data points?

Price: $2.99
Solution: The solution consists of 1 page
Deliverables: Word Document

log in to your account

Don't have a membership account?
REGISTER

reset password

Back to
log in

sign up

Back to
log in