Question 9 The Security Market Line (SML) can be found in Excel by: 1 pts Running a regression of one security's returns on another security's returns. Calculating the expected returns of different securities based on their betas using the CAPM formula and then inserting a scatter plot which has beta as its x-axis and the expected return as its y-axis. Using the 'Solver' tool with different constraints on beta. Running a regression of the different securities' betas and their variances.

The Security Market Line (SML) can be found in Excel by: Running a regression of one security's returns on another security's returns. Calculating the expected returns of different securities based on their betas using the CAPM formula and then inserting a scatter plot which has beta as its x-axis and the expected return as its y-axis. Using the 'Solver' tool with different constraints on beta. Running a regression of the different securities' betas and their variances. The Security Market Line (SML) can be found in Excel by: Running a regression of one security's returns on another security's returns. Calculating the expected returns of different securities based on their betas using the CAPM formula and then inserting a scatter plot which has beta as its x-axis and the expected return as its y-axis. Using the 'Solver' tool with different constraints on beta. Running a regression of the different securities' betas and their variances