Construct the histogram for the variable wait time in Excel:

• 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, thenRecommended Charts, and choose the column chart shown and selectOK.
• Right-click on one of the bars and selectFormat Data Series. In the pop-up box, change the Gap Width to 0.
• Add an appropriate title and axis label.

Wait Time

18

19

60

28

90

15

15

10

8

25

20

15

30

35

5

20

10

90

30

35

40

45

60

61

10

60

70

85

80

88