Excel Question

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 2022 and a separate forecast for imports of each type in only July 2022. This is a TWO PAGE MEMORANDUM. Example videos used a previous set of data which has been augmented with more recent data.