Answered step by step
Verified Expert Solution
Link Copied!

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Basic College Mathematics (Subscription)

Authors: Elayn Martin Gay

6th Edition

0134844947, 9780134844947

More Books

Students also viewed these Mathematics questions