Analyze data for beer imports to the U.S. The data is from the U.S. Department of Commerce sourced by The Beer Institute at "beerinstitute.org". Use regression analysis to construct models for the imports of draft, cans, bottles, and total. For each, construct both annual models and monthly models. Also, please include a forecast for imports of each type in all of 2023 and a separate forecast for imports of each type in only July 2023. This is a TWO PAGE MEMORANDUM. Example videos used a previous set of data which has been augmented with more recent data.

Annual Data Year Bottles Cans Draft Total Barrels 1980 na na na 4,566,646 1981 na na na 5,220,069 1982 na na na 5,753,512 1983 na na na 6,312,579 1984 na na na 7,202,117 1985 na na na 7,914,985 1986 na na na 8,836,577 1987 8,098,146 638,071 606,192 9,342,409 1988 8,089,396 688,079 620,860 9,398,335 1989 7,342,995 680,325 636,441 8,659,761 1990 7,341,909 761,744 679,259 8,782,912 1991 6,373,004 819,724 733,338 7,926,066 1992 6,683,920 833,265 805,707 8,322,892 1993 7,405,295 985,068 852,318 9,242,681 1994 8,406,017 1,103,235 980,397 10,489,649 1995 8,969,541 1,250,052 1,041,827 11,261,420 1996 9,903,692 1,381,593 1,138,952 12,424,237 1997 11,346,246 1,538,139 1,353,957 14,238,342 1998 15,210,380 601,075 504,842 16,316,297 1999 14,109,752 2,107,691 1,573,377 17,790,820 2000 15,607,806 2,592,594 1,787,023 19,987,423 2001 17,189,024 2,836,662 1,728,991 21,754,677 2002 18,155,641 3,168,431 1,746,225 23,070,297 2003 18,467,326 3,148,387 1,902,941 23,518,654 2004 18,796,766 3,254,283 1,798,777 23,849,826 2005 19,875,537 3,589,300 2,100,872 25,565,709 2006 23,129,697 3,970,699 2,193,984 29,294,380 2007 22,912,934 4,332,164 2,449,616 29,694,714 2008 21,668,165 4,454,151 2,577,408 28,699,724 2009 19,028,750 4,746,433 2,106,301 25,881,484 2010 19,884,929 5,046,791 2,210,674 27,142,394 2011 19,651,572 5,280,083 2,406,585 27,338,239 2013 19,455,186 5,669,825 2,414,347 27,539,358 2014 20,242,048 6,722,406 2,465,731 29,430,185 2015 20,808,247 7,829,645 2,607,232 31,245,124 2016 21,999,370 8,797,165 2,569,816 33,366,351 2017 22,813,811 9,035,065 2,579,614 34,428,490 2018 22,995,525 9,992,786 2,672,277 35,660,588 2019 22,808,545 10,750,570 2,704,471 36,263,586 2020 23,772,225 11,242,061 1,363,888 36,378,174 2021 24,167,426 13,241,887 2,072,049 39,481,363 2022 24,762,212 13,795,182 2,070,120 40,627,514

BOTTLES CANS DRAFT TOTAL 1/1/1999 826057 104134 88434 1018625 2/1/1999 1087714 124258 163445 1375417 3/1/1999 1324485 163630 133922 1622037 4/1/1999 1247057 191144 127816 1566017 5/1/1999 1462492 212968 135105 1810565 6/1/1999 1490523 249086 161555 1901164 7/1/1999 1549932 222549 125281 1897762 8/1/1999 1239079 219684 128975 1587738 9/1/1999 1061438 183182 129088 1373708 10/1/1999 1165509 145402 132110 1443021 11/1/1999 1091678 151699 118822 1362199 12/1/1999 985718 155869 133447 1275034 1/1/2000 951989 127989 131990 1211968 2/1/2000 1192032 172215 137832 1502079 3/1/2000 1406502 175953 169232 1751687 4/1/2000 1321528 202021 139926 1663475 5/1/2000 1550291 240349 173269 1963909 6/1/2000 1575828 303070 147785 2026683 7/1/2000 1606877 284767 149403 2041047 8/1/2000 1685228 290997 173853 2150078 9/1/2000 1231474 240107 132269 1603850 10/1/2000 1292423 217154 156914 1666491 11/1/2000 1153162 159147 133894 1446203 12/1/2000 1072434 194518 146522 1413474 1/1/2001 1264836 156071 146835 1567742 2/1/2001 1182559 155715 151871 1490144 3/1/2001 1592608 203455 162454 1958517 4/1/2001 1540415 226042 127817 1894274 5/1/2001 1764079 309855 120950 2194884 6/1/2001 1665360 318692 170655 2154707 7/1/2001 1574716 325323 149368 2049407 8/1/2001 1524278 297647 138557 1960481 9/1/2001 1248786 206340 144248 1599373 10/1/2001 1406427 233752 140174 1780353 11/1/2001 1185280 162579 130623 1478482 12/1/2001 1300820 243017 145784 1689621 1/1/2002 1232833 173903 118866 1525602 2/1/2002 1352604 191575 154846 1699025 3/1/2002 1678888 213469 143118 2035475 4/1/2002 1733675 294571 164771 2193017 5/1/2002 1743540 325531 174992 2244063 6/1/2002 1630512 310823 134875 2076209 7/1/2002 1740909 356212 165632 2262753 8/1/2002 1537726 339868 128751 2006345 9/1/2002 1365795 278853 128693 1773341 10/1/2002 1514058 237283 125546 1876887 11/1/2002 1379409 207575 143325 1730309 12/1/2002 1254662 238771 162810 1656242 1/1/2003 1091726 161762 142694 1396182 2/1/2003 1253855 175960 154284 1584099 3/1/2003 1549400 242949 166114 1958463 4/1/2003 1724925 283032 168363 2176320 5/1/2003 1618012 307862 180192 2106066 6/1/2003 1822414 325721 136380 2284515 7/1/2003 1748674 377048 140716 2266438 8/1/2003 1465290 309975 160417 1935682 9/1/2003 1565438 282314 161155 2008907 10/1/2003 1589225 253661 164006 2006892 11/1/2003 1607884 223709 179199 2010792 12/1/2003 1430553 204394 149421 1784368 1/1/2004 1068394 194856 127777 1391027 2/1/2004 1233487 233774 157643 1624904 3/1/2004 1614375 243331 163396 2021102 4/1/2004 1648860 289198 140654 2078712 5/1/2004 1815051 326991 159279 2301321 6/1/2004 1922928 393736 171045 2487709 7/1/2004 1921002 332807 150761 2404570 8/1/2004 1702925 323497 167937 2194359 9/1/2004 1461418 249571 160939 1871928 10/1/2004 1405947 224178 126802 1756927 11/1/2004 1506850 239533 124645 1871028 12/1/2004 1495529 202811 147899 1846239 1/1/2005 1148064 202777 135282 1486123 2/1/2005 1405620 201489 182972 1790081 3/1/2005 1727463 270133 197803 2195399 4/1/2005 1769004 422465 162572 2354041 5/1/2005 1886624 320321 170900 2377845 6/1/2005 1957219 341100 209231 2507550 7/1/2005 1739560 337684 171506 2248750 8/1/2005 1807247 392508 193076 2392831 9/1/2005 1709562 320944 181899 2212405 10/1/2005 1671253 288751 160639 2120643 11/1/2005 1646074 285312 189980 2121366 12/1/2005 1408377 205816 145012 1759205 1/1/2006 1485527 229410 150441 1865378 2/1/2006 1522172 261195 169570 1952937 3/1/2006 1929937 343691 189241 2462869 4/1/2006 2005345 339476 191100 2535921 5/1/2006 2132094 392103 187279 2711476 6/1/2006 1952508 394578 177346 2524432 7/1/2006 2002269 411256 178617 2592142 8/1/2006 2051133 374882 208348 2634364 9/1/2006 1921692 289743 186167 2397603 10/1/2006 2193821 320404 194910 2709135 11/1/2006 1950367 319266 189721 2459355 12/1/2006 1982936 294692 171241 2448870 1/1/2007 1928603 270229 156860 2355693 2/1/2007 1668851 279016 189417 2137285 3/1/2007 1822975 332252 178923 2334150 4/1/2007 1873004 398322 191204 2462531 5/1/2007 2264269 459033 239985 2963287 6/1/2007 2152109 467880 210655 2830645 7/1/2007 2188062 434907 246101 2869071 8/1/2007 2081025 390411 235320 2706757 9/1/2007 1639319 306902 184249 2130471 10/1/2007 1792744 328568 195134 2316447 11/1/2007 1732923 356983 214050 2303957 12/1/2007 1769044 307656 207713 2284414 1/1/2008 1348161 275687 217899 1841747 2/1/2008 1532114 310035 240320 2082469 3/1/2008 1883383 329677 221776 2434836 4/1/2008 2027475 454706 225909 2708090 5/1/2008 2120083 414686 265938 2800707 6/1/2008 2081886 457223 216396 2755505 7/1/2008 2123213 435546 244316 2803075 8/1/2008 1994510 421029 217717 2633256 9/1/2008 1622859 323275 203042 2149176 10/1/2008 1775175 382949 179428 2337552 11/1/2008 1671873 326748 169997 2168618 12/1/2008 1487433 322590 174670 1984693 1/1/2009 1050889 240620 140636 1432145 2/1/2009 1260017 295275 192452 1747744 3/1/2009 1886056 414898 200716 2501670 4/1/2009 1907451 430804 157873 2496128 5/1/2009 1733347 492628 147734 2373709 6/1/2009 2018553 485655 179155 2683363 7/1/2009 1862691 487443 225510 2575644 8/1/2009 1722982 429584 169941 2322507 9/1/2009 1532991 425118 169573 2127682 10/1/2009 1487343 389619 164456 2041418 11/1/2009 1302468 340212 168703 1811383 12/1/2009 1263962 314577 189552 1768091 1/1/2010 1273286 281286 169251 1723823 2/1/2010 1395287 320295 160949 1876531 3/1/2010 1808255 472894 207086 2488235 4/1/2010 1669004 477190 220769 2366963 5/1/2010 1736725 481433 215053 2433211 6/1/2010 1970880 467261 195771 2633912 7/1/2010 1934517 511903 181686 2628106 8/1/2010 1983225 531174 180841 2695240 9/1/2010 1795496 422568 178120 2396184 10/1/2010 1654223 431371 178160 2263754 11/1/2010 1265106 322730 177683 1765519 12/1/2010 1398925 326686 145305 1870916 1/1/2011 1463002 294209 160891 1918102 2/1/2011 1572261 356179 217675 2146115 3/1/2011 1897278 529124 242024 2668426 4/1/2011 1726696 494247 197485 2418428 5/1/2011 1998284 578668 225447 2802399 6/1/2011 1853292 508370 201124 2562787 7/1/2011 1741244 454436 227488 2423169 8/1/2011 1578608 497844 184769 2261222 9/1/2011 1407616 428340 184850 2020807 10/1/2011 1530204 412493 203839 2146537 11/1/2011 1488205 347594 175065 2010864 12/1/2011 1394879 378577 185924 1959380 6/1/2013 1621335 555043 212777 2389155 7/1/2013 1764668 574177 225865 2564710 8/1/2013 1516002 521641 217794 2255437 9/1/2013 1468950 435971 179848 2084769 11/1/2013 1549417 408100 182022 2139539 12/1/2013 1367203 392411 193246 1952860 1/1/2014 1366133 420008 203821 1989962 2/1/2014 1429675 425583 205044 2060302 3/1/2014 1761078 602708 220568 2584354 4/1/2014 1883486 648827 188848 2721161 5/1/2014 1921426 639519 221024 2781969 6/1/2014 1948850 700707 218128 2867685 7/1/2014 2023922 709734 239344 2973000 8/1/2014 1758451 630937 209507 2598895 9/1/2014 1708649 544968 193480 2447097 10/1/2014 1684852 519919 210424 2415195 11/1/2014 1426509 472312 186582 2085403 12/1/2014 1329017 407183 168961 1905161 1/1/2015 1503292 618987 166310 2288589 2/1/2015 1550271 645033 242703 2438007 3/1/2015 1860166 657724 246840 2764730 4/1/2015 1983455 697072 239763 2920290 5/1/2015 1935060 732187 219869 2887116 6/1/2015 1868391 754971 264074 2887436 7/1/2015 1818390 656442 222831 2697663 8/1/2015 1734400 684821 212778 2631999 9/1/2015 1606988 659428 167120 2433536 10/1/2015 1622353 610023 183676 2416052 11/1/2015 1658433 554005 213029 2425467 12/1/2015 1667047 556693 228238 2451978 1/1/2016 1573732 632330 213278 2419340 2/1/2016 1767441 726655 197821 2691917 3/1/2016 1921561 732153 230292 2884006 4/1/2016 2149940 804213 193509 3147662 5/1/2016 2144213 830758 216340 3191311 6/1/2016 2119636 736108 237378 3093122 7/1/2016 1816804 761207 234978 2812989 8/1/2016 1670411 830367 225118 2725896 9/1/2016 1716506 855843 195688 2768037 10/1/2016 1681922 605159 224359 2511440 11/1/2016 1730346 598708 196066 2525120 12/1/2016 1706860 683665 204990 2595515 1/1/2017 1780668 666447 212023 2659138 2/1/2017 1818050 668433 166440 2652923 3/1/2017 2004780 732156 200547 2937483 4/1/2017 2000209 689208 213382 2902799 5/1/2017 2004615 975351 227326 3207292 6/1/2017 1966587 901179 237559 3105325 7/1/2017 2018818 834691 233035 3086544 8/1/2017 2037230 954590 262883 3254703 9/1/2017 1643118 706470 216667 2566255 10/1/2017 1908977 711534 230319 2850830 11/1/2017 1820874 535363 196406 2552643 12/1/2017 1809886 650869 183027 2643782 1/1/2018 1827345 758142 244476 2829963 2/1/2018 1683450 728273 204950 2616674 3/1/2018 1930571 879007 213092 3022671 4/1/2018 1984787 1001527 219363 3205677 5/1/2018 2243151 971265 260562 3474977 6/1/2018 2073535 898599 210542 3182677 7/1/2018 2158310 936712 267170 3362191 8/1/2018 2057926 952596 223776 3234298 9/1/2018 1850147 726707 226962 2803816 10/1/2018 1873161 715872 232631 2821663 11/1/2018 1611951 741467 195511 2548929 12/1/2018 1701192 682619 173242 2557053 1/1/2019 1549971 711234 231491 2492696 2/1/2019 1613245 734219 213266 2560730 3/1/2019 2138046 956907 250406 3345359 4/1/2019 2237886 1001957 248686 3488529 5/1/2019 2220788 1100436 252853 3574077 6/1/2019 2070349 1033991 215402 3319742 7/1/2019 2188978 1121488 224046 3534512 8/1/2019 1839150 926100 209664 2974914 9/1/2019 1787275 853763 210579 2851617 10/1/2019 1980380 888867 208067 3077314 11/1/2019 1775600 805675 233142 2814417 12/1/2019 1406877 615933 206869 2229679 1/1/2020 1820891 820419 174744 2816054 2/1/2020 1670460 801852 189104 2661416 3/1/2020 2073103 888794 217819 3179716 4/1/2020 1836664 784413 76491 2697568 5/1/2020 1379929 624224 13452 2017605 6/1/2020 1832422 953769 30649 2816840 7/1/2020 2335909 1049953 96393 3482255 8/1/2020 2327996 1119160 65132 3512288 9/1/2020 2212443 1012572 93276 3318291 10/1/2020 2208443 1113099 150242 3471784 11/1/2020 2303252 1049620 146783 3499655 12/1/2020 1770713 1024186 109803 2904702 1/1/2021 2062343 958974 122966 3144282 2/1/2021 1513216 903072 72694 2488982 3/1/2021 1930916 1009612 94423 3034951 4/1/2021 2091970 1162439 171295 3425703 5/1/2021 2083208 1200617 258082 3541908 6/1/2021 2246011 1252315 270033 3768358 7/1/2021 2219967 1157924 193279 3571170 8/1/2021 2219967 1157924 193279 3571170 9/1/2021 1864300 1195751 213057 3273108 10/1/2021 2018232 1195045 176072 3389349 11/1/2021 2090904 1049462 145704 3286071 12/1/2021 1854157 940287 156196 2950639 1/1/2022 1915930 1002972 108635 3027536 2/1/2022 1697247 1081977 162985 2942209 3/1/2022 2186091 1164325 192715 3543131 4/1/2022 2264546 1108731 179129 3552406 5/1/2022 2229859 1101888 188644 3520391 6/1/2022 2267916 1221078 206336 3695331 7/1/2022 2155520 1245832 197236 3598587 8/1/2022 2156647 1345772 206754 3709174 9/1/2022 2179139 1309579 162507 3651225 10/1/2022 2046806 1147106 122036 3315947 11/1/2022 1775659 1003292 166749 2945700 12/1/2022 1886853 1062630 176394 3125878