Please answer the below in details, show your workings and Instructions of how to perform each operation in Excel-workbook.

A Truck 1 o e -1 O e e e e e e e e e S O B W= O DO R = s B C D Maintenance Expense Miles Driven Age of Truck $908.56 10,500 10 751.12 9.700 7 $793.55 9,200 8 $619.61 8,300 9 $380.11 6,500 5 $368.72 4,500 2 $235.32 3.500 2 $174.93 2.200 3 $256.30 1,800 2 $799.58 9800 7 $436.04 6600 5 $304.25 3600 1 $226.81 2500 3 $179.68 3100 3 $726.65 8400 10 $810.53 9700 9 $142.53 1800 4 $915.53 10000 11 $813.45 9800 8 $803.78 9900 7 $227.32 1100 1 $231.46 2600 1 $839.21 10300 6 H | J K L M N 0 p Q R a. Estimate a multiple regression equation using the given data. b. Find 95% confidence intervals for the regression coefficients of X1, and X2. Based on the interval estimates, which variable, if any would you choose to remove from the equation estimated in part 1la? why'? Year Weekly Riders Price per Ride Population Income Parking Rate A Estimate a multiple regression model using all of the available explanatory variables. Perform a test of 1,200 $0.15 1,800 $2,900 $0.50 significance for each of the model's regression coefficients. Are the signs of the estimated coefficients consistent 1,190 $0.15 1,790 $3,100 $0.50 with your expectation? 1,195 $0.15 1,780 $3,200 $0.60 B Is there evidence of multicollinearity, in this model? Explain why or why not. If Multicollinearity is present, UAW 1,100 $0.25 1,778 $3,250 $0.60 explain what you would do to remedy this problem. 1,105 $0.25 1,750 $3,275 $0.60 a 1,115 $0.25 1,740 $3,290 $0.70 1,130 $0.25 1,725 $4,100 $0.75 1,095 $0.30 1,725 $4,300 $0.75 1,090 $0.30 1,720 $4,400 $0.75 10 1,087 $0.30 1,705 $4,600 $0.80 11 1,080 $0.30 1,710 $4,815 $0.80 12 1,020 $0.40 1,700 $5,285 $0.80 1,010 $0.40 1,695 $5,665 $0.85 14 1,010 $0.40 1,695 $5,800 $1.00 15 1,005 $0.40 1,690 $5,900 $1.05 16 995 $0.40 1,630 $5,915 $1.05 17 930 $0.75 1,640 $6,325 $1.05 18 915 $0.75 1,635 $6,500 $1.10 19 920 $0.75 1,630 $6,612 $1.25 20 940 $0.75 1,620 $6,883 $1.30 21 50 $0.75 1,615 $7,005 $1.50 22 910 $1.00 1,605 $7,234 $1.55 23 930 $1.00 1,590 $7,500 $1.65 24 933 $1.00 1,595 $7,600 $1.75 25 40 $1.00 1,590 $7,800 $1.75 26 948 $1.00 1,600 $8,000 $1.90 27 955 $1.00 1,610 $8,100 $2.00\f8.45334