Table_2 includes information from a household travel survey database for your use in Question 2 of this assignment. This table contains one record (i.e., row) for each household surveyed in a selected set of zones within a City, where each record includes total daily trips made by the household and various additional pieces of information concerning the household. Using these data, develop a zone-based regression model for daily shopping trip generation. The dependent variable is the total number of daily trips generated within a given zone1, and the independent variables are appropriate zonal total, median, or average values that you think should be appropriate for your model. 1 Please note that each zone has a representative sample of households (mentioned as the "HH Sample Size in the zone" in the dataset) in the data, not all households. To obtain the zonal total trips, the household weight must be multiplied by the corresponding number of household trips, and then the zonal total needs to be calculated. For independent variables, you can take a sample average or median of households in the zone ! To generate zone-based data for the model, you can use the 'PivotTable' option in MS Excel. You can also use MS Excel for regression