Compute the forecasts using linear regression using Excel's Regression Analysis or Excel's Slope() and Intercept() functions including the 28^th week. Forecast icu-patients (y) by using a variable (e.g. new cases, new tests etc) you choose (x) as the independent variable that you think will predict icu-patients best. What makes you think that it is a good predictor?

A B C D E F G H K Date Week icu_patients new_cases new_death hosp_patiweekly_h new_tests positive_tests_per new_vaccination 8/2/2021 1 15149 109391 500 59261 59756 1139550 0.10 9.7 693966 8/9/2021 2 19440 131282 665 76286 74997 1295447 0.10 9.6 730367 8/16/2021 22978 148057 1033 88855 83755 1398786 0.10 9.7 833771 8/23/2021 25216 156473 1306 95777 87120 1619550 0.10 10.0 874155 6 8/30/2021 25863 165583 1595 96865 86229 1661387 0.09 10.5 803896 9/6/2021 25743 145929 1686 94715 82585 1556687 0.09 11.0 677067 8 9/13/2021 24649 148042 2010 87895 76111 1675767 0.08 12.3 679745 9/20/2021 22628 121189 2082 78929 66453 1637914 0.07 14.1 676299 CO 10 9/27/2021 9 19904 107142 1958 68913 57180 1564291 0.06 15.5 955012 11 10/4/2021 10 17868 94800 1672 60912 50795 1529260 0.06 16.8 851021 ( 12 10/11/2021 11 17263 83516 1662 54536 46473 1446739 0.06 18.1 762744 13 10/18/2021 12 15630 71141 1679 48571 41573 1425668 0.05 19.8 849926 14 10/25/2021 13 13656 74214 1326 44313 37733 1358332 0.05 20.2 1319714 15 11/1/2021 14 11594 73880 1212 41406 35820 1405223 0.05 19.5 1359393 16 11/8/2021 15 11298 80137 1212 41640 37108 1417581 0.06 17.9 1436836 17 11/15/2021 16 11739 93679 1154 44587 40297 1486011 0.06 16.5 1509747 18 11/22/2021 17 12634 72683 820 48273 43679 1089244 0.07 14.5 1080138 19 11/29/2021 18 13764 122827 1731 53712 48308 1601745 0.08 13.3 1753177 20 12/6/2021 19 15039 118957 1309 60040 54608 1573226 0.07 13.9 1614909 21 12/13/2021 20 15935 135076 1320 62900 55928 1698100 0.08 12.4 1454319 22 12/20/2021 21 16283 205036 1463 65794 59872 1725584 0.13 7.7 1113995 23 12/27/2021 22 18170 416483 1364 88981 86247 1857659 0.24 4.3 1058258 24 1/3/2022 23 22123 723567 1697 124982 127901 2524999 0.29 3.4 1206226 25 1/10/2022 24 25409 802023 1935 148624 151094 2319779 0.28 3.6 1068361 26 1/17/2022 25 26060 707399 2101 150329 148658 2108362 0.26 3.8 775065 27 1/24/2022 26 24435 508841 2400 136173 133586 1514444 0.22 4.5 638648 1/31/2022 27 21182 292910 2463 111727 107868 1207701 0.18 5.5 440290 29 2/7/2022 28 16901 30 Li (Ctrl) - 31