please show how to do 4 and 5 in excel

Estimated Return Distributions Estimated Total Return 4. Suppose an investor forms a stock portfolio by investing $10,000 in Gold Hill and $10,000 in TECO. a. What would be the porffolio's expected rate of return, standard deviation, and coefficient of variation? How does this compare with values for the individual stocks? What characteristic of the two investments makes risk reduction possible? b. What do you think would happen to the portfolio's expected rate of return and standard deviation if the portfolio contained 75 percent Gold Hill? If it contained 75 percent TECO? Use a spreadsheet model for this case to calculate the expected returns and standard deviations for a portfolio mix of 0 percent TECO, 10 percent TECO, 20 percent TECO, and so on, up to 100 percent TECO. 5. Now consider a portfolio consisting of $10,000 in TECO and $10,000 in the S\&P 500 Fund. Would this portfolio have the same risk-reducing effect as the Gold Hill-TECO portfolio considered in Question 4? Explain. Use a spreadsheet model to construct a portfolio using TECO and the S\&P 500 Fund. What are the expected returns and standard deviations for a portfolio mix of 0 percent TECO, 10 percent TECO, .0 percent TECO, and so on, up tc 100 percent TECO? Estimated Return Distributions Estimated Total Return 4. Suppose an investor forms a stock portfolio by investing $10,000 in Gold Hill and $10,000 in TECO. a. What would be the porffolio's expected rate of return, standard deviation, and coefficient of variation? How does this compare with values for the individual stocks? What characteristic of the two investments makes risk reduction possible? b. What do you think would happen to the portfolio's expected rate of return and standard deviation if the portfolio contained 75 percent Gold Hill? If it contained 75 percent TECO? Use a spreadsheet model for this case to calculate the expected returns and standard deviations for a portfolio mix of 0 percent TECO, 10 percent TECO, 20 percent TECO, and so on, up to 100 percent TECO. 5. Now consider a portfolio consisting of $10,000 in TECO and $10,000 in the S\&P 500 Fund. Would this portfolio have the same risk-reducing effect as the Gold Hill-TECO portfolio considered in Question 4? Explain. Use a spreadsheet model to construct a portfolio using TECO and the S\&P 500 Fund. What are the expected returns and standard deviations for a portfolio mix of 0 percent TECO, 10 percent TECO, .0 percent TECO, and so on, up tc 100 percent TECO