Collect data on Covid-19 cases, infection rate, death rate for United States of America from January 2020 to December 31, 2022.Collect data for S&P 500 index.Collect data for sectoral indices for...

1 answer below ยป
Collect data on Covid-19 cases, infection rate, death rate for United States of America from January 2020 to December 31, 2022.
Collect data for S&P 500 index.



Collect data for sectoral indices for United States.













All data to be collated in MS Excel.













Develop a multi factor model for the effect of Covid-19 pandemic on the US stock market (S&P 500).
Answered 9 days AfterMar 05, 2023

Answer To: Collect data on Covid-19 cases, infection rate, death rate for United States of America from January...

Rochak answered on Mar 08 2023
41 Votes
Data
    Date    Total Tests    Total Cases    Tests conducted each day    Infections each day    Death    Death each day    Death Rate    Infection rate    S&P 500    S&P 500 IT Services    S&P 500 Energy    S&P 500 Health Care (Sector)    S&P 500 Real Estate (Sector)    S&P 500 Financials (Sector)    S&P 500 Consumer Discretionary (Sector)    S&P 500 Materials (Sector)    S&P 500 Utilities (Sector)    S&P 500 Consumer Staples (Sector)    S&P 500 Industrials (Sector)    S&P 500 Communic
ation Services (Sector)
    21-Jan-20    10    1    10    1    - 0    - 0    0.0%    10.0%    3,320.79    552.91    440.32    242.62    158.92    215.84    250.26    156.80    180.93    167.73    198.67    124.80
    22-Jan-20    25    1    15    0    - 0    - 0    0.0%    0.0%    3,321.75    556.68    436.39    242.91    157.67    216.41    250.00    156.19    181.46    167.89    197.51    124.87
    23-Jan-20    34    1    9    0    - 0    - 0    0.0%    0.0%    3,325.54    557.24    434.81    241.70    159.19    215.91    250.30    155.98    183.13    167.45    199.74    124.44
    24-Jan-20    40    2    6    1    - 0    - 0    0.0%    16.7%    3,295.47    553.05    429.71    237.65    158.82    212.97    246.97    154.90    183.73    166.36    198.79    123.15
    27-Jan-20    65    5    25    3    - 0    - 0    0.0%    12.0%    3,243.63    544.44    417.87    235.85    158.16    209.69    243.20    151.65    183.18    165.83    195.08    121.06
    28-Jan-20    71    5    6    0    - 0    - 0    0.0%    0.0%    3,276.24    550.31    419.59    236.97    158.64    212.06    245.59    153.13    183.85    166.02    196.30    122.49
    29-Jan-20    77    5    6    0    - 0    - 0    0.0%    0.0%    3,273.40    549.42    415.12    236.31    157.65    211.73    245.45    153.69    184.41    165.16    197.39    121.96
    30-Jan-20    82    6    5    1    - 0    - 0    0.0%    20.0%    3,283.66    553.76    418.79    234.48    158.06    214.37    245.27    152.79    186.06    166.90    197.55    121.00
    31-Jan-20    87    7    5    1    - 0    - 0    0.0%    20.0%    3,225.52    541.17    405.45    229.82    155.91    210.04    247.28    149.42    185.23    165.04    193.03    119.46
    3-Feb-20    108    11    21    4    - 0    - 0    0.0%    19.0%    3,248.92    550.12    400.02    231.95    156.12    211.29    248.76    152.61    185.83    165.02    192.95    120.98
    4-Feb-20    113    11    5    0    - 0    - 0    0.0%    0.0%    3,297.59    559.21    400.81    235.89    157.97    213.48    253.15    155.27    183.92    165.93    196.50    121.82
    5-Feb-20    122    12    9    1    - 0    - 0    0.0%    11.1%    3,334.69    561.12    415.97    240.53    157.86    217.69    254.40    158.16    184.70    167.18    199.77    121.89
    6-Feb-20    131    12    9    0    - 0    - 0    0.0%    0.0%    3,345.78    564.58    411.64    240.80    158.49    217.32    254.00    158.03    184.65    167.74    200.38    123.28
    7-Feb-20    137    12    6    0    - 0    - 0    0.0%    0.0%    3,327.71    559.22    408.55    238.85    158.57    216.54    253.26    155.72    184.07    168.03    198.98    123.41
    10-Feb-20    158    13    21    1    - 0    - 0    0.0%    4.8%    3,352.09    565.05    405.24    240.07    160.52    216.99    256.44    155.75    184.69    168.66    200.10    124.44
    11-Feb-20    167    13    9    0    - 0    - 0    0.0%    0.0%    3,357.75    562.27    409.47    241.55    162.48    217.87    258.41    156.55    185.39    168.05    200.81    123.67
    12-Feb-20    172    14    5    1    - 0    - 0    0.0%    20.0%    3,379.45    565.15    415.03    241.88    163.57    218.03    260.95    157.37    185.43    167.99    202.65    124.81
    13-Feb-20    179    15    7    1    - 0    - 0    0.0%    14.3%    3,373.94    568.73    413.15    240.57    164.39    217.93    260.32    156.77    187.32    168.92    201.24    124.99
    14-Feb-20    185    15    6    0    - 0    - 0    0.0%    0.0%    3,380.16    573.57    409.82    240.89    166.21    218.10    259.88    156.86    188.54    169.39    201.12    125.12
    18-Feb-20    220    25    35    10    - 0    - 0    0.0%    28.6%    3,370.29    574.43    406.42    240.01    165.95    216.17    260.09    156.50    190.02    168.70    199.99    125.61
    19-Feb-20    229    25    9    0    - 0    - 0    0.0%    0.0%    3,386.15    578.98    411.79    241.10    163.70    217.76    261.31    156.81    187.94    168.56    199.88    126.08
    20-Feb-20    235    27    6    2    - 0    - 0    0.0%    33.3%    3,373.23    576.40    411.11    239.60    165.58    217.47    261.28    157.02    188.53    168.73    199.56    125.32
    21-Feb-20    241    30    6    3    - 0    - 0    0.0%    50.0%    3,337.75    568.50    405.93    239.67    166.21    215.36    257.01    156.40    188.19    169.20    198.67    123.57
    24-Feb-20    267    43    26    13    - 0    - 0    0.0%    50.0%    3,225.89    548.52    386.70    231.85    163.98    208.31    247.94    151.93    186.00    164.99    192.75    119.47
    25-Feb-20    273    45    6    2    - 0    - 0    0.0%    33.3%    3,128.21    522.02    369.92    225.01    159.76    201.22    241.48    145.40    181.98    162.11    184.99    116.59
    26-Feb-20    283    60    10    15    - 0    - 0    0.0%    150.0%    3,116.39    517.25    358.94    224.78    158.36    199.86    239.80    144.90    180.22    161.32    183.52    116.35
    27-Feb-20    289    60    6    0    - 0    - 0    0.0%    0.0%    2,978.76    497.37    339.30    217.29    149.51    191.12    230.05    138.15    171.76    154.76    176.57    111.64
    28-Feb-20    294    65    5    5    6    6    120.0%    100.0%    2,954.22    496.51    343.53    214.23    145.72    186.21    228.28    136.49    166.06    151.54    174.48    111.89
    2-Mar-20    863    104    569    39    10    4    10.3%    6.9%    3,090.23    521.31    353.68    224.57    153.09    195.28    236.26    142.15    175.79    159.84    179.28    115.90
    3-Mar-20    1480    125    617    21    12    2    9.5%    3.4%    3,003.37    501.72    342.64    218.85    152.93    187.99    230.77    141.07    173.75    157.75    174.93    112.04
    4-Mar-20    2369    161    889    36    12    -...
SOLUTION.PDF

Answer To This Question Is Available To Download

Related Questions & Answers

More Questions ยป

Submit New Assignment

Copy and Paste Your Assignment Here