How do you solve this in excel?

Use the Bridge Support data provided. For a bridge construction project, 300 bridge supports were ordered. The data contains the estimated size of each support and the actual size. Please answer the following questions on the worksheet labeled Problem 2 Questions that is located directly after the worksheet labeled Problem 2. a. Create a linear regression model to estimate the actual support size as a function of the estimated size. b. What do you conclude? Be specific and explain your answer fully. - - o 1 OOTA CON 2 3 4 5 6 7 3 3 o 1 Support Number 1 2 3 4 5 6 7 8 9 9 10 11 12 13 14 15 16 17 Support Support Estimated Actual 30.55 29.25 39.25 59.92 11.33 8.00 60.08 56.75 40.83 68.50 28.75 32.42 61.08 55.75 40.08 54.75 15.83 16.83 22.58 43.25 40.08 73.08 41.08 31.75 31.67 34.34 50.83 48.50 5.83 2.83 15.42 18.51 11.67 17.50 2 3 A 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 B 15.42 11.67 21.67 24.83 6.97 35.83 19.75 53.42 20.52 20.83 40.08 35.83 20.52 40.83 9.42 11.67 20.83 21.33 61.33 18.51 17.50 29.34 33.50 26.64 27.09 22.42 52.09 22.19 28.50 25.75 31.51 20.19 67.09 14.09 18.34 22.92 12.00 66.00 A D 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 B 28.42 15.42 50.83 51.67 26.67 9.42 40.83 49.75 21.08 16.33 5.58 28.42 28.75 20.08 41.67 19.75 50.83 39.25 28.42 32.09 28.09 61.76 46.34 35.34 14.09 57.92 48.42 42.75 27.00 19.25 32.09 32.42 38.75 61.34 22.42 54.34 60.92 31.09