Please show exce formulas

7 8 1 Part 1. Please calculate the monthly returns for both stocks first and then find their statistics Date Ford price GM price Ford return GM return 3 1-Nov-2013 1.77 35.82 4 2-Dec-2013 1.67 37.47 2-Jan-2014 1.65 39.23 6 3-Feb-2014 1.65 33.77 3-Mar-2014 1.71 34.69 1-Apr-2014 1.81 33.19 9 1-May-2014 1.65 33.73 10 2-Jun-2014 1.34 33.69 11 1-Jul-2014 1.19 36.63 12 1-Aug-2014 1.27 13 2-Sep-2014 1.28 33.91 1-Oct-2014 1.32 31.94 15 3-Nov-2014 1.24 30.65 16 1-Dec-2014 1.15 32.38 17 2-Jan-2015 1.03 34.56 18 2-Feb-2015 0.95 32.84 2-Mar-2015 0.94 37.3 1-Apr-2015 36.74 32.59 14 0.81 Average Variance Standard Deviation Compound monthly return Covariance Correlation 30 Part 2. Calculate the following statistics for the database, where Ford's returns are greater than -10% and GM's returns are less than 10% 31 Criterion range 32 Date Ford price GM price Ford return GM return >-10%