Solution
Rochak answered on
Mar 08 2023
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 Communication 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 -...