includes data description, data inference, and the search for relationships in data
2
New cards
decision making
optimization techniques for problems with no uncertainty, and structured sensitivity analysis
3
New cards
data tables
also what-if tables, let you see what happens to selected outputs as selected inputs change
4
New cards
goal seek
allows you to vary a single input cell to force a single output cell to a selected value
5
New cards
population
includes all of the entities of interest in a study
6
New cards
sample
subset of the population, often randomly chosen and preferably representative of the population as a whole
7
New cards
data set
rectangular array of data, with variables in columns and observations in rows
8
New cards
variable
attribute, a characteristic of members of a population, such as height, gender, or salary
9
New cards
observation
(or case or record), list of all variable values for a single member of the population
10
New cards
ordinal
categorical variable if there is a natural ordering of its possible values
11
New cards
nominal
no natural ordering
12
New cards
binned variable
corresponds to a numerical value that has been categorized into discreet categories
13
New cards
discrete
numerical value if it results from a count, such as number of children
14
New cards
continuous
result of an essentially continuous measurement, such as weight or height
15
New cards
measures of central tendency
mean, median, mode
16
New cards
interquartile range
third quartile minus the first quartile
17
New cards
variance
the average of the squared deviations from the mean
18
New cards
standard deviation
square root of the variance
19
New cards
population standard devitions
the square root of the population variance
20
New cards
mean absolute deviation
the average of the absolute deviations
21
New cards
skewness
occurs from lack of symmetry, skewed to the right or left
22
New cards
kurtosis
deals with the fatness of the tails of the distribution relative to the tails of a normal distribution
23
New cards
histogram
most common type of chart for showing the distribution of a numerical value, based on dividing the variable into discrete catergories
24
New cards
box plots
big picture chart, consists of the minimum value, the first quartile, the median, the third quartiles and the maximum, outliers show as individual points
25
New cards
time series graph
graph of values of one or more time series, using time on the horizontal axis
26
New cards
cross sectional data
data on a cross section of a population at a distinct point in time, baseball salaries