M2

Question 1

[ ] consists of organizing, summarizing, and visualizing data.

Answer 1

Descriptive Analytics

Question 2

[ ] is the state of getting dispersed or spread.

Answer 2

Dispersion

Question 3

[ ] means the extent to which numerical data is likely to vary about an average value.

Answer 3

Statistical Dispersion

Question 4

[ ] helps to understand the distribution of data.

Answer 4

Dispersion

Question 5

[ ] is the measure of variability, It is the average squared deviation from the mean.

Answer 5

Variance

Question 6

[ ] is the measure how far the data deviates from the mean value. This is also know as the square root of variance.

Answer 6

Standard Deviation

Question 7

[ ] is used to determine how estimations for a group of observations are spread out from the mean.

Answer 7

Standard Deviation

Question 8

[ ] is the difference between the largest and the smallest value in the data.

Answer 8

Range

Question 9

[ ] is the difference between the observed value of a data point and the expected value.

Answer 9

Deviation

Question 10

[ ] is the average deviation of a data point from the mean, median, or mode of the data set.

Answer 10

Mean Deviation or Mean Absolute Deviation (MAD)

Question 11

[ ] can be abbreviated as MAD.

Answer 11

Mean Deviation

Question 12

[ ] describes the type of the graph.

Answer 12

Shape

Question 13

Making a decision about the probability of data is based on [ ].

Answer 13

its shape

Question 14

[ ] can be defined as a statistical measure that describes the lack of symmetry or asymmetry in the probability distribution of a dataset.

Answer 14

Skewness

Question 15

Add a range of cells.

Answer 15

SUM(range)

Question 16

Add cells from sum_range if the condition specified in criteria on range is met.

Answer 16

sumif(range, criteria, sum_range)

Question 17

Calculates the mean of a range of cells.

Answer 17

AVERAGE(range)

Question 18

Calculates the average_range if the condition in criteria on range is met.

Answer 18

AVERAGEIF(range, criteria, average_range)

Question 19

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.

Answer 19

MEDIAN(range)

Question 20

Returns the maximum value of a dataset.

Answer 20

MAX(range)

Question 21

Returns the minimum value of a dataset.

Answer 21

MIN(range)

Question 22

Returns the kth smallest or kth largest value in a specified data range.

Answer 22

SMALL(range, k) | LARGE(range, k)

Question 23

Counts the number of cells containing numbers in a range.

Answer 23

COUNT(range)

Question 24

Counts the number of non-blank cells within a range.

Answer 24

COUNTA(range)

Question 25

Counts the number of blank cells within a range.

Answer 25

COUNTBLANK(range)

Question 26

Counts the number of cells in range that are the same as value.

Answer 26

COUNTIF(range, value)

Question 27

Calculates the variance of a sample or an entire population; equivalent to the square of the standard deviation.

Answer 27

VAR(range) | VARP(range)

Question 28

Calculates the standard deviation of a sample or an entire population; the standard deviation is a measure how much values vary from the mean.

Answer 28

STDEV(range) | STDEVP(range)

Question 29

[ ] takes the average of a given set of data points over the past number of periods.

Answer 29

Moving Average

Question 30

Use [ ] to easily see the trends in the data.

Answer 30

moving average

Question 31

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.

Answer 31

Pareto Chart

Question 32

[ ] is a methodology for monitoring a process to identify special causes of variation and signing the need for corrective action.

Answer 32

Statistical Process Control

Question 33

What are the two types of Statistical Process Control?

Answer 33

• Common Cause Variation
• Special Cause Variation

Question 34

[ ] 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.

Answer 34

Common Cause Variation

Question 35

[ ] is when processes display larger amounts of variation and often stem from external sources and are considered not in control.

Answer 35

Special Cause Variation