**Question **# 1. Spot speeds study was conducted on a 400-feet stretch mile of rural road in Nevada last year. The speeds of a sample of 125 vehicles are shown in Table 1. Use a spreadsheet program and this set of observations (Table 1 and 2 are provided in an accompanying Excel file) to respond to the following questions. As much as possible, use the functions in the spreadsheet program. Submit your spreadsheet file A. What was the speed range for the study? ii. the standard deviation iii. the pace C. Using Table 2, plot a histogram of the observed vehicles' speed and determine the mode forthe speed (i.e., modal speed) (5 points) D. From Table 2, develop a cumulative frequency distribution curve of the data and determinethe following (8 points)i. the median speed ii. the 85th percentile speed B. In a spreadsheet, copy and complete Table 2, and from the table determine (10 points)i. the mean