1) Download the file below. 2) Sort the data in Excel, but create a frequency distribution with 9 classes of equal width using pencil and paper first.) (Take high value - low value, divide by 9 and round up to the nearest integer.) 3) Create a frequency distribution which includes the left end point and excludes the right end point as we did in class using the inequality notation. (Note: Excel does the opposite.) 4) In order to "trick" Excel to do what is our convention, subtract 0.5 from both end points. (Note: when you do this by hand, you don't need to subtract 0.5.) 5) In Excel, create a table with Lower, Upper, and Midpoint. (Start the pattern and drag down as we did in class. You may uses short-cut keys.) 6) Using the Data Analysis tool as we did in class, create the histogram and double check that the counts are the same you got in Step 3) above. (Make sure you use the upper class limit as your data input and delete the "More" category.) 7) Adjust the histogram as we did in class. (Remove and gaps and