Data Analysis 1-8

What is the main purpose of a bar chart in Excel?

• To compare parts of a whole

• To display data in the form of a frequency distribution

• To show total data each year

• To show the relationship between two variables

In a pie chart, the largest section represents:

• The data with the highest frequency
  

• The data with the smallest value

• The relationship between two variables
  

• The comparison between average values

A histogram is used to:

• Compare data categories

• Display the distribution of quantitative data

• Count the number of categories in data
  

• Create a time-series graph

The SUM function in Excel is used to:

• Calculate the average value

• Add up all values in a range
  

• Count the number of data points in a range
  

• Display data in a pivot table

What is the main difference between a histogram and a frequency distribution?

• A histogram is used for qualitative data, while a frequency distribution is for quantitative data
  

• A histogram is a graph, while a frequency distribution is a table
  

• A histogram is more accurate than a frequency distribution
  

• There is no difference

In the data presented, which visitor category had the highest total visitors in 2018?

• General

• School

• Member

• No data

In the given bar chart, which year had the lowest total number of visitors?

• 2015

• 2016

• 2017

• 2018

Which year had the highest total number of visitors?

• 2019

• 2020

• 2021

• 2022

What is the primary purpose of a bar chart like the one shown?

• To show trends over time

• To illustrate frequency distributions

• To display relationships between variables

• To compare quantitative data across categories

What percentage of visitors in 2022 were General Visitors?

• 13.4%
  

• 21.8%

• 64.8%

• 50.0%