MODERN BUSINESS STATISTICS WITH
MICROSOFT EXCEL UPDATED ACTUAL
QUESTIONS AND CORRECT ANSWERS
COMPLETE STUDY GUIDE FULL SOLUTION
●● Arithmetic Mean
Answer: The primary measure of central location, calculated by adding
up all observations and dividing by the number of observations.
●● Population Mean
Answer: Denoted as N observations in the population; a parameter that
describes a population.
●● Sample Mean
Answer: Denoted as n observations in the sample; a statistic that
describes a sample.
●● Median
Answer: The middle value of a variable that divides the data in half,
especially useful when outliers are present.
●● Mode
Answer: The observation that occurs most frequently in a dataset.
,●● Unimodal
Answer: A dataset with one mode.
●● Bimodal
Answer: A dataset with two modes.
●● Outliers
Answer: Extreme values that can mislead the calculation of the mean.
●● Central Value
Answer: A typical or central value that describes the data.
●● Typical Return
Answer: The average return that can be expected from an investment.
●● Investment Risk
Answer: The potential for loss or the variability of returns from an
investment.
●● Percentile
Answer: A measure indicating the value below which a given percentage
of observations fall.
, ●● Boxplot
Answer: A graphical representation of data that shows the distribution
through quartiles.
●● Chebyshev's Theorem
Answer: A statistical theorem that provides a lower bound on the
proportion of observations within a certain number of standard
deviations from the mean.
●● Empirical Rule
Answer: A statistical rule stating that for a normal distribution,
approximately 68% of the data falls within one standard deviation of the
mean.
●● Z-scores
Answer: A measure of how many standard deviations an element is from
the mean.
●● Geometric Mean Return
Answer: The average rate of return over a period, calculated by
multiplying the returns and taking the nth root.
●● Compound Growth Rate
MICROSOFT EXCEL UPDATED ACTUAL
QUESTIONS AND CORRECT ANSWERS
COMPLETE STUDY GUIDE FULL SOLUTION
●● Arithmetic Mean
Answer: The primary measure of central location, calculated by adding
up all observations and dividing by the number of observations.
●● Population Mean
Answer: Denoted as N observations in the population; a parameter that
describes a population.
●● Sample Mean
Answer: Denoted as n observations in the sample; a statistic that
describes a sample.
●● Median
Answer: The middle value of a variable that divides the data in half,
especially useful when outliers are present.
●● Mode
Answer: The observation that occurs most frequently in a dataset.
,●● Unimodal
Answer: A dataset with one mode.
●● Bimodal
Answer: A dataset with two modes.
●● Outliers
Answer: Extreme values that can mislead the calculation of the mean.
●● Central Value
Answer: A typical or central value that describes the data.
●● Typical Return
Answer: The average return that can be expected from an investment.
●● Investment Risk
Answer: The potential for loss or the variability of returns from an
investment.
●● Percentile
Answer: A measure indicating the value below which a given percentage
of observations fall.
, ●● Boxplot
Answer: A graphical representation of data that shows the distribution
through quartiles.
●● Chebyshev's Theorem
Answer: A statistical theorem that provides a lower bound on the
proportion of observations within a certain number of standard
deviations from the mean.
●● Empirical Rule
Answer: A statistical rule stating that for a normal distribution,
approximately 68% of the data falls within one standard deviation of the
mean.
●● Z-scores
Answer: A measure of how many standard deviations an element is from
the mean.
●● Geometric Mean Return
Answer: The average rate of return over a period, calculated by
multiplying the returns and taking the nth root.
●● Compound Growth Rate
