2: Forecasting Honda Civic Sales in Canada Project Practice - Solve this problem using Excel Background: The Honda Civic is a popular compact car model that has been manufactured and sold in Canada by Honda Canada Inc. since 1972. As a car manufacturer, it is important for Honda to accurately predict monthly sales in order to make informed decisions about production and marketing. In this case study, we will use linear regression to predict monthly sales of the Honda Civic in Canada using economic indicators and Google search queries. Data: The data set used for this case study includes monthly sales figures for the Honda Civic in Canada from 2010 to 2014, as well as economic indicators such as unemployment rate, Consumer Price Index (CPI) for all goods and services, CPI for energy, and Google search queries for the Honda Civic. The data set has been split into training and testing sets, with observations from 2010 to 2012 being used for training and observations from 2013 to 2014 being used for testing. BUS 373 ASSIGNMENT 1 4 Task: Using the training data, build two forecasting models to predict monthly sales of the Honda Civic in Canada. In the first model, use Unemployment, CPI_all, CPI_energy and Queries as the independent variables, while for the second model, include the month as a categorical independent variable as well. You need to evaluate the performance of these models, first identify which regression model is better using