M2 Flashcards
[ ] consists of organizing, summarizing, and visualizing data.
Descriptive Analytics
[ ] is the state of getting dispersed or spread.
Dispersion
[ ] means the extent to which numerical data is likely to vary about an average value.
Statistical Dispersion
[ ] helps to understand the distribution of data.
Dispersion
[ ] is the measure of variability, It is the average squared deviation from the mean.
Variance
[ ] is the measure how far the data deviates from the mean value. This is also know as the square root of variance.
Standard Deviation
[ ] is used to determine how estimations for a group of observations are spread out from the mean.
Standard Deviation
[ ] is the difference between the largest and the smallest value in the data.
Range
[ ] is the difference between the observed value of a data point and the expected value.
Deviation
[ ] is the average deviation of a data point from the mean, median, or mode of the data set.
Mean Deviation or Mean Absolute Deviation (MAD)
[ ] can be abbreviated as MAD.
Mean Deviation
[ ] describes the type of the graph.
Shape
Making a decision about the probability of data is based on [ ].
its shape
[ ] can be defined as a statistical measure that describes the lack of symmetry or asymmetry in the probability distribution of a dataset.
Skewness
Add a range of cells.
SUM(range)
Add cells from sum_range if the condition specified in criteria on range is met.
sumif(range, criteria, sum_range)
Calculates the mean of a range of cells.
AVERAGE(range)
Calculates the average_range if the condition in criteria on range is met.
AVERAGEIF(range, criteria, average_range)
Calculates the media value for a data set: half the values in the dataset are greater than the median and half are less than the median.
MEDIAN(range)
Returns the maximum value of a dataset.
MAX(range)
Returns the minimum value of a dataset.
MIN(range)
Returns the kth smallest or kth largest value in a specified data range.
SMALL(range, k) | LARGE(range, k)
Counts the number of cells containing numbers in a range.
COUNT(range)
Counts the number of non-blank cells within a range.
COUNTA(range)
Counts the number of blank cells within a range.
COUNTBLANK(range)
Counts the number of cells in range that are the same as value.
COUNTIF(range, value)
Calculates the variance of a sample or an entire population; equivalent to the square of the standard deviation.
VAR(range) | VARP(range)
Calculates the standard deviation of a sample or an entire population; the standard deviation is a measure how much values vary from the mean.
STDEV(range) | STDEVP(range)
[ ] takes the average of a given set of data points over the past number of periods.
Moving Average
Use [ ] to easily see the trends in the data.
moving average
In a [ ], the length of the bars represent frequency of cost, and are arranges with longest bars on the left and the shortest on the right.
Pareto Chart
[ ] is a methodology for monitoring a process to identify special causes of variation and signing the need for corrective action.
Statistical Process Control
What are the two types of Statistical Process Control?
- Common Cause Variation
- Special Cause Variation
[ ] is when process produce variations which can be considered natural or common to the process and will nearly always be present; the processes are in control.
Common Cause Variation
[ ] is when processes display larger amounts of variation and often stem from external sources and are considered not in control.
Special Cause Variation