An airport shuttle service wants to determine the length of time it would take to transport passengers from various locations to a major metropolitan airport during nonpeak hours. A sample of 16 trips on a particular day during nonpeak hours indicates the following: Distance (miles) Time (minutes) Distance (miles) Time (minutes) 35.0 19.5 25.4 27.0 10.3 11.6 16.1 14.3 a. Using Excel, rearrange the data into two columns (distance and time) and then build a scatter diagram. Think what should be your Y (dependent) variable and what should be your X (independent) variable. No need to submit the results. b. Calculate the covariance between distance and time using Excel. What is its value? 0. Calculate the correlation coefficient. What is its value? d. Calculate the least-squares regression equation using distance as an independent variable and time as a dependent variable. Intercept: and Slope: 0 9. Is the intercept coefficient significant at the 5% level? 0 f. Is the slope coefficient significant at the 5% level