In Class Data Analysis

.xlsx
RMIT Classification: Trusted # Followings are imaginary data for analysis purposes. Month ABC Inc Price ($ASX All Ord Index 3-month Bank Bill Rate (%) return ANZ ASX return 12/29/2019 28.74 6167.3 1.77 1/31/2020 28.58 6146.5 1.79 -0.006 -0.003 2/28/2021 29.05 6117.3 1.77 0.016 -0.005 3/30/2020 26.86 5868.9 1.93 -0.075 -0.041 4/30/2020 26.84 6071.6 2.06 -0.001 0.035 5/31/2020 27.21 6123.5 1.96 0.014 0.009 6/29/2020 28.24 6289.7 2.07 0.038 0.027 7/31/2020 29.3 6366.2 2.02 0.038 0.012 8/31/2020 29.5 6427.8 1.96 0.007 0.010 9/28/2020 28.18 6325.5 1.93 -0.045 -0.016 10/31/2020 25.93 5913.3 1.93 -0.080 -0.065 11/30/2020 26.8 5749.3 1.94 0.034 -0.028 12/31/2020 24.46 5709.4 2.02 -0.087 -0.007 1/31/2021 25.03 5937.3 2.07 0.023 0.040 2/28/2021 28 6252.7 1.96 0.119 0.053 3/29/2021 26.03 6261.7 1.83 -0.070 0.001 4/30/2021 27.2 6418.4 1.68 0.045 0.025 5/31/2021 27.88 6491.8 1.54 0.025 0.011 6/28/2021 28.21 6699.2 1.29 0.012 0.032 7/31/2021 27.91 6896.7 1.11 -0.011 0.029 8/30/2021 26.74 6698.2 0.98 -0.042 -0.029 9/30/2021 28.52 6800.6 0.98 0.067 0.015 10/31/2021 26.74 6772.9 0.88 -0.062 -0.004 11/29/2021 24.84 6948 0.91 -0.071 0.026 12/31/2021 24.63 6802.4 0.90 -0.008 -0.021 1/31/2022 25.75 7121.2 0.89 0.045 0.047 2/28/2022 24.83 6511.5 0.89 -0.036 -0.086 3/31/2022 16.96 5110.6 0.53 -0.317 -0.215 4/30/2022 16.9 5597.7 0.17 -0.004 0.095 5/29/2022 17.89 5872.2 0.10 0.059 0.049 6/30/2022 18.64 6001.3 0.10 0.042 0.022 7/31/2022 17.96 6058.3 0.10 -0.036 0.009 8/31/2022 18.28 6245.9 0.10 0.018 0.031 9/30/2022 17.22 6009.3 0.09 -0.058 -0.038 10/30/2022 18.81 6133.2 0.07 0.092 0.021 11/30/2022 22.64 6742.1 0.02 0.204 0.099 12/31/2022 22.7 6850.6 0.02 0.003 0.016
RMIT Classification: Trusted # 1+R(ANZ) 0.994 Avg return -0.003 1.016 Geometric -0.00653204384641 0.925 -0.006532044 0.999 1.014 1.038 1.038 1.007 0.955 0.920 1.034 0.913 1.023 1.119 0.930 1.045 1.025 1.012 0.989 0.958 1.067 0.938 0.929 0.992 1.045 0.964 0.683 0.996 1.059 1.042 0.964 1.018 0.942 1.092 1.204 1.003
Followings are imaginary data for analysis purposes. Month ABC Inc Price ($ASX All Ord Index 3-month Bank Bill Rate (%) 12/29/2019 28.74 6167.3 1.77 1/31/2020 28.58 6146.5 1.79 2/28/2021 29.05 6117.3 1.77 3/30/2020 26.86 5868.9 1.93 4/30/2020 26.84 6071.6 2.06 5/31/2020 27.21 6123.5 1.96 6/29/2020 28.24 6289.7 2.07 7/31/2020 29.3 6366.2 2.02 8/31/2020 29.5 6427.8 1.96 9/28/2020 28.18 6325.5 1.93 10/31/2020 25.93 5913.3 1.93 11/30/2020 26.8 5749.3 1.94 12/31/2020 24.46 5709.4 2.02 1/31/2021 25.03 5937.3 2.07 2/28/2021 28 6252.7 1.96 3/29/2021 26.03 6261.7 1.83 4/30/2021 27.2 6418.4 1.68 5/31/2021 27.88 6491.8 1.54 6/28/2021 28.21 6699.2 1.29 7/31/2021 27.91 6896.7 1.11 8/30/2021 26.74 6698.2 0.98 9/30/2021 28.52 6800.6 0.98 10/31/2021 26.74 6772.9 0.88 11/29/2021 24.84 6948 0.91 12/31/2021 24.63 6802.4 0.90 1/31/2022 25.75 7121.2 0.89 2/28/2022 24.83 6511.5 0.89 3/31/2022 16.96 5110.6 0.53 4/30/2022 16.9 5597.7 0.17 5/29/2022 17.89 5872.2 0.10 6/30/2022 18.64 6001.3 0.10 7/31/2022 17.96 6058.3 0.10 8/31/2022 18.28 6245.9 0.10 9/30/2022 17.22 6009.3 0.09 10/30/2022 18.81 6133.2 0.07 11/30/2022 22.64 6742.1 0.02 12/31/2022 22.7 6850.6 0.02
Month ABC Inc Price ($)ASX All Ord Index 3-month Bank Bill Rate (%) 12/31/2020 22.7 6850.6 0.02 1/29/2021 23.71 6870.9 0.01 2/26/2021 26.17 6940.6 0.01
Uploaded by adhaaranth on coursehero.com