Problem 2for the Data SetSoftdrink.csv:

Data link:

https://drive.google.com/file/d/1hm8NHSKO-4J9Kw2sEfz4h_UgpWcmguX-/view?usp=drivesdk

You are an analyst in asoft drink company and you are expected to forecast the sales of the production of the soft drink for the upcoming 12 months from where the data ends. The data for the production of soft drink has been given to you from January 1980 to July 1995.

Please do perform the following questions on each of these two data sets separately.

1. Read the data as an appropriate Time Series data and plot the data.
2. Perform appropriate Exploratory Data Analysis to understand the data and also perform decomposition.
3. Split the data into training and test. The test data should start in 1991.
4. Build various exponential smoothing models on the training data and evaluate the model using RMSE on the test data. Other models such as regression, naive forecast models, simple average models etc. should also be built on the training data and check the performance on the test data using RMSE.
5. Based on the model-building exercise, build the most optimum model(s) on the complete data and predict 12 months into the future

Note:The points for the two data sets are divided equally.