Create a user-defined function to calculate the standard deviation of a two-security portfolio using equation (14-6) on page 431. Use the following data to test your function:
a) Write the function to accept five arguments: the weight of the first and the second security, the correlation coefficient between them, and the standard deviation of each one of them. Call this function TwoSecurityStdDevA.
b) Rewrite your function so that it makes use of Application.WorksheetFunction to calculate the standard deviation of each security and the correlation coefficient between them.
You might also like to view...
The manner of reporting cash flows from investing and financing activities will be different under the direct methodas compared to the indirect method
a. True b. False Indicate whether the statement is true or false
When the value of a country's imports exceeds the value of its exports, the country has a(n) ________
A) industrial economy B) exchange control C) trade surplus D) trade deficit E) post-industrial economy
Which of the following would be considered a stationary source of air pollution?
A) aircrafts B) oil rigs C) cargo ships D) automobiles
Tim is preparing the promotional plan for Jansport backpacks in early May. This promotion will be executed in the month of August and will be a paid form of nonpersonal communication. It will be communicated to a target audience through mass media. Tim is using the ___ form of promotion.
A. advertising B. public relations C. sales promotion D. personal selling E. social media