An Investor Is Developing a Portfolio of Stocks

question 51

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 G4 of the Excel spreadsheet?

• A) =COVAR(B4:B13)
• B) =VARP(B4:B13)
• C) =COVAR(B4:D13,$D$4:$B$13)
• D) =COVAR(B4:B13,$B$4:$B$13)

Comprehend the strategies used by countries to protect domestic industries and promote technology transfer.

Analyze the factors contributing to a goods and services deficit.

Understand the key challenges and criticisms associated with administering workfare programs.

Comprehend the relationship between minimum wage earnings and the poverty line for families.

---

Definitions:

Pollution Free

An attribute of products, services, or practices that do not release harmful contaminants into the environment.

Clean Town

An initiative or effort to maintain a town or city in an environmentally friendly and litter-free condition.

Housing Prices

The amount of money required to purchase residential properties, influenced by factors such as location, demand, and economic conditions.

Indifference Principle

The indifference principle suggests that individuals have no preference between two or more equally satisfying options, reflecting a state of utility and choice.