Create a histogram for the variable wait time in Excel:

Review this video to learn how to create a Histogram in Excel $Er$

Extra Resource: Create a histogram $B$

Use the strategies in the video to create a frequency table of the wait time using the categories $($or classes$)$ of $0-20,21-41,42-62,63-83,84$ or more minutes.

Tip: It may be helpful to sort the data based on the wait time variable first.

Don't forget that you should have a column for "classes" and a column for "frequencies."

Fill in the frequencies of each class.

After the frequency table is complete, highlight the frequency table, and select Insert, then Recommended Charts, and choose the column chart shown and select OK$.$

Right$-$click on one of the bars and select Format Data Series. In the pop$-$up box, change the Gap Width to $0.$

@ Add an appropriate title and axis label.

Save the file to your computer again and upload the file by selecting the "Choose a File" button below.