Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Collect the market price index (All Ordinaries), Share price for a selected company (as per instructions given in page 2) and display the data for
Collect the market price index (All Ordinaries), Share price for a selected company (as per instructions given in page 2) and display the data for two sub-periods (Period 1: November 2018 to February 2020; Period 2: April 2020 to July 2021) separately in two separate tables.
Period 1: _______________________
Date | AORD | Name of your company | |||||
Oct-18 | |||||||
Nov-18 | |||||||
--- | |||||||
Feb-20 | |||||||
Average | |||||||
Standard deviation | |||||||
Variance | |||||||
Correlation coefficient | |||||||
Beta |
Period 2: _______________________
Date | AORD | Name of your company | |||||
Mar-20 | |||||||
Apr-20 | |||||||
--- | |||||||
July-21 | |||||||
Average | |||||||
Standard deviation | |||||||
Variance | |||||||
Correlation coefficient | |||||||
Beta |
I have pasted the table so you can just copy it out to fill out
The required date will be pasted below: Stealth global Holdings limited
31-Oct-18 | 0.16 | 0.175 | 0.15 | 0.155 | 0.155 | 1825366 |
30-Nov-18 | 0.15 | 0.165 | 0.14 | 0.165 | 0.165 | 1530796 |
31-Dec-18 | 0.165 | 0.17 | 0.14 | 0.15 | 0.15 | 597714 |
31-Jan-19 | 0.145 | 0.155 | 0.145 | 0.155 | 0.155 | 1016217 |
28-Feb-19 | 0.155 | 0.155 | 0.11 | 0.11 | 0.11 | 2855821 |
31-Mar-19 | 0.12 | 0.125 | 0.095 | 0.095 | 0.095 | 2050174 |
1-May-19 | 0.099 | 0.1 | 0.078 | 0.09 | 0.09 | 713937 |
1-Jun-19 | 0.09 | 0.105 | 0.089 | 0.09 | 0.09 | 2296091 |
1-Jul-19 | 0.091 | 0.105 | 0.09 | 0.09 | 0.09 | 640594 |
1-Aug-19 | 0.09 | 0.095 | 0.086 | 0.089 | 0.089 | 295553 |
1-Sep-19 | 0.09 | 0.099 | 0.08 | 0.09 | 0.09 | 1493432 |
1-Oct-19 | 0.09 | 0.095 | 0.075 | 0.088 | 0.088 | 2032905 |
31-Oct-19 | 0.082 | 0.12 | 0.08 | 0.092 | 0.092 | 2220496 |
30-Nov-19 | 0.09 | 0.1 | 0.09 | 0.096 | 0.096 | 710017 |
31-Dec-19 | 0.096 | 0.1 | 0.088 | 0.092 | 0.092 | 949399 |
31-Jan-20 | 0.092 | 0.1 | 0.085 | 0.085 | 0.085 | 1634713 |
29-Feb-20 | 0.085 | 0.085 | 0.049 | 0.052 | 0.052 | 1040135 |
31-Mar-20 | 0.052 | 0.08 | 0.051 | 0.07 | 0.07 | 676472 |
1-May-20 | 0.07 | 0.076 | 0.06 | 0.064 | 0.064 | 195158 |
1-Jun-20 | 0.065 | 0.073 | 0.064 | 0.069 | 0.069 | 837268 |
1-Jul-20 | 0.069 | 0.07 | 0.065 | 0.068 | 0.068 | 285337 |
1-Aug-20 | 0.068 | 0.073 | 0.064 | 0.065 | 0.065 | 254418 |
1-Sep-20 | 0.067 | 0.11 | 0.064 | 0.09 | 0.09 | 3190184 |
1-Oct-20 | 0.09 | 0.09 | 0.07 | 0.09 | 0.09 | 7072436 |
31-Oct-20 | 0.092 | 0.18 | 0.077 | 0.094 | 0.094 | 4390144 |
30-Nov-20 | 0.099 | 0.115 | 0.096 | 0.1 | 0.1 | 3225120 |
31-Dec-20 | 0.1 | 0.1075 | 0.087 | 0.09 | 0.09 | 1137205 |
31-Jan-21 | 0.09 | 0.13 | 0.081 | 0.105 | 0.105 | 4050132 |
28-Feb-21 | 0.105 | 0.105 | 0.092 | 0.1 | 0.1 | 1026774 |
31-Mar-21 | 0.1 | 0.1 | 0.093 | 0.095 | 0.095 | 551466 |
1-May-21 | 0.095 | 0.095 | 0.081 | 0.086 | 0.086 | 778605 |
1-Jun-21 | 0.086 | 0.13 | 0.086 | 0.105 | 0.105 | 8667276 |
1-Jul-21 | 0.11 | 0.115 | 0.1 | 0.115 | 0.115 | 2041354 |
All ordinaries (^AORD)
31-Oct-18 | 5913.3 | 6027.2 | 5675.9 | 5749.3 | 5749.3 | 18360242900 |
30-Nov-18 | 5749.3 | 5856.3 | 5478.4 | 5709.4 | 5709.4 | 15542943100 |
31-Dec-18 | 5709.4 | 5979.9 | 5620.3 | 5937.3 | 5937.3 | 13683629100 |
31-Jan-19 | 5937.3 | 6267.7 | 5924.5 | 6252.7 | 6252.7 | 17196470900 |
28-Feb-19 | 6252.7 | 6350.8 | 6181.1 | 6261.7 | 6261.7 | 19045805500 |
31-Mar-19 | 6261.7 | 6477.9 | 6258.8 | 6418.4 | 6418.4 | 13912409100 |
1-May-19 | 6418.4 | 6598.3 | 6289.6 | 6491.8 | 6491.8 | 19128361600 |
1-Jun-19 | 6491.8 | 6773.4 | 6401 | 6699.2 | 6699.2 | 18705183500 |
1-Jul-19 | 6699.2 | 6958.7 | 6699.2 | 6896.7 | 6896.7 | 18272688400 |
1-Aug-19 | 6896.7 | 6896.7 | 6476.7 | 6698.2 | 6698.2 | 21419352000 |
1-Sep-19 | 6698.2 | 6883.1 | 6605.4 | 6800.6 | 6800.6 | 21290345800 |
1-Oct-19 | 6800.6 | 6867.5 | 6594.6 | 6772.9 | 6772.9 | 18478531600 |
31-Oct-19 | 6772.9 | 6996 | 6743.8 | 6948 | 6948 | 18108700500 |
30-Nov-19 | 6948 | 6990.4 | 6700.2 | 6802.4 | 6802.4 | 14726648500 |
31-Dec-19 | 6802.4 | 7260 | 6789.4 | 7121.2 | 7121.2 | 13482036800 |
31-Jan-20 | 7121.2 | 7289.7 | 6498.8 | 6511.5 | 6511.5 | 19383472200 |
29-Feb-20 | 6501.3 | 6598.8 | 4564.1 | 5110.6 | 5110.6 | 41755181900 |
31-Mar-20 | 5110.6 | 5623 | 5063.5 | 5597.7 | 5597.7 | 27360895000 |
1-May-20 | 5597.7 | 6029.9 | 5246.4 | 5872.2 | 5872.2 | 27232943400 |
1-Jun-20 | 5872.2 | 6314.6 | 5823.5 | 6001.3 | 6001.3 | 33258396900 |
1-Jul-20 | 6001.3 | 6272.3 | 6000.4 | 6058.3 | 6058.3 | 23016694200 |
1-Aug-20 | 6058.3 | 6369.9 | 5992.4 | 6245.9 | 6245.9 | 24319379800 |
1-Sep-20 | 6245.9 | 6316.2 | 5951.3 | 6009.3 | 6009.3 | 25441524400 |
1-Oct-20 | 6009.3 | 6455.6 | 5970.3 | 6133.2 | 6133.2 | 20624673100 |
31-Oct-20 | 6133.2 | 6923.1 | 6105.4 | 6742.1 | 6742.1 | 22020169400 |
30-Nov-20 | 6742.1 | 7009.7 | 6732.6 | 6850.6 | 6850.6 | 19431896800 |
31-Dec-20 | 6850.6 | 7118.6 | 6849.5 | 6870.9 | 6870.9 | 16266687600 |
31-Jan-21 | 6870.9 | 7207.7 | 6770.8 | 6940.6 | 6940.6 | 19244405400 |
28-Feb-21 | 6940.6 | 7119.2 | 6885.1 | 7017 | 7017 | 22933667200 |
31-Mar-21 | 7017 | 7358.8 | 7015.2 | 7290.7 | 7290.7 | 18207374600 |
1-May-21 | 7290.7 | 7448.3 | 7154 | 7406.7 | 7406.7 | 19212253400 |
1-Jun-21 | 7406.7 | 7655.9 | 7366.8 | 7585 | 7585 | 21281495200 |
1-Jul-21 | 7585 | 7722 | 7478 | 7664.2 | 7664.2 | 19714764400 |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started