QMB final exam
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.
,histogram
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.
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.
,histogram
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.