Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

DATE USA_TotalCases Italy_TotalCases SPAIN_TotalCases 1/22/2020 1 1/23/2020 1 1/24/2020 2 1/25/2020 2 1/26/2020 5 1/27/2020 5 1/28/2020 5 1/29/2020 6 1/30/2020 6 1/31/2020 8 2

DATE USA_TotalCases Italy_TotalCases SPAIN_TotalCases
1/22/2020 1
1/23/2020 1
1/24/2020 2
1/25/2020 2
1/26/2020 5
1/27/2020 5
1/28/2020 5
1/29/2020 6
1/30/2020 6
1/31/2020 8 2
2/1/2020 8 2 1
2/2/2020 8 2 1
2/3/2020 11 2 1
2/4/2020 11 2 1
2/5/2020 11 2 1
2/6/2020 12 2 1
2/7/2020 12 3 1
2/8/2020 12 3 1
2/9/2020 12 3 2
2/10/2020 12 3 2
2/11/2020 13 3 2
2/12/2020 13 3 2
2/13/2020 14 3 2
2/14/2020 14 3 2
2/15/2020 14 3 2
2/16/2020 14 3 2
2/17/2020 14 3 2
2/18/2020 14 3 2
2/19/2020 14 3 2
2/20/2020 14 3 2
2/21/2020 16 20 2
2/22/2020 16 62 2
2/23/2020 16 155 2
2/24/2020 16 229 2
2/25/2020 16 322 6
2/26/2020 16 453 13
2/27/2020 17 655 15
2/28/2020 17 888 32
2/29/2020 25 1128 45
3/1/2020 32 1694 84
3/2/2020 55 2036 120
3/3/2020 74 2502 165
3/4/2020 107 3089 222
3/5/2020 184 3858 259
3/6/2020 237 4636 400
3/7/2020 403 5883 500
3/8/2020 519 7375 673
3/9/2020 594 9172 1073
3/10/2020 782 10149 1695
3/11/2020 1147 12462 2277
3/12/2020 1586 15113 2277
3/13/2020 2219 17660 5232
3/14/2020 2978 21157 6391
3/15/2020 3212 24747 7798
3/16/2020 4679 27980 9942
3/17/2020 6512 31506 11748
3/18/2020 9169 35713 13910
3/19/2020 13663 41035 17963
3/20/2020 20030 47021 20410
3/21/2020 26025 53578 25374
3/22/2020 34855 59138 28768
3/23/2020 46086 63927 35136
3/24/2020 56698 69176 39885
3/25/2020 68773 74386 49515
3/26/2020 86613 80589 57786
3/27/2020 105293 86498 65719
3/28/2020 124900 92472 73235
3/29/2020 143779 97689 80110
3/30/2020 165861 101739 87956
3/31/2020 192177 105792 95923
4/1/2020 224418 110574 104118
4/2/2020 256636 115242 112065
4/3/2020 288906 119827 119199
4/4/2020 321318 124632 126168
4/5/2020 351203 128948 131646
4/6/2020 382613 132547 136675
4/7/2020 413382 135586 141942
4/8/2020 444580 139422 148220
4/9/2020 480534 143626 153222
4/10/2020 514942 147577 158273
4/11/2020 544119 152271 163027
4/12/2020 571400 156363 166831
4/13/2020 598310 159516 170099
4/14/2020 627082 162488 172541
4/15/2020 652513 165155 177644
4/16/2020 682548 168941 184948
4/17/2020 715267 172434 190839
4/18/2020 743223 175925 191726
4/19/2020 769416 178972 198674
4/20/2020 799212 181228 200210
4/21/2020 825046 183957 204178
4/22/2020 853818 187327 208389
4/23/2020 887386 189973 213024
4/24/2020 919658 192994 202990
4/25/2020 950100 195351 205905
4/26/2020 976680 197675 207634
4/27/2020 1000298 199414 209465
4/28/2020 1024746 201505 210773
4/29/2020 1051136 203591 212917
4/30/2020 1080303 205463 213435
5/1/2020 1115206 207428 215216
5/2/2020 1142621 209328 216582
5/3/2020 1167076 210717 217466
5/4/2020 1191044 211938 218011
5/5/2020 1215508 213013 219329
5/6/2020 1240015 214457 220325
5/7/2020 1267372 215858 221447
5/8/2020 1294165 217185 222857
5/9/2020 1319347 218268 223578
5/10/2020 1338312 219070 224350
5/11/2020 1357483 219814 227436
5/12/2020 1380324 221216 228030
5/13/2020 1400699 222104 228691
5/14/2020 1427595 223096 229540
5/15/2020 1452285 223885 230183
5/16/2020 1476442 224760 230698
5/17/2020 1494919 225435 230698
5/18/2020 1517141 225886 231606
5/19/2020 1538064 226699 232037
5/20/2020 1560775 227364 232555
5/21/2020 1586446 228006 233037
5/22/2020 1610013 228658 234824
5/23/2020 1631253 229327 235290
5/24/2020 1651428 229858 235772
5/25/2020 1670191 230158 235400
5/26/2020 1689682 230555 236259
5/27/2020 1708061 231139 236259
5/28/2020 1730251 231732 237906
5/29/2020 1754702 232248 238564
5/30/2020 1778375 232664 239228
5/31/2020 1797448 232997 239479
6/1/2020 1814872 233197 239638
6/2/2020 1836215 233515 239932
6/3/2020 1855899 233836 240326
6/4/2020 1877430 234013 240660
6/5/2020 1902886 234531 240978
6/6/2020 1924150 234801 241310
6/7/2020 1942043 234998 241550
6/8/2020 1959544 235278 241717
6/9/2020 1977706 235561 241966
6/10/2020 1998701 235763 242280
6/11/2020 2021747 236142 242707
6/12/2020 2046466 236305 243209
6/13/2020 2071575 236651 243605
6/14/2020 2090661 236989 243928
6/15/2020 2110275 237290 244109
6/16/2020 2133602 237500 244328
6/17/2020 2160195 237828 244683
6/18/2020 2188105 238159 245268
6/19/2020 2219272 238011 245575
6/20/2020 2251437 238275 245938
6/21/2020 2276697 238499 246272
6/22/2020 2308053 238720 246504
6/23/2020 2344158 238833 246752
6/24/2020 2379008 239410 247086
6/25/2020 2418791 239706 247486
6/26/2020 2464270 239961 247905
6/27/2020 2505471 240136 248469
6/28/2020 2545898 240310 248770
6/29/2020 2586503 240436 248970
6/30/2020 2632500 240578 249271
7/1/2020 2683879 240760 249659
7/2/2020 2740125 240961 250103
7/3/2020 2791213 241184 250545
7/4/2020 2836986 241419 250545
7/5/2020 2887981 241611 250545
7/6/2020 2930846 241819 251789
7/7/2020 2991387 241956 252130
7/8/2020 3051649 242149 252513
7/9/2020 3114435 242363 253056
7/10/2020 3182298 242639 253908
7/11/2020 3243120 242827 253908
7/12/2020 3301813 243061 253908
7/13/2020 3360256 243230 255953
7/14/2020 3428374 243344 256619
7/15/2020 3496431 243506 257494
7/16/2020 3572195 243736 258855
7/17/2020 3643948 243967 260255
7/18/2020 3706602 244216 260255
7/19/2020 3767298 244434 260255
7/20/2020 3829250 244624 264836
7/21/2020 3894033 244752 266194
7/22/2020 3964756 245032 267551
7/23/2020 4033561 245338 270166
7/24/2020 4106978 245590 272421
7/25/2020 4171906 245864 272421
7/26/2020 4226986 246118 272421
7/27/2020 4283359 246286 278782
7/28/2020 4349605 246488 280610
7/29/2020 4421382 246776 282641
7/30/2020 4488919 247158 285430
7/31/2020 4557515 247537 288522
8/1/2020 4613844 247832 288522
8/2/2020 4659713 248070 288522
8/3/2020 4705268 248229 297054
8/4/2020 4763829 248419 302814
8/5/2020 4817895 248803 305767
8/6/2020 4877531 249204 309855
8/7/2020 4936300 249756 314362
8/8/2020 4990633 250103 314362
8/9/2020 5036632 250566 314362
8/10/2020 5085040 250825 322980
8/11/2020 5132014 251237 326612
8/12/2020 5188835 251713 329784
8/13/2020 5240756 252235 337334
8/14/2020 5306488 252809 342813
8/15/2020 5353299 253438 342813
8/16/2020 5393000 253915 342813
8/17/2020 5429594 254235 359082
8/18/2020 5474609 254636 364196
8/19/2020 5521982 255278 370867
8/20/2020 5565914 256118 377906
8/21/2020 5614670 257065 386054
8/22/2020 5658059 258136 386054
8/23/2020 5692359 259345 386054
8/24/2020 5729043 260298 405436
8/25/2020 5769196 261174 412553
8/26/2020 5814647 262540 419849
8/27/2020 5859906 263949 429507
8/28/2020 5906933 265409 439286
8/29/2020 5949879 266853 439286
8/30/2020 5984467 268218 439286
8/31/2020 6019738 269214 462858
9/1/2020 6061402 270189 470973
9/2/2020 6102432 271515 479554
9/3/2020 6146246 272912 488513
9/4/2020 6196500 274644 498989
9/5/2020 6239600 276338 498989
9/6/2020 6271035 277634 498989
9/7/2020 6294514 278784 525549
9/8/2020 6321796 280153 534513
9/9/2020 6355493 281583 543379
9/10/2020 6391606 283180 554143
9/11/2020 6439138 284796 566326
9/12/2020 6480228 286297 566326
9/13/2020 6514569 287753 566326
9/14/2020 6548677 288761 593730
9/15/2020 6588026 289990 603167
9/16/2020 6626453 291442 614360
9/17/2020 6671532 293025 625651
9/18/2020 6720653 294932 640040
9/19/2020 6762841 296569 640040
9/20/2020 6801201 298156 640040
9/21/2020 6852890 299506 671468
9/22/2020 6892369 300897 682267
9/23/2020 6931131 302537 693556
9/24/2020 6977869 304323 704209
9/25/2020 7025929 306235 716481
9/26/2020 7070514 308104 716481
9/27/2020 7108139 309870 716481
9/28/2020 7141071 311364 748266
9/29/2020 7184041 313011 748266
9/30/2020 7223193 314861 769188
10/1/2020 7268654 317409 778607
10/2/2020 7323298 319908 789932
10/3/2020 7371924 322751 789932
10/4/2020 7407809 325329 789932
10/5/2020 7446971 327586 813412
10/6/2020 7491795 330263 825410
10/7/2020 7542482 333940 835901
10/8/2020 7600805 338398 848324
10/9/2020 7656826 343770 861112
10/10/2020 7711705 349494 861112
10/11/2020 7757683 354950 861112
10/12/2020 7799197 359569 888968
10/13/2020 7851013 365467 896086
10/14/2020 7910361 372799 908056
10/15/2020 7974857 381602 921374
10/16/2020 8043568 391611 936560
10/17/2020 8100011 402536 936560
10/18/2020 8149311 414241 936560
10/19/2020 8216529 423578 974449
10/20/2020 8278111 434449 988322
10/21/2020 8340907 449648 1005295
10/22/2020 8416786 465726 1026281
10/23/2020 8498026 484869 1046132
10/24/2020 8580599 504509 1046132
10/25/2020 8642492 525782 1046132
10/26/2020 8709253 542789 1098320
10/27/2020 8785485 564778 1116738
10/28/2020 8864064 589766 1136503
10/29/2020 8954346 616595 1160083
10/30/2020 9052874 647674 1185678
10/31/2020 9142161 679430 1185678
11/1/2020 9246239 709335 1185678
11/2/2020 9329717 731588 1240697
11/3/2020 9455830 759829 1259366
11/4/2020 9559531 790377 1284408
11/5/2020 9687443 824879 1306316
11/6/2020 9814397 862681 1328832
11/7/2020 9942364 902490 1328832
11/8/2020 10054010 935104 1328832
11/9/2020 10175064 960373 1381218
11/10/2020 10314192 995463 1381218
11/11/2020 10460298 1028424 1417709
11/12/2020 10622569 1066401 1437220
11/13/2020 10801512 1107303 1458591
11/14/2020 10970188 1144552 1458591
11/15/2020 11106131 1178529 1458591
11/16/2020 11265499 1205881 1496864
11/17/2020 11427408 1238072 1510023
11/18/2020 11599210 1272352 1525341
11/19/2020 11788655 1308528 1541574
11/20/2020 11985326 1345767 1556730
11/21/2020 12166131 1380531 1556730
11/22/2020 12312638 1408868 1556730
11/23/2020 12481695 1431795 1582616
11/24/2020 12655601 1455022 1594844
11/25/2020 12838845 1480874 1605066
11/26/2020 12953279 1509875 1617355
11/27/2020 13157462 1538217 1628208
11/28/2020 13313462 1564532 1628208
11/29/2020 13453833 1585178 1628208
11/30/2020 13609267 1601554 1648187
12/1/2020 13793675 1620901 1656444
12/2/2020 13994659 1641610 1665775
12/3/2020 14214152 1664829 1675902
12/4/2020 14444090 1688939 1684647
12/5/2020 14660410 1709991 1684647
12/6/2020 14842119 1728878 1684647
12/7/2020 15031055 1742557 1702328
12/8/2020 15250740 1757394 1702328
12/9/2020 15472348 1770149 1712101
12/10/2020 15700192 1787147 1720056
12/11/2020 15934696 1805873 1730575
12/12/2020 16154091 1825775 1730575
12/13/2020 16345678 1843712 1730575
12/14/2020 16539567 1855737 1751884
12/15/2020 16737310 1870576 1762212
12/16/2020 16983982 1888144 1773290
12/17/2020 17221193 1906377 1785421
12/18/2020 17470717 1921778 1797236
12/19/2020 17666244 1938083 1797236
12/20/2020 17855225 1953185 1797236
12/21/2020 18048042 1964054 1819249
12/22/2020 18242960 1977370 1829903
12/23/2020 18470403 1991278 1842289
12/24/2020 18667560 2009317 1854951
12/25/2020 18767746 2028354 1854951
12/26/2020 18994343 2038759 1854951
12/27/2020 19150811 2047696 1854951
12/28/2020 19316550 2056277 1879413
12/29/2020 19514313 2067487 1893502
12/30/2020 19745497 2083689 1910218
12/31/2020 19974564 2107166 1928265
1/1/2021 20132054 2129376 1928265
1/2/2021 20433912 2141201 1928265
1/3/2021 20643229 2155446 1928265
1/4/2021 20819087 2166244 1958844
1/5/2021 21049605 2181619 1982544
1/6/2021 21299340 2201945 1982544
1/7/2021 21574043 2220361 2024904

1. Use the Data of Italy and calculate the average growth rate of the number of cases (starting from the date in which Italy had more than 100 cases). USE EXCEL 2. Use the Data of Spain and calculate the average growth rate of the number of cases. (starting from the date in which Spain had more than 100 cases). USE EXCEL 3. Use the Data of the US and calculate the average growth rate of the number of cases. (starting from the date in which US had more than 100 cases). USE EXCEL 4. Plot the data for the three countries (in levels). In the same plot, all countries should start at from the date when they had more than 100 cases: Meaning the X-axis should represent "number of days after the date of the 100th case"). 5. Plot the data for the three countries in the ratio-scale (log-scale). In the same plot, all countries should start at from the date when they had more than 100 cases: Meaning the X-axis should represent "number of days after the date of the 100th case").

Use the Data of the US and calculate the average growth rate of the number of cases. (starting from the date in which US had more than 100 cases). use EXCEL

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_2

Step: 3

blur-text-image_3

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

Price Theory and Applications

Authors: Steven Landsburg

9th edition

1285423526, 978-1285947877, 1285947878, 978-1285423524

More Books

Students also viewed these Economics questions

Question

Is there administrative support?

Answered: 1 week ago