Chapter 1-3: https://www.bluebikes.com/ (40pts.) Use the Blue bikes trip duration (seconds) data set to solve the following problems: 1. Use a calculator or software to find the following statistics values-mean, median, mode, range, midrange, and the standard deviation for the data set. 2. Organize the data set in a frequency table using bins with width 300, starting from 0- 299, 300-599 and so on. Include columns for the relative and cumulative frequency. 3. Construct a histogram based on the table of step 2. Analyze the distribution curve- number of peaks, the symmetry, and variation. 4. Use the frequency table (step 2) and identify class midpoints and class boundaries. Calculate the mean, median and mode of the data set based on the frequency table. Compare these values with the values you found in step 1 5. Calculate the standard deviation of the data set using the frequency table (step 2) and the formula, S = n[E(f * x2) ] - [E(f * x)] n(n - 1) where x represents the class midpoint, f represents the class frequency, and n represents the total number of sample values. Also, compare this value of standard deviation with the value found in step 1. (Are they the same? Did we expect these two values to be the same?) 6. Calculate the coefficient of variation of the data set (based on the mean and standard deviation calculated in step 1). 7. Use range rule of thumb to estimate the standard deviation of the data set. Compare this approximation with the values found in step 1 and 5. ( Are they the same? Did we expect the values to be the same? Why or why not? ) 2 8. Use a calculator or software to Iinu un Number Summary of the data set. Construct a boxplot. Analyze the distribution of the data set based on the boxplot. Calculate IQR, semi-interquartile range, and midrange. 9. Identify and list outliers if there are any and construct a modified boxplot. 10. Identify the data value of the 73th percentile -P73. Find in which percentile is the value 453. You can solve this problem manually or using statistical software. If you use software, attach all software calculations, graphs, tables, diagrams. Include analysis and answer all questions. Just print outs written report