1/74
Comprehensive vocabulary flashcard set covering foundational concepts, data types, measurement scales, data preparation, visualization, measures of center and spread, risk and growth, relative location, and Excel functions for ISDS 2000 Test 1.
Population
The complete group of individuals, objects, transactions, events, or measurements of interest.
Sample
The subset of the population that is actually observed or measured.
Parameter
A numerical characteristic describing a population.
Statistic
A numerical characteristic calculated from a sample.
Descriptive statistics
Organizes, summarizes, and presents the observations that were actually collected.
Inferential statistics
Uses sample information to draw conclusions about a larger population.
Cross-sectional data
Observations collected from many subjects or units at approximately one point in time.
Time-series data
Observations collected across time over multiple periods.
Structured data
Data organized into a predefined row-and-column format, such as a database table or spreadsheet.
Unstructured data
Data that does not follow a predefined row-and-column format, such as text, images, audio, video, or voice messages.
Big data
Large, rapidly generated, varied, or complex data sets; having more data does not automatically mean better or more reliable data.
Categorical variable
A variable representing a label, name, type, or group, including numeric digits used solely as identifiers.
Numerical variable
A variable representing a meaningful amount or count where arithmetic operations are valid.
Discrete numerical variable
A numerical variable with separate, countable values, typically resulting from counting.
Continuous numerical variable
A numerical variable that can take any value within an interval, typically resulting from measurement.
Nominal scale
A measurement scale featuring categories with names or labels only and no inherent order.
Ordinal scale
A measurement scale featuring ordered categories that can be ranked, though interval spacing is unequal or unknown.
Interval scale
A measurement scale featuring meaningful equal differences between values where zero is arbitrary and does not represent none.
Ratio scale
A measurement scale featuring meaningful equal differences and a true zero, where zero represents the total absence of what is measured.
Missing value
An expected observation or value that was not recorded.
Omission
The removal or exclusion of missing observations or values from an analysis, which may reduce information or create bias.
Imputation
Replacing a missing value with a reasonable estimate rather than an original observation.
Subsetting
Extracting a relevant portion of a data set by selecting specific rows and/or columns matching a business question.
Data Privacy
Rules and practices concerning how data are collected, stored, used, shared, and protected, emphasizing confidentiality, transparency, and accountability.
Data Ethics
Principles examining whether data are used fairly, responsibly, and with appropriate consideration of human consequences and bias avoidance.
Frequency
The actual count or number of observations in a category or numerical interval.
Relative frequency
The proportion calculated by dividing category frequency by total observations, represented by the formula Relative frequency=nf.
Percent frequency
The relative frequency multiplied by 100%, calculated as Percent frequency=Relative frequency×100%.
Cumulative frequency
A running total of frequencies through an upper limit, answering questions such as at or below, no more than, up to, or or less.
Approximate class width
The interval width calculated as Number of intervalsMaximum−Minimum, which may be rounded to cover the full data range.
Histogram
A visual display of a numerical frequency distribution where adjacent bars represent contiguous numerical intervals.
Bar chart
A graphical display used for comparing categorical groups using separate, non-contiguous bars.
Pie chart
A graphical display emphasizing part-to-whole composition for a categorical variable with relatively few categories.
Contingency table
A grid table displaying frequencies or percentages for combinations of two categorical variables.
Clustered column chart
A bar chart variant placing subgroup bars side-by-side to make bar heights easier to compare.
Stacked column chart
A bar chart variant displaying part-to-whole composition by showing how each group column is divided.
Scatterplot
A two-variable display for numerical data used to examine direction, form, clusters, and outliers.
Line chart
A visual display used to track trends, major changes, and variation across an ordered sequence, usually time.
Grouped scatterplot
A display of two numerical variables plus a categorical grouping variable represented by series, markers, or colors.
Bubble chart
A visual display featuring two numerical axes and representing a third numerical variable using bubble size.
Symmetric distribution
A distribution shape where the left and right sides are roughly balanced, resulting in Mean≈Median.
Positive/right skew
A distribution shape with a longer tail extending to the right toward larger values, resulting in Mean>Median.
Negative/left skew
A distribution shape with a longer tail extending to the left toward smaller values, resulting in Mean<Median.
Stem-and-leaf display
A display that preserves individual raw data values while visually presenting the overall shape of the distribution.
Mean
The arithmetic average calculated as Mean=nSum, where every observation affects the final value.
Median
The middle value after sorting observations (located at position 2n+1), which is resistant to extreme values and outliers.
Mode
The most frequently occurring value or category in a data set.
Weighted mean
An average computed as xˉw=∑wi∑(wixi) used when observations do not contribute equally.
Percentile
The pth percentile is a value such that approximately p% of observations lie at or below it.
Quartiles
Specific percentiles dividing sorted data into quarters: Q1 (25th percentile), Q2 (50th percentile or median), and Q3 (75th percentile).
Five-number summary
A descriptive set consisting of the minimum, Q1, median (Q2), Q3, and maximum.
Interquartile range (IQR)
The spread of the middle 50% of the data, calculated as IQR=Q3−Q1.
Boxplot
A visual plot showing the middle 50% box from Q1 to Q3, a median line, whiskers for typical range, and separate points for possible outliers.
Outlier fences
Boundary thresholds defined by Lower fence=Q1−1.5(IQR) and Upper fence=Q3+1.5(IQR) to flag values needing review.
Range
The total spread from smallest to largest value, computed as Range=Maximum−Minimum.
Mean absolute deviation (MAD / AVEDEV)
The average absolute distance of observations from their mean.
Variance
The average squared deviation around the mean, represented as s2 for a sample and σ2 for a population.
Standard deviation
The positive square root of variance (SD=Variance), returning variability to original units (s for sample, σ for population).
Coefficient of variation (CV)
A measure of relative variability calculated as CV=MeanStandard deviation, used to compare datasets with different units or means.
Empirical Rule
A rule for bell-shaped, symmetric distributions stating that approximately 68% of data lie within μ±1σ, 95% within μ±2σ, and 99.7% within μ±3σ.
Chebyshev's Theorem
A rule applying to any distribution shape stating that at least 1−k21 of observations lie within k standard deviations of the mean (for k>1).
Z-score
A standardized score computed as z=σx−μ, representing the number of standard deviations an observation x is above or below the mean.
Covariance
A measure indicating the direction of a linear relationship between two variables, dependent on measurement units.
Correlation (r)
A standardized statistic between −1 and +1 measuring both the direction and strength of a linear relationship.
Geometric mean return
The constant compounding rate calculated as (Product of growth factors)n1−1, where returns r become growth factors (1+r).
Sharpe ratio
A risk-adjusted return measure calculated as Standard DeviationReturn−Risk-Free Rate, representing excess return per unit of risk.
COUNTA
An Excel function that counts non-empty cells in a specified range.
COUNTBLANK
An Excel function that counts empty cells in a specified range.
COUNTIF
An Excel function that counts the number of cells meeting one specified condition.
COUNTIFS
An Excel function that counts the number of observations meeting multiple specified conditions.
GEOMEAN
An Excel function that calculates the geometric mean of positive growth factors or values.
CORREL
An Excel function that calculates the correlation coefficient between two numerical variables.
COVARIANCE.S
An Excel function that calculates the sample covariance between two numerical variables.
PERCENTILE.INC
An Excel function that returns the pth percentile of a range, where k is a decimal input from 0 to 1.
QUARTILE.INC
An Excel function that returns a position from the five-number summary, where quart is an integer from 0 to 4.