1. Calculate the probability for price gains and losses based on the 4th quarter of 2021
2. Calculate the joint probabilities for the 4th quarter gains and losses for 2022.
Attached is the data set (Focusing on Wells Fargo)
A B C D E F G H 1 Stock prices of major US banks (Hypothetical data) N W Major US Banks 4 Period BOA Citibank Chase PNC Wells Fargo 5 6-Nov-20 91.45 79.82 91.56 91.48 74.18 6 13-Nov-20 92.08 81.32 90.83 89.11 79.80 7 20-Nov-20 90.57 70.33 97.03 88.54 90.91 8 27-Nov-20 34.34 84.91 105.79 93.94 92.66 9 4-Dec-20 90.10 89.62 78.30 94.23 97.12 10 11-Dec-20 89.29 89.11 84.16 89.91 96.97 11 18-Dec-20 95.41 89.91 95.05 80.81 100.54 12 25-Dec-20 100.56 87.50 95.19 97.03 86.79 13 1-Jan-21 103.64 89.91 90.38 82.08 102.31 14 8-Jan-21 84.85 92.31 95.19 91.09 97.12 15 15-Jan-21 88.07 75.25 89.42 87.16 97.25 16 22-Jan-21 110.87 88.68 103.24 94.34 90.83 17 29-Jan-21 95.41 67.89 97.03 97.03 97.17 18 5-Feb-21 92.86 82.57 95.41 83.96 106.29 19 12-Feb-21 95.54 83.65 94.95 94.50 88.78 20 19-Feb-21 95.41 91.09 95.19 97.25 108.51 21 26-Feb-21 95.41 88.54 90.38 94.64 120.41 22 5-Mar-21 95.19 82.83 95.19 86.79 132.16 23 12-Mar-21 90.10 80.77 94.19 71.70 91.74 24 19-Mar-21 90.83 83.65 94.38 73.39 92.66 25 26-Mar-21 85.32 91.74 110.86 83.49 97.12 26 2-Apr-21 97.25 80.77 91.96 91.09 104.82 27 9-Apr-21 95.41 82.08 81.13 91.74 114.93 28 16-Apr-21 95.41 91.51 115.37 97.25 124.51 29 23-Apr-21 90.10 83.96 84.27 79.82 101.94 30 30-Apr-21 95.19 94.23 95.54 83.96 94.23 31 7-May-21 94.79 83.65 97.32 80.20 100.53 US Banks + Ready Accessibility: Good to goHome Insert Draw Page Layout Formulas Data Review View Times New Roman 12 v AA Paste B I UV UV A v E 656 X V fx A B C D E F G 5 22-Oct-21 99.94 86.21 96.52 97.25 97.12 6 29-Oct-21 92.35 86.24 78.87 97.17 94.50 7 5-Nov-21 99.23 74.71 78.40 94.50 98.94 8 12-Nov-21 79.53 89.41 83.45 82.57 97.25 9 19-Nov-21 81.26 86.90 92.90 94.23 103.76 0 26-Nov-21 99.86 76.76 99.80 94.34 109.81 3-Dec-21 94.48 76.99 83.95 86.79 97.12 2 10-Dec-21 97.43 78.32 99.97 89.91 116.31 17-Dec-21 67.85 85.49 88.71 91.35 108.63 24-Dec-21 93.20 93.87 78.75 94.34 101.13 31-Dec-21 88.62 85.49 80.47 72.48 94.02 6 UT 00 9Times New Roman 12 AA ap Wrap Text v Paste F E Merge & Center G56 A B C D E F G H 31 7-May-21 94.79 83.65 97.32 80.20 100.53 32 14-May-21 120.25 94.50 118.48 81.65 83.49 33 21-May-21 89.90 94.23 97.32 77.57 107.86 34 28-May-21 84.38 81.65 132.82 85.15 106.23 35 4-Jun-21 94.95 82.57 124.38 84.40 94.06 36 11-Jun-21 96.97 81.83 99.99 90.82 104.24 37 18-Jun-21 91.92 89.79 99.76 97.12 94.06 38 25-Jun-21 89.58 90.34 110.59 94.06 113.40 39 2-Jul-21 87.88 93.39 93.77 94.06 121.64 40 9-Jul-21 94.79 90.72 99.26 84.40 98.53 41 16-Jul-21 102.93 83.01 99.95 89.62 91.39 42 23-Jul-21 76.92 84.81 97.03 94.50 97.12 43 30-Jul-21 82.09 69.20 86.80 95.28 94.84 44 6-Aug-21 95.84 88.74 100.71 97.25 96.58 45 13-Aug-21 99.87 92.23 99.71 97.12 93.26 46 20-Aug-21 92.69 73.13 78.47 97.17 97.13 47 27-Aug-21 96.77 74.69 92.22 87.16 97.12 48 3-Sep-21 96.94 87.24 87.82 89.91 97.25 49 10-Sep-21 79.89 87.46 99.70 94.06 77.98 50 17-Sep-21 96.44 82.70 99.45 97.25 89.64 51 24-Sep-21 88.12 77.88 89.27 97.25 87.36 52 1-Oct-21 94.89 90.69 99.01 97.12 83.79 53 8-Oct-21 73.39 94.49 99.95 97.25 91.67 54 15-Oct-21 98.26 81.60 99.60 97.25 94.52 55 22-Oct-21 99.94 86.21 96.52 97.25 97.12 56 29-Oct-21 92.35 86.24 78.87 97.17 94.50 57 5-Nov-21 99.23 74.71 78.40 94.50 98.94 58 12-Nov-21 79.53 89.41 83.45 82.57 97.25 59 19-Nov-21 81.26 86.90 92.90 94.23 103.76 60 26-Nov-21 99.86 76.76 99.80 94.34 109.81 61 3-Dec-21 94.48 76.99 83.95 86.79 97.12 US Banks Ready Accessibility: Good to go
