Use the data in the accompanying Excel file to predict the number of weekly riders in a transit systems based on: average parking rates per month, price per week, population of city, and monthly income of riders. Answer the following questions. You may use Excel or Minitab for your analysis.a. Fit a multiple linear regression model using the regressor variables and the predictor variable.b. Calculate the number of weekly riders given the following:i. $20 per week ii. 1,793,000 city population iii. $6,000 monthly incomeiv. Average monthly parking rate of $55c. Test for significance of regression. What are your conclusions?d. Test for significance of each regressor variables. List the SIGNIFICANT regressor variable(s).e. Do NOT CHANGE your answer for part a). Create a new model with only the significant variable(s).

City of weekly riderice per week lation of city incomgopaidang rates per month 192,000 $15 1,800,000 $5,800 $50 190,400 $15 1,790,000 $6,200 $50 191,200 $15 1,780,000 $6,400 $60 177,600 $25 1,778,000 $6,500 $60 176,800 $25 1,750,000 $6,550 $60 178,400 $25 1,740,000 $6,580 $70 180,800 $25 1,725,000 $8,200 $75 8 175,200 $30 1,725,000 $8,600 $75 9 174,400 $30 1,720,000 $8,800 $75 10 173,920 $30 1,705,000 $9,200 $80 11 172,800 $30 1,710,000 $9,630 $80 12 163,200 $40 1,700,000 $10,570 $80 13 161,600 $40 1,695,000 $11,330 $85 14 161,600 $40 1,695,000 $11,600 $100 15 160,800 $40 1,690,000 $11,800 $105 16 159,200 $40 1,630,000 $11,830 $105 17 148,800 $65 1,640,000 $12,650 $105 18 115,696 $102 1,635,000 $13,000 $110 19 147,200 $75 1,630,000 $13.224 $125 20 150,400 $75 1,620,000 $13,766 $130 21 152,000 $75 1,615,000 $14,010 $150 22 136,000 $80 1,605,000 $14,468 $155 23 126,240 $86 1,590,000 $15,000 $165 24 123,888 $98 1,595,000 $15,200 $175 25 126,080 $87 1,590,000 $15,600 $175 26 151,680 $77 1,600,000 $16,000 $190 27 152,800 $63 1,610,000 $16,200 $200