Refer to the research paper "THE PROFESSOR SELECTS A PORTFOLIO" by professor Peter C. Bell and answer the following questions below:

How should a professor select a Portfolio along with each type of objective also identify what fraction of portfolio devoted to each company? How are covariations handled in this situation? Estimate all reasonable objectives of portfolio selection? What assumptions are critical to validity of this method? Use SOLVER and optimize the Portfolio under following Objectives o Maximize yield o Maximize yield subject to risk =< R o Minimum Risk o Probability of loss