Please do Regression Statistics, ANOVA for the following countries with the data below as shown in the example above:

Please make one separated for each country.

Thank you.

A G 1 date location total_cases Search: Cor: 3-day Lagged Search 2 2/26/20 Algeria 1 35 8 3 2/27/20 Algeria 1 24 14 4 2/28/20 Algeria 1 16 47 5 2/29/20 Algeria 1 13 57 6 3/1/20 Algeria 1 11 41 7 3/2/20 Algeria 1 27 27 8 3/3/20 Algeria 5 27 21 9 3/4/20 Algeria 5 29 16 10 3/5/20 Algeria 12 25 44 11 3/6/20 Algeria 12 24 44 12 3/7/20 Algeria 17 18 43 13 3/8/20 Algeria 17 19 43 14 3/9/20 Algeria 20 25 38 15 3/10/20 Algeria 20 23 29 16 3/11/20 Algeria 20 26 31 17 3/12/20 Algeria 25 50 37 18 3/13/20 Algeria 25 56 39 19 3/14/20 Algeria 26 63 40 20 3/15/20 Algeria 37 99 91 21 3/16/20 Algeria 49 100 95 22 3/17/20 Algeria 60 89 100 23 24 SUMMARY OUTPUT 25 26 Regression Statistics 27 Multiple R 0.8541796 28 R Square 0.7296228 29 Adjusted R Square 0.7153924 30 Standard Error 8.7522257 31 Observations 21 32 33 ANOVA 34 df SS MS F ignificance F 35 Regression 1 3927.5248 3927.5248 51.272196 8.349E-07 36 Residual 19 1455.4276 76.601454 37 Total 20 5382.9524 38 39 Coefficients tandard Erre t Stat P-value Lower 95% Upper 95% ower 95.0% Jpper 95.0% 40 Intercept -2.331662 3.3016104 -0.70622 0.4886219 -9.242012 4.5786881 -9.242012 4.5786881 41 Search: Coronavirus 0.5068397 0.0707831 7.1604606 8.349E-07 0.3586889 0.6549904 0.3586889 0.6549904 42 43 44 SUMMARY OUTPUT 45 46 Regression Statistics 47 Multiple R 0.8896847 48 R Square 0.7915388 49 Adjusted R Square 0.7683765 50 Standard Error 7.8956268 51 Observations 21 52 53 ANOVA 54 df SS MS F ignificance F 1 55 Regression 2 4260.8158 2130.4079 34.173505 7.434E-07 56 Residual 18 1122.1366 62.340923 1 57 Total 20 5382.9524 58 59 Coefficients tandard Erre t Stat P-value Lower 95% Upper 95% .ower 95.0% Jpper 95.0% 50 lintercept -6.659221 3.517709 -1.893056 0.0745424 -14.04965 0.7312111 -14.04965 0.73121111 61 Search: Coronavirus 0.3506642 0.0929501 3.7726062 0.0013939 0.1553832 0.5459452 0.1553832 0.5459452 62 3-day Lagged Search 0.2383016 0.1030628 2.3121989 0.0328073 0.0217748 0.4548284 0.0217748 0.4548284 63 64 new_cases total_deaths new_deaths total_cases 2 N date location 3/13/20 Jersey 3/14/20 Jersey 3/15/20 Jersey 3/16/20 Jersey 3/17/20 Jersey N 0 0 0 0 2 2 A B E F new_cases total_deaths new_deaths total_cases 1 1 1 0 0 0 0 0 0 0 date location 2/28/20 Lithuania 2/29/20 Lithuania 3/1/20 Lithuania 3/2/20 Lithuania 3/3/20 Lithuania 3/4/20 Lithuania 3/5/20 Lithuania 3/6/20 Lithuania 3/7/20 Lithuania 3/8/20 Lithuania 3/9/20 Lithuania 3/10/20 Lithuania 3/11/20 Lithuania 3/12/20 Lithuan 3/13/20 Lithuania 3/14/20 Lithuania 3/15/20 Lithuania 3/16/20 Lithuania 3/17/20 Lithuania 1 1 1 1 1 1 1 1 0 0 0 0 1 1 0 2 0 mm mm 0 m 3 6 9 14 17 new_cases total_deaths date location 3/17/20 Liberia new_deaths total_cases 1 A G 1 date location total_cases Search: Cor: 3-day Lagged Search 2 2/26/20 Algeria 1 35 8 3 2/27/20 Algeria 1 24 14 4 2/28/20 Algeria 1 16 47 5 2/29/20 Algeria 1 13 57 6 3/1/20 Algeria 1 11 41 7 3/2/20 Algeria 1 27 27 8 3/3/20 Algeria 5 27 21 9 3/4/20 Algeria 5 29 16 10 3/5/20 Algeria 12 25 44 11 3/6/20 Algeria 12 24 44 12 3/7/20 Algeria 17 18 43 13 3/8/20 Algeria 17 19 43 14 3/9/20 Algeria 20 25 38 15 3/10/20 Algeria 20 23 29 16 3/11/20 Algeria 20 26 31 17 3/12/20 Algeria 25 50 37 18 3/13/20 Algeria 25 56 39 19 3/14/20 Algeria 26 63 40 20 3/15/20 Algeria 37 99 91 21 3/16/20 Algeria 49 100 95 22 3/17/20 Algeria 60 89 100 23 24 SUMMARY OUTPUT 25 26 Regression Statistics 27 Multiple R 0.8541796 28 R Square 0.7296228 29 Adjusted R Square 0.7153924 30 Standard Error 8.7522257 31 Observations 21 32 33 ANOVA 34 df SS MS F ignificance F 35 Regression 1 3927.5248 3927.5248 51.272196 8.349E-07 36 Residual 19 1455.4276 76.601454 37 Total 20 5382.9524 38 39 Coefficients tandard Erre t Stat P-value Lower 95% Upper 95% ower 95.0% Jpper 95.0% 40 Intercept -2.331662 3.3016104 -0.70622 0.4886219 -9.242012 4.5786881 -9.242012 4.5786881 41 Search: Coronavirus 0.5068397 0.0707831 7.1604606 8.349E-07 0.3586889 0.6549904 0.3586889 0.6549904 42 43 44 SUMMARY OUTPUT 45 46 Regression Statistics 47 Multiple R 0.8896847 48 R Square 0.7915388 49 Adjusted R Square 0.7683765 50 Standard Error 7.8956268 51 Observations 21 52 53 ANOVA 54 df SS MS F ignificance F 1 55 Regression 2 4260.8158 2130.4079 34.173505 7.434E-07 56 Residual 18 1122.1366 62.340923 1 57 Total 20 5382.9524 58 59 Coefficients tandard Erre t Stat P-value Lower 95% Upper 95% .ower 95.0% Jpper 95.0% 50 lintercept -6.659221 3.517709 -1.893056 0.0745424 -14.04965 0.7312111 -14.04965 0.73121111 61 Search: Coronavirus 0.3506642 0.0929501 3.7726062 0.0013939 0.1553832 0.5459452 0.1553832 0.5459452 62 3-day Lagged Search 0.2383016 0.1030628 2.3121989 0.0328073 0.0217748 0.4548284 0.0217748 0.4548284 63 64 new_cases total_deaths new_deaths total_cases 2 N date location 3/13/20 Jersey 3/14/20 Jersey 3/15/20 Jersey 3/16/20 Jersey 3/17/20 Jersey N 0 0 0 0 2 2 A B E F new_cases total_deaths new_deaths total_cases 1 1 1 0 0 0 0 0 0 0 date location 2/28/20 Lithuania 2/29/20 Lithuania 3/1/20 Lithuania 3/2/20 Lithuania 3/3/20 Lithuania 3/4/20 Lithuania 3/5/20 Lithuania 3/6/20 Lithuania 3/7/20 Lithuania 3/8/20 Lithuania 3/9/20 Lithuania 3/10/20 Lithuania 3/11/20 Lithuania 3/12/20 Lithuan 3/13/20 Lithuania 3/14/20 Lithuania 3/15/20 Lithuania 3/16/20 Lithuania 3/17/20 Lithuania 1 1 1 1 1 1 1 1 0 0 0 0 1 1 0 2 0 mm mm 0 m 3 6 9 14 17 new_cases total_deaths date location 3/17/20 Liberia new_deaths total_cases 1