here is the data for the question

QUESTION 17 The table in Distance traveled by ych shows the average quarterly distance traveled in billion miles) by vehicles on urban highways for three different years a. Use a multiple regression model to develop an equation to account for seasonal effects and any linear trend in the data. To capture seasonal effects, use the dommy variables Ott - lif quarter 1, otherwise; Qt2Tlf quarter 2,0 otherwino; Qu3 - 1 quarter 3, otherwise The linear regression model is (Round the codices to two decimal places if tooded) Qui Otr2 OD b. Compote the quarterly forecasts for next year (Yes 4) based on the model developed in the previous part Quer forecast Orienter forecast Quare foot Quarter 4 forecast E H 3 A B D E F G Urban Highways - Average Monthly Distance Traveled by Vehicles (Billion Miles) Quarter Distance 1 4.22 2 5.32 Year 1 3 5.21 5 4 5.12 7 1 4.31 3 2. Year 2 5.44 9 3 5.34 10 4 5.24 1 4.38 12 Year 3 5.51 13 3 5.41 14 4 5.36 15 16 3 1 N