QUESTIONS WITH COMPLETE SOLUTIONS. VERIFIED EXAM
GRADED A+.
Data that indicate how much or how many are know
as a.
categorical
data b.
label data
c.
quantitative
data d.
category data Answer - c. quantitative data
Excel's Chart Tools can be used to construct a
Answers:
a.
bar chart
b.
pie chart
c.
histogra
m d.
All of these can be constructed using Excel's Chart Tools. Answer -
d. All of these can be constructed using Excel's Chart Tools.
Excel's can be used to construct a
crosstabulation. Answers:
a.
COUNTIF function
b.
PivotTable Report
c.
SUM function
d.
Chart Tools Answer - b.
PivotTable Report
,The sum of the percent frequencies for all classes will always equal
Answers:
a.
the number of items in the study
b.
100
c.
one
d.
the number of classes Answer - b.
100
The median of a sample will always equal the
Answers:
a.
mode
b.
mean
c.
50th
percentile d.
all of these answers are correct Answer - c.
50th percentile
Excel provides functions for computing the
Answers:
a.
mean
b.
median
c.
mode
d.
Excel provides functions for all of these. Answer - d.
Excel provides functions for all of these.
xcel's function can be used to compute the sample correlation
coefficient. Answers:
a.
MAX
b.
COVAR
c.
VAR
d.
,CORREL Answer - d.
CORREL
Excel's function can be used to compute the sample standard
deviation. Answers:
a.
MAX
b.
STDEV.S
c.
VAR
d.
MODE Answer - b. STDEV.S
Excel's function can be used to compute the sample
covariance. Answers:
a. COVARIANCE.S
b.
VAR
c.
CORREL
d.
MAX Answer - a.
COVARIANCE.S
The interquartile range is the difference between the
Answers:
a.
second and fourth
quartiles b.
second and third quartiles
c.
first and third quartiles
d.
first and second quartiles Answer -
c. first and third quartiles
The symbol σ is used to represent the
Answers:
a.
variance of the population
b.
standard deviation of the sample
c.
, standard deviation of the population
d.
None of the other answers are correct. Answer - c.
standard deviation of the population
The 75th percentile is also the
Answers:
a.
fourth
quartile b.
second
quartile c.
first
quartile d.
third quartile Answer - d.
third quartile
A numerical measure computed from a sample, such as sample mean, is known as a
Answers:
a.
population
parameter b.
population mean
c.
sample
statistic d.
sample parameter Answer - c.
sample statistic
Excel's function can be used to compute the median.
Answers:
a.
MODE
b.
AVERAGE
c.
MEDIAN
d.
MAX Answer - c.
MEDIAN
The most frequently occurring value of a data set is called the
Answers:
a.
range
b.