1. (Submit a screenshot of the histogram) Create a histogram for column "Midterm" using Excel Data Analysis Function with the following bin in data range C2: C7. Output range is El. Adjust the chart so that the lower right corner is in cell P20. Edit the chart title so that it is read as "Created by Pauline Fu" (replace Pauline Fu with your name). Rename the bin in column E so that it includes both the lower limit and upper limit (for example, 0 to 49, 50 to 59, 60 to 69 etc). Add data labels - outside end. Remove gap among bars (set gap width to 0%). Bin 49 59 69 79 89 99