Chapter 2 Practice Test (Introduction To Categorical Data)
A company wants to show how fast its cars can accelerate when compared with the competition. Which chart should it use to convey this information?
bar chart
Which of the following is an example of a piece of categorical data?
ethnicity
One trick to finding out if information is categorical or quantitative is to analyze the answer to the question. Which of the following is TRUE:
if the answer to the question is numerical, then the information is quantitative. if the answer to the question is a characteristic, preference. etc. then the information is categorical.
Katie is collecting data about the number of people that are interested in different dance styles. After passing out a survey, she has gathered the following information: Style / Number of people interested in this style Ballet / 20 Jazz /12 Hip Hop / 8 Lyrical / 26 Tap / 10 What type of data did Katie collect?
categorical
What is data that is collected in groups or topics, where the number of events in each group is counted numerically?
categorical data
What is one difference between a histogram and a bar graph?
the histogram bar represents a range of dependent variables instead of just one point
Which answer best describes a chart?
a chart is most commonly used to display comparisons
Which answer best describes a graph?
a graph is normally used to display trends over time
What is the distinguishing mark of a line graph?
a line connecting dots
There are several different types of charts in Excel. Which two are the most frequently used?
column and bar
Which of the following should a business use when it wants to compare several products with each other?
column chart
Under which ribbon menu or tab will you find the chart type commands?
insert
David wants to collect information about his friends and how many siblings they each have. David has eight friends. How should he collect this data? Why?
quantitatively: since David isn't dealing with a large amount of information, he can simply ask each friend and analyze the data quantitatively
What type of data is best suited to a composite bar graph?
sales data from multiple locations
A line graph is best used for which of the following data?
sales over time
What is the first step in creating a chart?
select the data for the chart
What type of data is best suited for a range bar graph?
temperature ranges or price ranges
