Problem $1$ is worth $5$ points. This problem shows how to visualize grade data in a new way.

On the first worksheet, set up a table as shown in figure $1$ below.

You will create unique, random numbers for the quantity of A$$s$,$ B$$s$,$ C$$s$,$ D$$s$,$ and F$$s in the table. To generate your numbers, use the Excel formula $=$randbetween$(5,10)$ to generate a random integer between $5$ and $10$ for each letter grade in column B$.$

In cell B$10,$ sum the number of students in the class by adding up the number of each grade. Use the "sum$()"$ function for this.

Format the table like we typically do in class and don't forget to include your name.

Create a bar chart or histogram of the data. A bar chart allows you to easily visualize the magnitude of the data, in this case, letter grades. Name the graph appropriately and use vertical and horizontal axis labels. Letter grades should appear on the horizontal axis and number of students on the vertical axis. See figure $2$ for an example.

Create a pie chart of the data. A pie chart is a different way to look at the same data. Each "slice" of the pie is sized proportionally to the data. Again, give the graph a descriptive title and ensure that you include the letter grade and percentage of the total within each portion of the chart. See figure $3$ for an example and the options you should pick to get the same results. Note that a legend is not used for this pie chart.