Need help in 1 hour please. The last three pictures are the table.
The attached table (download it as excel sheet) lists the cumulative cases IV and daily increases ANV of COVID19 infections in Quebec (during the first wave) until end of May 2020. Use least square regression to adjust the model AN = a, N + a, N2. Use at least 12 significant figures in your calculations and report the results for the coefficients a, and a, with at least 5 significant figures Coefficient do Answer: Coefficient @1 Answer: Compute the root mean square error (RMSE) of the adjusted model Use at least 12 signification figures in your calculations and report the result with at least 3 significant figures RMSE Answer: According this model, how many total cases (i.e. daily increase drops to zero) did happen in Quebec during the first wave ? Give your answer with 5 significant figures (you can round the result to the nearest integer) Answer:B C F M A H J L D E G K 41 15-Apr 15857 997 42 16-Apr 16798 941 43 17-Apr 17521 723 44 18-Apr 18357 836 45 19-Ap 19319 962 46 20-Apr 20126 807 47 21-Apr 20965 839 48 22-Apr 21838 873 49 23-Apr 22616 778 50 24-Apr 23267 651 51 25-Apr 24107 840 52 26-Apr 24982 875 53 27-Apr 25757 775 54 28-Apr 26594 837 55 29-Apr 27538 944 56 30-Apr 28648 1110 57 1-May 29656 1008 58 2-May 31865 2209 59 3-May 32623 758 60 4-May 33417 794 61 5-May 34327 910 62 6-May 35238 911 63 7-May 36150 912 64 8-May 36986 836 65 9-May 37721 735 66 10-May 38469 748 67 11-May 39225 756 68 12-May 39931 706 69 13-May 40724 793 70 14-May 41420 696 71 15-May 42183 763 72 16-May 42920 737 73 17-May 43627 707 74 18-May 44197 570 75 19-May 44775 578 76 20-May 45495 720 77 21-May 46141 646 78 22-May 46838 697 79 23-May 47411 573 80 24-May 47984 573 81 25-May 48598 614 - .. K Sheet1 +A G K M B C D E F H Cumulative Daily 1 Date cases inccrease 28-Feb 1 5-Mar 9-Mar 3 1 10-Mar 7 4 11-Mar 9 12-Mar 17 8 13-Mar 17 0 14-Mar 24 7 10 15-Mar 39 15 11 16-Mar 50 11 12 17-Mar 63 13 13 18-Mar 94 31 14 19-Mar 121 27 15 20-Mar 139 18 16 21-Mar 181 42 17 22-Mar 219 38 18 23-Mar 628 409 19 24-Mar 1013 385 20 25-Mar 1339 326 21 26-Mar 1629 290 22 27-Mar 2021 392 23 28-Mar 2498 477 24 29-Mar 3430 932 25 30-Mar 4162 732 26 31-Mar 4611 449 27 1-Apr 5518 907 28 2-Apr 6101 583 29 3-Apr 6997 896 30 4-Apr 7944 947 31 5-Apr 8580 636 32 6-Apr 9340 760 33 7-Apr 10031 691 34 8-Apr 10912 881 35 9-Apr 11677 765 36 10-Apr 12292 615 37 11-Apr 12846 554 38 12-Apr 13557 711 39 13-Apr 14248 691 40 14-Apr 14860 612 K >1 Sheet1 +