1. Unemployment Histogram [12 points] Seasonally adjusted unemployment rates by state for April 2019. Source: Bureau of Labor Statistics AL 12.9 IN 16.9 NE 8.3 RI 17 AK 12.9 IA 10.2 NV 28.2 SC 12.1 AZ 12.6 KS 11.2 NH 16.3 SD 10.2 AR 10.2 KY 15.4 NJ 15.3 TN 14.7 CA 15.5 LA 14.5 NM 11.3 TX 12.8 11.3 ME 10.6 NY 14.5 UT 9.7 CT 7.9 MD 9.9 NC 12.2 VT 15.6 DE 14.3 MA 15.1 ND 8.5 VA 10.6 FL 12.9 MI 22.7 OH 16.8 WA 15.4 GA 11.9 MN 8.1 OK 13.7 WV 15.2 HI 22.3 MS 15.4 OR 14.2 WI 14.1 ID 11.5 MO 9.7 PA 15.1 WY 9.2 IL 16.4 MT 11.3 a) Use Excel to draw a histogram to represent this data. (A data file is attached- first sheet.) b) Find the 5-number summary for the data. c) Find the mean and standard deviation of the data. d) The interquartile range is the name given to the distance between the upper and lower quartiles. What is its value in this problem? e) In the course materials we used the word 'outlier' in an informal way but sometimes this is defined as follows: Find the values given by the upper quartile plus the interquartile range, and the lower quartile minus the interquartile range. (What are these values in this problem?). An outlier is a data point that does not lie between these two values. Are there any outliers in this