Skip to main content
11.6: Chapter Review - Key Terms
-
-
Last updated
-
-
Save as PDF
-
Key Terms
-
bar chart
-
horizontal column chart
-
benchmarking
-
tool that checks the validity of your data with similar datasets or a set standard
-
Calculated Field
-
tool that allows addition of columns of calculations to a PivotTable
-
categorical data
-
data that is grouped into categories based on attributes or characteristics
-
clustered column chart
-
column chart that includes multiple variables to show the comparison between the groups
-
combination chart
-
chart that combines two different chart types in one visual
-
continuous data
-
information that is measured and can take on an infinite set of values
-
Correlation
-
used to analyze the relationship between two variables
-
data validation
-
process of ensuring that data values fall within a predetermined range
-
data verification
-
process used to ensure that your data is accurate and reliable
-
discrete data
-
information that can only take on a specific set of values
-
histogram
-
chart that displays the number of occurrences of data within a defined range
-
line chart
-
chart used to show changes over time
-
numerical data
-
data that is quantitative and represents measures of the variables
-
qualitative data
-
categorical information that does not include numbers; if it does include numbers, they do not have a true mathematical meaning
-
quantitative data
-
data that involves numerical evaluations
-
scatter chart
-
chart used to show the relationship between two variables
-
slicer
-
visual, interactive way to filter data in a PivotTable
-
sparkline
-
small charts inserted into cells next to data that show changes over time