Construct the bar graph for the variable satisfaction in excel:

• Use the strategies in the video to construct the frequency table of the satisfaction levels using the categories: Completely Dissatisfied, Dissatisfied, Average, Satisfied, and Completely Satisfied.
  • Tip: It may be helpful to sort the data based on the satisfaction variable first.
  • Don't forget that you should have a column for "Satisfaction Levels" and a column for "frequencies".
• Fill in the frequencies of each category.
• After the frequency table is complete, highlight the frequency table, and select Insert, thenRecommended Charts, and choose the column chart shown and selectOK.
• Add an appropriate title and axis label.

Satisfaction

4

5

2

3

1

4

4

5

5

4

3

5

3

4

5

4

3

2

3

2

2

2

3

4

4

3

2

3

2

2