Using Excel, determine simple linear correlations between handling time and each explanatory variable xi1 and xi2.

EXCEL REPORT:

Regression statistics Coefficient of determination multiple 0.9692 Coefficient of determination R^2 0.9393 Coefficient of determination R^2 0.9312 Standard error 5.728 Observation 18 VARIANCE ANALYSIS Degrees of freedom Sum of square Mean of squares F Critical value of F Regression 2 7613.8554 3806.9277 116.0308 7.49283E-10 Residus 15 492.1446 32.8096 Total 17 8106 Coefficients Standard error Stastic t Probability Lower limit of 95% confidence test Upper limit of 95% confidence test Constant 1.6116 4.0393 0.399 0.6955 -6.998 10.2213 Weight 1.5238 0.2097 7.2651 0.0000 1.0768 1.9709 Distance 1.3618 0.0951 14.3125 0.0000 1.159 1.5646