Please complete this assignment as an Excel file - you can use Excel to solve for these problems using processes presented in the text (e.g. see Tables 8.3 and 8.4) and on the PowerPoint slideshows; you do not have to use Excel functions for each of these questions. Problem 1 Hint: this problem includes the calculation of a standard deviation for a probability distribution and will require the use of Formula 8.3 A stock's return has the following distribution: Probability of this Demand Occurring 10% Demand for the Rate of Return if This Demand Occurs Company's Products Weak (50.0%) (5.0%) 16.0% Below average 20% Average Above average Strong 40% 20% 25.0% 10% 60.0% 100% Calculate the stock's expected return, standard deviation and coefficient of variation