have completed the assignment, please save, scan, or take photos of your work and upioad your miles

$,$ and PNG file formats.

Q$1(5$ points$)$

$($Submit a screenshot of the histogram$)$ Create a histogram for column "FinalMark" using Excel Data Analysis Function with the following bin in

data range C$2$: C$11.$ Output range is E$1.$ Adjust the chart so that the lower right corner is in cell M$12.$ Edit the chart title so that it is read as

"Chart 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 $5,5$ to $10,11$ to $15$ etc$).$ Add data labels $-$outside end. Remove gap among bars $($set gap width to $0\%).$

Add Image$/$PDF files to Q$1$

Add Image$/$PDF files

or drag and drop