Test Bank – Statistics for Managers Using
Microsoft Excel, 9th Edition by David
Levine | Complete Questions with
Answers || All Chapters Covered
In Excel, what is a collection of cells called? - CORRECT ANSWERS-range
If a student were to count the number and type of cars passing through an intersection
in a two hour period, she would be collecting which type of random variable? -
CORRECT ANSWERS-discrete
What is a mathematical operator used to perform a mathematical task called? -
CORRECT ANSWERS-formula
When surveying patient satisfaction and you are using the choices "poor" to "excellent"
you are using a - CORRECT ANSWERS-qualitative variable
Which of the following is an example of an Excel formula for taking the number 6 to the
power of 2? - CORRECT ANSWERS-=6^2
The ____________ branch of statistics consists of methods that enable the
administrator to develop generalizations, estimations, or predictions concerning the
phenomenon of managerial interest. - CORRECT ANSWERS-inferential
Which of the following is a discrete quantitative variable? - CORRECT ANSWERS-the
number of employees of an insurance company
Which of the following does NOT describe statistics? - CORRECT ANSWERS-A factor
that exhibits variability, volatility or assumes different values
The political affiliation (republican, democrat, independent) of an individual is an
example of which type of variable? - CORRECT ANSWERS-categorical
The universe or "totality of items or things" under consideration is called a - CORRECT
ANSWERS-population
In the formula for computing the mean, what does the letter "X" represent? - CORRECT
ANSWERS-individual scores
,Which measure of central tendency is most appropriate for samples where you DO NOT
have extreme values and your data is NOT categorical? - CORRECT ANSWERS-mean
Which of the following is most sensitive to extreme values? - CORRECT ANSWERS-
mean
What is the mode of the following set of scores? 10, 15, 12, 18, 19, 16, 12 - CORRECT
ANSWERS-12
What is the mean of the following set of scores (round up)? 10, 15, 12, 18, 19, 16, 12 -
CORRECT ANSWERS-15
Which of the following is another way of representing the 75th percentile? - CORRECT
ANSWERS-Q3
Which of the following is the correct function for calculating the midpoint of a set of
scores? - CORRECT ANSWERS-MEDIAN(A1:A10)
Which measure of central tendency can be used for both numerical and categorical
variables? - CORRECT ANSWERS-mode
Which of the following requires you to multiply a set of scores by the frequency of their
occurrence, adding the total of these products and then dividing by the total number of
scores? - CORRECT ANSWERS-Weighted mean
When using the AVERAGE function in Excel, which of the following are you calculating?
- CORRECT ANSWERS-Mean
Which of the following measures of central tendency is known as the midpoint for a set
of scores? - CORRECT ANSWERS-Median
What is the median of the following set of scores? 10, 15, 12, 18, 19, 16, 12 -
CORRECT ANSWERS-15
Variability is a measure of how much individual scores differ from the __________. -
CORRECT ANSWERS-mean
What is the standard deviation of the following set of scores? 10, 15, 12, 18, 19, 16, 12 -
CORRECT ANSWERS-3.36
When calculating the standard deviation, what must be done in order to obtain an
unbiased estimate of the population? - CORRECT ANSWERS-subtract 1 from n
In the formula for computing the variance, what does the letter "n" represent? -
CORRECT ANSWERS-sample size
,What is the range of the following set of scores? 10, 15, 12, 18, 19, 16, 12 - CORRECT
ANSWERS-9
What is obtained by squaring the standard deviation? - CORRECT ANSWERS-variance
Which of the following Excel functions will allow you to examine the symmetry of a set of
scores? - CORRECT ANSWERS-SKEW(A1:A20)
Excel uses "bins" to create a frequency distribution. The bin value is - CORRECT
ANSWERS-the maximum value (upper limit) for a given category
What type of graph displays class intervals along an x-axis? - CORRECT ANSWERS-
Histogram
When observations can only be included in one category (and not more than one), we
refer to the categories as - CORRECT ANSWERS-mutually exclusive
The point halfway between the boundaries of each class interval in a
grouped frequency distribution is called the __________. - CORRECT ANSWERS-class
mark
What do you call a continuous line that represents the frequency of scores within a
class interval? - CORRECT ANSWERS-Polygon
What is the specific term associated with how flat a distribution appears? - CORRECT
ANSWERS-platykurtic
According to the PowerPoint slides, you should group your data into no fewer than __
groups and no more than __ groups. - CORRECT ANSWERS-3, 10
The width of each bar in a histogram corresponds to the - CORRECT ANSWERS-
differences between the boundaries of the class.
If the correlation between variables is .70, what percent of the variance is shared
variance? - CORRECT ANSWERS-49%
What test would you want to use to test a nondirectional research hypothesis? -
CORRECT ANSWERS-Two-tailed test
Which of the following refers to the group to which you wish to generalize your results? -
CORRECT ANSWERS-Population
Which of the following symbols or statements would be used in a nondirectional
hypothesis? - CORRECT ANSWERS-not equal
, When data points group together in a cluster from the lower left-hand side of the xy axis
to the upper right-hand side, what is this? - CORRECT ANSWERS-Positive slope
Which of the following represent the Excel function to be used when computing
correlation coefficients? - CORRECT ANSWERS-CORREL(A1:A10, B1:B10)
In its standardized form, the normal distribution - CORRECT ANSWERS-has a mean of
0 and a standard deviation of 1
Which of the following characteristics is associated with the "tails" of the normal curve -
CORRECT ANSWERS-Asymptotic
Approximately what percent of scores fall between -1 and -2 standard deviations under
the normal curve? - CORRECT ANSWERS-14%
In a distribution with a mean of 100 and a standard deviation of 15, what is the
probability that a score will be 115 or higher? - CORRECT ANSWERS-16%
What is the z score for a raw score of 85 where the group mean is 75 and the standard
deviation is 5? - CORRECT ANSWERS-2
For some positive value of Z, the probability that a standard normal variable is between
0 and Z is 0.3770. The value of Z is? - CORRECT ANSWERS-1.16
A large urban hospital delivers 600 babies per month on average with a standard
deviation of 40. What is the percent probability that the hospital delivers less than 640
babies in a given month? - CORRECT ANSWERS-84%
Given that X is normally distributed variable with a mean of 50 and a standard deviation
of 2, find the probability that x is between 47 and 54. - CORRECT ANSWERS-0.9104
The central limit theorem states that if the _______ and _______ are large, the
theoretical sampling distribution may be approximated by the standard normal curve. -
CORRECT ANSWERS-sample size and degrees of freedom
We use the following descriptive statistics to determine the curve of a normal
distribution - CORRECT ANSWERS-mean and standard deviation
Which major assumption of the t-test deals with the amount of variability in each group?
- CORRECT ANSWERS-Variances are equal
In order to determine whether or not you will reject the null hypothesis, the test statistic
must be compared against the ___________. - CORRECT ANSWERS-Critical value
In the formula that computes a t value, what does Xbar1 represent? - CORRECT
ANSWERS-Mean for Group 1
Microsoft Excel, 9th Edition by David
Levine | Complete Questions with
Answers || All Chapters Covered
In Excel, what is a collection of cells called? - CORRECT ANSWERS-range
If a student were to count the number and type of cars passing through an intersection
in a two hour period, she would be collecting which type of random variable? -
CORRECT ANSWERS-discrete
What is a mathematical operator used to perform a mathematical task called? -
CORRECT ANSWERS-formula
When surveying patient satisfaction and you are using the choices "poor" to "excellent"
you are using a - CORRECT ANSWERS-qualitative variable
Which of the following is an example of an Excel formula for taking the number 6 to the
power of 2? - CORRECT ANSWERS-=6^2
The ____________ branch of statistics consists of methods that enable the
administrator to develop generalizations, estimations, or predictions concerning the
phenomenon of managerial interest. - CORRECT ANSWERS-inferential
Which of the following is a discrete quantitative variable? - CORRECT ANSWERS-the
number of employees of an insurance company
Which of the following does NOT describe statistics? - CORRECT ANSWERS-A factor
that exhibits variability, volatility or assumes different values
The political affiliation (republican, democrat, independent) of an individual is an
example of which type of variable? - CORRECT ANSWERS-categorical
The universe or "totality of items or things" under consideration is called a - CORRECT
ANSWERS-population
In the formula for computing the mean, what does the letter "X" represent? - CORRECT
ANSWERS-individual scores
,Which measure of central tendency is most appropriate for samples where you DO NOT
have extreme values and your data is NOT categorical? - CORRECT ANSWERS-mean
Which of the following is most sensitive to extreme values? - CORRECT ANSWERS-
mean
What is the mode of the following set of scores? 10, 15, 12, 18, 19, 16, 12 - CORRECT
ANSWERS-12
What is the mean of the following set of scores (round up)? 10, 15, 12, 18, 19, 16, 12 -
CORRECT ANSWERS-15
Which of the following is another way of representing the 75th percentile? - CORRECT
ANSWERS-Q3
Which of the following is the correct function for calculating the midpoint of a set of
scores? - CORRECT ANSWERS-MEDIAN(A1:A10)
Which measure of central tendency can be used for both numerical and categorical
variables? - CORRECT ANSWERS-mode
Which of the following requires you to multiply a set of scores by the frequency of their
occurrence, adding the total of these products and then dividing by the total number of
scores? - CORRECT ANSWERS-Weighted mean
When using the AVERAGE function in Excel, which of the following are you calculating?
- CORRECT ANSWERS-Mean
Which of the following measures of central tendency is known as the midpoint for a set
of scores? - CORRECT ANSWERS-Median
What is the median of the following set of scores? 10, 15, 12, 18, 19, 16, 12 -
CORRECT ANSWERS-15
Variability is a measure of how much individual scores differ from the __________. -
CORRECT ANSWERS-mean
What is the standard deviation of the following set of scores? 10, 15, 12, 18, 19, 16, 12 -
CORRECT ANSWERS-3.36
When calculating the standard deviation, what must be done in order to obtain an
unbiased estimate of the population? - CORRECT ANSWERS-subtract 1 from n
In the formula for computing the variance, what does the letter "n" represent? -
CORRECT ANSWERS-sample size
,What is the range of the following set of scores? 10, 15, 12, 18, 19, 16, 12 - CORRECT
ANSWERS-9
What is obtained by squaring the standard deviation? - CORRECT ANSWERS-variance
Which of the following Excel functions will allow you to examine the symmetry of a set of
scores? - CORRECT ANSWERS-SKEW(A1:A20)
Excel uses "bins" to create a frequency distribution. The bin value is - CORRECT
ANSWERS-the maximum value (upper limit) for a given category
What type of graph displays class intervals along an x-axis? - CORRECT ANSWERS-
Histogram
When observations can only be included in one category (and not more than one), we
refer to the categories as - CORRECT ANSWERS-mutually exclusive
The point halfway between the boundaries of each class interval in a
grouped frequency distribution is called the __________. - CORRECT ANSWERS-class
mark
What do you call a continuous line that represents the frequency of scores within a
class interval? - CORRECT ANSWERS-Polygon
What is the specific term associated with how flat a distribution appears? - CORRECT
ANSWERS-platykurtic
According to the PowerPoint slides, you should group your data into no fewer than __
groups and no more than __ groups. - CORRECT ANSWERS-3, 10
The width of each bar in a histogram corresponds to the - CORRECT ANSWERS-
differences between the boundaries of the class.
If the correlation between variables is .70, what percent of the variance is shared
variance? - CORRECT ANSWERS-49%
What test would you want to use to test a nondirectional research hypothesis? -
CORRECT ANSWERS-Two-tailed test
Which of the following refers to the group to which you wish to generalize your results? -
CORRECT ANSWERS-Population
Which of the following symbols or statements would be used in a nondirectional
hypothesis? - CORRECT ANSWERS-not equal
, When data points group together in a cluster from the lower left-hand side of the xy axis
to the upper right-hand side, what is this? - CORRECT ANSWERS-Positive slope
Which of the following represent the Excel function to be used when computing
correlation coefficients? - CORRECT ANSWERS-CORREL(A1:A10, B1:B10)
In its standardized form, the normal distribution - CORRECT ANSWERS-has a mean of
0 and a standard deviation of 1
Which of the following characteristics is associated with the "tails" of the normal curve -
CORRECT ANSWERS-Asymptotic
Approximately what percent of scores fall between -1 and -2 standard deviations under
the normal curve? - CORRECT ANSWERS-14%
In a distribution with a mean of 100 and a standard deviation of 15, what is the
probability that a score will be 115 or higher? - CORRECT ANSWERS-16%
What is the z score for a raw score of 85 where the group mean is 75 and the standard
deviation is 5? - CORRECT ANSWERS-2
For some positive value of Z, the probability that a standard normal variable is between
0 and Z is 0.3770. The value of Z is? - CORRECT ANSWERS-1.16
A large urban hospital delivers 600 babies per month on average with a standard
deviation of 40. What is the percent probability that the hospital delivers less than 640
babies in a given month? - CORRECT ANSWERS-84%
Given that X is normally distributed variable with a mean of 50 and a standard deviation
of 2, find the probability that x is between 47 and 54. - CORRECT ANSWERS-0.9104
The central limit theorem states that if the _______ and _______ are large, the
theoretical sampling distribution may be approximated by the standard normal curve. -
CORRECT ANSWERS-sample size and degrees of freedom
We use the following descriptive statistics to determine the curve of a normal
distribution - CORRECT ANSWERS-mean and standard deviation
Which major assumption of the t-test deals with the amount of variability in each group?
- CORRECT ANSWERS-Variances are equal
In order to determine whether or not you will reject the null hypothesis, the test statistic
must be compared against the ___________. - CORRECT ANSWERS-Critical value
In the formula that computes a t value, what does Xbar1 represent? - CORRECT
ANSWERS-Mean for Group 1
