State Record High (OF) To start with we will make a frequency table and histogram by hand, no Excel Legend Alabama 1 12 formula for this part! If a cell is shaded You should Alaska 100 Blue Enter a text response Arizona 128 1) Sort the data by temperature. Green Enter a number Arkansas 120 2) Find the range of the data. Range = Max - Min Gold California Enter an Excel formula 134 Any other color Colorado 118 Split the data up into 6 equal length bins. To make sure that all of the data falls into a bin, split Make no changes Connecticut 106 the interval (Min - 1, Max + 1] into six sub intervals. The length of each sub interval will be Delaware 110 (Max + 1) - (Min -1))/6. We call this the bin width. Florida 109 3) Compute the bin width Georgia 112 4) Complete the following table Hawaii 100 Bil Low High Frequency Relative Frequency Idaho 118 Illinoi 117 Indiana 116 W I Iowa 118 Kansas 121 a UI + Kentucky 114 Louisiana 114 Hint: Highlight the sorted data in the table so that the color of the data matches the color of the Maine 105 bin. This provides a visual representation of the bins. Then use this to easily fill out the table. You Maryland 109 may use an Excel formula for the relative frequency. Massachusetts 107 Relative Frequency = Frequency/Total Michigan 112 5) Create a hand generated relative frequency histogram where each bar is color coded to match Minnesota 114 your chosen colors above. Make sure to add the labels and the counts. Mississippi 115 Missouri 118 Montana 117 Nebraska 118 Nevada 125 New Hampshire 106 New Jersey 110 New Mexico 122 New York 108 North Carolina 110 North Dakota 121 Ohio 113 Oklahoma 120 Oregon 119 Pennsylvania 111 Rhode Island 104 South Carolina 113 South Dakota 120 Tennessee 113 Texas 120 Utah 117 Vermon 105 Virginia 110 Washington 118 West Virginia 112 Wisconsin 114 Wyoming 115