Hi can you please solve this and show step by step how to? you can do it Via Excel. Thank you again kindly.

Assume you wish to evaluate the risk and return behaviors associated with various combinations of two stocks, Alpha Software and Beta Electronics, under three possible degrees of correlation: perfect positive, uncorrelated, and perfect negative. The average return and standard deviation for each stock appears here: a. If the returns of assets Alpha and Beta are perfectly positively correlated (correlation coefficient = +1), over what range would the average return on portfolios of these stocks vary? In other words, what is the highest and lowest average return that different combinations of these stocks could achieve? What is the minimum and maximum standard deviation that portfolios Alpha and Beta could achieve? b. If the returns of assets Alpha and Beta are uncorrelated (correlation coefficient = 0), over what range would the average return on portfolios of these stocks vary? What is the standard deviation of a portfolio that invests 75% in Alpha and 25% in Beta? How does this compare to the standard deviations of Alpha and Beta alone? c. If the returns of assets Alpha and Beta are perfectly negatively correlated (correlation coefficient = -1), over what range would the average return on portfolios of these stocks vary? Calculate the standard deviation of a portfolio that invests 62.5% in Alpha and 37.5% Beta C. a. If the returns of assets Alpha and Beta are perfectly positively correlated (correlation coefficient = +1), the range is between 1% and % (Round to one decimal place.) The range of the standard deviation is between % and % (Round to one decimal place.) b. If the returns of assets Alpha and Beta are uncorrelated (correlation coefficient = 0), the range is between % and % (Round to one decimal place.) The standard deviation of a portfolio that invests 75% in Alpha and 25% in Beta is %. (Round to two decimal places.) c. If the returns of assets Alpha and Beta are perfectly negatively correlated (correlation coefficient = -1), the range isbetween % and % (Round to one decimal place.) The standard deviation of a portfolio that invests 62.5% in Alpha Alpha and 37.5% in Beta is%. (Round to two decimal places.) Data table (Click on the icon here in order to copy its contents of the data table below into a spreadsheet.) Asset Alpha Average Return, 5.3% 10.3% Risk (Standard Deviation), s 29.2% 50.5% Beta Print Done