Answer
The dot plot for the provided data is given below:
Work Step by Step
The dot plot represents the number of counts for different classes. The steps to create a dot plot in Excel are as follows:
Step 1: Enter the data in excel sheet.
Step 2: Find counts for all individuals using function .
Step 3: Select the data and go to Insert option in the menu bar. Under histogram title select appropriate dot plot to represent the data.
Step 4: Add the elements of chart according to data.
