1. The following data represents the energy consumption of coal (in billions of Btu) by each of the 50 states and the District of Columbia. 631 723 267 60 372 15 19 92 306 38 413 8 736 156 478 264 1015 329 679 1498 52 1365 142 423 365 350 445 776 1267 0 26 356 173 373 335 34 937 250 33 84 0 253 84 1224 743 582 2 33 0 426 474 a. Use the data to construct a frequency distribution (include class limits, frequency, relative frequency, and cumulative frequency) with 7 classes. Class Width = Class Limits Frequency Relative Cumulative Fr- . uen b. Use the class width determined above in 1a to construct a histogram in Excel. Be sure to add a title to the graph and labels for each of the axis. Paste a copy of the graph on the next page. Paste Histogram Here: 2. The results of a survey of 84 people whose identities were stolen using various methods are shown Method Frequency Lost or stolen wallet, checkbook, or 38 credit card Retail purchases or telephone 15 transactions Stolen mail 9 Computer virus or hackers 8 Phishing 4 Other 10 Construct a pie graph in Excel. Be sure to add a title, chart legend, and the percentages for each category in the pie graph. Paste a copy of the graph below. c. Describe the shape of the distribution. 3. The data show the high school dropout rate for students from the years 2003 to 4. A survey was taken on how much trust people place in their information they 2013. read on the Internet. A = trust in all that they read, M = trust in most of what they read, H = trust in about half of what they read, and S = trust in a small portion of Year Percent what they read. 2003 9.9 2004 10.3 M M M A H M S M H M 2005 9.4 S M M M M A M M A M 2006 9.3 M M H M M M H M H M 2007 8-7 AMMMHMMMMM 2008 8.0 2009 8'1 a. Construct a categorical frequency distribution for the data. 2010 7.4 2011 7.1 . 2012 6.6 Category Frequency Relative Frequency 2013 6.8 a. Construct a time series graph in Excel. Be sure to add a title to the graph and labels for each of the axis. Paste a copy of the graph below. b. Use the frequency distnbuon to construct two bar graphs in Excel. The first graph should be using the frequency and the 2"'1 graph using the relative frequency. Be sure to add a title to the graphs and labels for each of the axis. Paste a copy of the graphs below. b. Describe any trends you see in the data