Answers Verified 100% Correct
There are ten sections of a math course at a university. One section is
randomly chosen for a survey about calculator preferences. The
group of students in this section is a ____. - ANSWER -sample
Variables of type Ratio are the most complete - ANSWER -true
Nominal data represent categories or labels, such as male and female.
- ANSWER -true
Ordinal scale is an ordering of the nominal variables. - ANSWER -true
How many areas of the MS Excel interface were discussed in the
video? - ANSWER -5
Where does one change the format of a cell, such as adding color or
changing font style? - ANSWER -ribbon and worksheet area
One of the things you can do with the Status Bar is: - ANSWER
rename the tab
Simply stated, Histograms are a plot of data bins and the number of
data points in each of them. - ANSWER -true
In this histogram, the height of a column is determined by the value of
a student's test score - ANSWER -false
,A pie chart is _______. - ANSWER -all of these options:
a graph, an illustration of data points, a representation of numerical
proportions
In the video example, what brand has the smallest sales, and how can
we tell from the pie chart? - ANSWER -Lamborghini has the smallest
sales, because its proportion of the pie is smallest.
A pie chart is most useful to illustrate ______________. - ANSWER
proportions of the whole
A bar graph is ______________. - ANSWER -all of these options: a
series of contiguous columns of varying heights to denote variations
in data, an illustration of data points, a pictorial representation of
statistical variations
In the example shown, which brand of vehicles has the highest sales,
and how can we tell? - ANSWER -Audi, because the bar representing
its sales is longest.
If the brand that had most sales was Lamborghini, then
______________. - ANSWER -the bar (or column) corresponding to
Lamborghini would be the largest
A bar graph can have vertical or horizontal columns. - ANSWER -true
You can insert formulas by ______________ - ANSWER -All of the
options:
, Clicking on "Formulas" and then "Insert Function"
Typing "=" and a function name
If the "formula bar" is enabled in the view settings, typing directly in it
Additional functions and their usage can be found in ___________ -
ANSWER -All of the options:
"Lookup & Reference" tab within Formulas
Help for Microsoft Excel
To compute the standard deviation of a data sample ______________ -
ANSWER -Use STDEV.S
You can choose which numbers to add/subtract/multiply/divide by
selecting the cell. - ANSWER -true
In Excel, in a formula, the asterisk character (*) is used for ________. -
ANSWER -multiplying two numbers
In Excel, in a formula, the character for computing the power of a
number is ____. - ANSWER -^
When is scientific notation useful? - ANSWER -When working with
data sets that have a wide range of values
In scientific notation, the number 12,340,000,000 is represented in