Solved

An Investor Is Developing a Portfolio of Stocks

Question 44

Multiple Choice

An investor is developing a portfolio of stocks. She has identified 3 stocks to invest in. She wants to earn at least 5% return but with minimum risk. The problem data is given in the following Excel spreadsheet. What formula should be entered in cell H11 of the Excel spreadsheet? An investor is developing a portfolio of stocks. She has identified 3 stocks to invest in. She wants to earn at least 5% return but with minimum risk. The problem data is given in the following Excel spreadsheet. What formula should be entered in cell H11 of the Excel spreadsheet? A) =SUMPRODUCT(B15:D15,G9:I9) B) =SUMPRODUCT(B15:D15,B4:D13) C) =SUMPRODUCT(B15:D15,I9) D) =SUMPRODUCT(B15:D15,G4:I6) An investor is developing a portfolio of stocks. She has identified 3 stocks to invest in. She wants to earn at least 5% return but with minimum risk. The problem data is given in the following Excel spreadsheet. What formula should be entered in cell H11 of the Excel spreadsheet? A) =SUMPRODUCT(B15:D15,G9:I9) B) =SUMPRODUCT(B15:D15,B4:D13) C) =SUMPRODUCT(B15:D15,I9) D) =SUMPRODUCT(B15:D15,G4:I6)


A) =SUMPRODUCT(B15:D15,G9:I9)
B) =SUMPRODUCT(B15:D15,B4:D13)
C) =SUMPRODUCT(B15:D15,I9)
D) =SUMPRODUCT(B15:D15,G4:I6)

Correct Answer:

verifed

Verified

Unlock this answer now
Get Access to more Verified Answers free of charge

Related Questions

Q36: In NLP a local optimum is best

Q40: A company wants to locate a new

Q41: Calculate the annual inventory costs for the

Q41: When using the GRG algorithm to solve

Q43: An office supply company is attempting to

Q46: <br>The following questions pertain to the problem

Q49: Which point or points are global optima

Q64: In the GRG algorithm the initial solution

Q81: The Reduced Gradient is similar to which

Q87: The main difference between LP and NLP