Understanding Charts and Graphs in Excel

The video tutorial covers various methods to display qualitative data, including pie charts, bar graphs, Pareto charts, side-by-side bar graphs, and stacked bar graphs. It explains how to create these charts using Excel, focusing on their applications and differences. The tutorial emphasizes understanding relative frequency and central angle measures for pie charts, distinguishing between bar graphs and histograms, and using side-by-side and stacked bar graphs for comparing data sets.

Which of the following is NOT a method to display qualitative data?

• Pareto chart

• Histogram

• Bar chart

• Pie chart

What is the central angle measure for a pie chart if the relative frequency is 0.25?

• 90 degrees

• 45 degrees

• 180 degrees

• 360 degrees

In Excel, which chart type should you select to create a pie chart?

• 2D Column

• Line Chart

• 2D Pie

• 3D Bar

What is a key difference between a bar graph and a histogram?

• Bar graphs have categories on the horizontal axis

• Histograms have gaps between bars

• Bar graphs display quantitative data

• Histograms are used for qualitative data

When creating a bar graph in Excel, what should you do to ensure the bars are distinct?

• Use a 3D effect

• Add data labels

• Vary colors by point

• Use a pie chart instead

What distinguishes a Pareto chart from a typical bar graph?

• Bars are arranged alphabetically

• Bars are arranged by frequency

• Bars are arranged by color

• Bars are arranged by size

What is the primary use of a side-by-side bar graph?

• To compare a single data set

• To display quantitative data

• To show data over time

• To compare differences in data sets

In Excel, how can you adjust the scale of a side-by-side bar graph?

• Use a different color scheme

• Add more data

• Double-click the axis and modify the scale

• Change the chart type

What is a benefit of using a stacked bar graph?

• It shows individual data points

• It compares totals of the same variables

• It is easier to create than other graphs

• It uses less data