DATA ANALYSIS
Descriptive Measures of
Association, Probability,
and Statistical
Distributors Latest
Assessment
MODULE 2 Q & A
2024
,1. What is the formula for calculating the correlation
coefficient between two variables in Excel?
a) CORREL(array1, array2)
b) COVAR(array1, array2)
c) COEFF(array1, array2)
d) CORR(array1, array2)
Answer: A. The CORREL function returns the Pearson
correlation coefficient of two arrays of numbers.
2. What is the difference between a discrete and a
continuous probability distribution?
a) A discrete distribution has a finite number of possible
outcomes, while a continuous distribution has an infinite
number of possible outcomes.
b) A discrete distribution has an infinite number of possible
outcomes, while a continuous distribution has a finite
number of possible outcomes.
c) A discrete distribution has equal probabilities for all
outcomes, while a continuous distribution has varying
probabilities for different outcomes.
d) A discrete distribution has varying probabilities for
different outcomes, while a continuous distribution has
equal probabilities for all outcomes.
Answer: A. A discrete distribution is one that can take on
only a finite or countable number of values, such as the
number of heads in a coin toss. A continuous distribution is
one that can take on any value in an interval, such as the
height of a person.
, 3. What is the meaning of the standard deviation of a data
set?
a) It measures the average distance of the data values from
the mean.
b) It measures the average distance of the data values from
the median.
c) It measures the average distance of the data values from
the mode.
d) It measures the average distance of the data values from
the range.
Answer: A. The standard deviation is a measure of how
spread out the data values are around the mean. It is
calculated by taking the square root of the variance, which
is the average of the squared deviations from the mean.
4. What is the difference between a population and a
sample in statistics?
a) A population is a subset of a sample, while a sample is a
subset of a population.
b) A population is a subset of a sample, while a sample is
the entire group of interest.
c) A population is the entire group of interest, while a
sample is a subset of a population.
d) A population is the entire group of interest, while a
sample is a subset of a sample.
Answer: C. A population is the set of all elements that are
relevant to a particular study or question, such as all
customers of a company. A sample is a subset of the
population that is selected for analysis, such as 100
randomly chosen customers.
Descriptive Measures of
Association, Probability,
and Statistical
Distributors Latest
Assessment
MODULE 2 Q & A
2024
,1. What is the formula for calculating the correlation
coefficient between two variables in Excel?
a) CORREL(array1, array2)
b) COVAR(array1, array2)
c) COEFF(array1, array2)
d) CORR(array1, array2)
Answer: A. The CORREL function returns the Pearson
correlation coefficient of two arrays of numbers.
2. What is the difference between a discrete and a
continuous probability distribution?
a) A discrete distribution has a finite number of possible
outcomes, while a continuous distribution has an infinite
number of possible outcomes.
b) A discrete distribution has an infinite number of possible
outcomes, while a continuous distribution has a finite
number of possible outcomes.
c) A discrete distribution has equal probabilities for all
outcomes, while a continuous distribution has varying
probabilities for different outcomes.
d) A discrete distribution has varying probabilities for
different outcomes, while a continuous distribution has
equal probabilities for all outcomes.
Answer: A. A discrete distribution is one that can take on
only a finite or countable number of values, such as the
number of heads in a coin toss. A continuous distribution is
one that can take on any value in an interval, such as the
height of a person.
, 3. What is the meaning of the standard deviation of a data
set?
a) It measures the average distance of the data values from
the mean.
b) It measures the average distance of the data values from
the median.
c) It measures the average distance of the data values from
the mode.
d) It measures the average distance of the data values from
the range.
Answer: A. The standard deviation is a measure of how
spread out the data values are around the mean. It is
calculated by taking the square root of the variance, which
is the average of the squared deviations from the mean.
4. What is the difference between a population and a
sample in statistics?
a) A population is a subset of a sample, while a sample is a
subset of a population.
b) A population is a subset of a sample, while a sample is
the entire group of interest.
c) A population is the entire group of interest, while a
sample is a subset of a population.
d) A population is the entire group of interest, while a
sample is a subset of a sample.
Answer: C. A population is the set of all elements that are
relevant to a particular study or question, such as all
customers of a company. A sample is a subset of the
population that is selected for analysis, such as 100
randomly chosen customers.
