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).

City of weekly riderice per week ilation 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 175,200 $30 1,725,000 $8,600 $75 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