Ten bolted timber joints were tested using a ½ in. bolt placed in double shear through three pieces of 2 by 4 in. (nominal size) Douglas fir. The results of the shear were (loads shown in pounds):specimen load at 1/16" load at 1/8" ultimate load1 3500 3900 40002 3400 3500 35003 3100 3600 38004 2700 3500 41505 2900 3680 40506 3400 4250 45007 2700 3500 44008 3100 3700 42509 3100 4100 455010 2300 3200 3650A) Using a spreadsheet program, calculate the sample standard deviations and coefficients of variation for each set of data (ie load at 1/16", load at 1/8", ultimate load).B) Plot scatter diagrams and compute the sample correlation coefficients between the ultimate load and each of the loads at 1/16 and 1/8" deflection. Calculate the correlation using both the built-in function as well the equation for the correlation. C) Do you think that it is possible to use either of the simpler, nondestructive tests as a predictive tool for the ultimate joint capacity? Of the two tests at 1/16 and 1/8", which is better as a predictor of the ultimate?