Question: How do I solve this in excel? Use the Bridge Support data provided. For a bridge construction project, 300 bridge supports were ordered. The data
How do I 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
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
