bus 215 quiz answers || All correct.
When formatting a cell as an absolute reference or address, you correct answers Highlight the
reference in the formula and Press F4
Why would you use an absolute cell reference in a formula? correct answers Using an
absolute reference allows you to fill a formula down while still pointing to the absolute
reference
What is an easy way to transpose a long list of numbers? correct answers Copy & Paste
Special
You can... correct answers All of the above:
- change the row height
- hide a row
- insert and delete a row
Hardcoding a variable means correct answers Including the value of a variable in a formula
How are the Currency and Accounting number formats different? correct answers Both:
- The currency symbol is flush to the number in the currency format and flush left in the
accounting format
- A zero value is represented as a dash in the accounting format and a 0 in the currency
format
You can round the value of a cell by correct answers Using the Round formula
You can... correct answers Both:
- Insert a column
- hide a column
Conditional formatting is powerful because correct answers .
It enables rapid visual analysis of a data set
When formatting a cell as a fraction, what is the maximum number of digits that can be
displayed? correct answers Three
The best decision makers ... correct answers use the appropriate analysis of data they have
satisfied themselves are valid as a tool to inform their decision making.
Statistics ... correct answers Both:
- is the process of generating or collecting, organizing, analyzing, interpreting, and presenting
data.
- are calculations made from sample data.
The limitations of statistics include ... correct answers analyst bias.
To what did the following quote from the instructor's notes refer? "There are lies, damned
lies, and statistics." correct answers analyst ethics.
, Deconstructing a process into its component parts and determining how those parts relate to
each other and the overall purposes of the process is an example of ... correct answers
analyzing.
To what does the phrase "Garbage in, garbage out" refer? correct answers The effect the
quality of data has on decisions made informed by an analysis of those data
The value of a specific variable for a specific observation is correct answers a datum
The response scale [1. Spruce 2. Hemlock 3. Maple 4. Oak 5. Cedar] will yield ___________
data. correct answers nominal
The response scale [Lowest 1 2 3 4 5 Highest] will yield ____________ data. correct answers
interval
To calculate a percentage change between values, we need ______________ data. correct
answers ratio
Which data are not continuous or treated as continuous? correct answers Number of defects
in production runs
The closing values of the S&P 500 Index for each trading day in 2020 are what type of data?
correct answers Time Series
Random sampling is used to minimize/eliminate correct answers bias
Study a sample rather than a population when correct answers the act of testing/studying
destroys the item being tested/studied
Selecting every kth item from an ongoing production line is correct answers systematic
sampling
Response error can be caused by correct answers social desirability
By using random sampling methods, the analyst demonstrates a bias toward correct answers
random sampling error
Our preliminary analysis of the data we just collected is intended to provide us with insight
into ________ of the data set. correct answers the center, variability, and shape
A histogram is a _______. correct answers column chart of the bin frequencies
The wider the bins used in the frequency distribution, the ________ the data will appear in
the histogram. correct answers smoother
The cumulative frequencies are _______. correct answers a running total of the bin
frequencies as a percentage of the sample size
If the data are skewed left, _______. correct answers the mean is dragged to the left of the
peak within the distribution
When formatting a cell as an absolute reference or address, you correct answers Highlight the
reference in the formula and Press F4
Why would you use an absolute cell reference in a formula? correct answers Using an
absolute reference allows you to fill a formula down while still pointing to the absolute
reference
What is an easy way to transpose a long list of numbers? correct answers Copy & Paste
Special
You can... correct answers All of the above:
- change the row height
- hide a row
- insert and delete a row
Hardcoding a variable means correct answers Including the value of a variable in a formula
How are the Currency and Accounting number formats different? correct answers Both:
- The currency symbol is flush to the number in the currency format and flush left in the
accounting format
- A zero value is represented as a dash in the accounting format and a 0 in the currency
format
You can round the value of a cell by correct answers Using the Round formula
You can... correct answers Both:
- Insert a column
- hide a column
Conditional formatting is powerful because correct answers .
It enables rapid visual analysis of a data set
When formatting a cell as a fraction, what is the maximum number of digits that can be
displayed? correct answers Three
The best decision makers ... correct answers use the appropriate analysis of data they have
satisfied themselves are valid as a tool to inform their decision making.
Statistics ... correct answers Both:
- is the process of generating or collecting, organizing, analyzing, interpreting, and presenting
data.
- are calculations made from sample data.
The limitations of statistics include ... correct answers analyst bias.
To what did the following quote from the instructor's notes refer? "There are lies, damned
lies, and statistics." correct answers analyst ethics.
, Deconstructing a process into its component parts and determining how those parts relate to
each other and the overall purposes of the process is an example of ... correct answers
analyzing.
To what does the phrase "Garbage in, garbage out" refer? correct answers The effect the
quality of data has on decisions made informed by an analysis of those data
The value of a specific variable for a specific observation is correct answers a datum
The response scale [1. Spruce 2. Hemlock 3. Maple 4. Oak 5. Cedar] will yield ___________
data. correct answers nominal
The response scale [Lowest 1 2 3 4 5 Highest] will yield ____________ data. correct answers
interval
To calculate a percentage change between values, we need ______________ data. correct
answers ratio
Which data are not continuous or treated as continuous? correct answers Number of defects
in production runs
The closing values of the S&P 500 Index for each trading day in 2020 are what type of data?
correct answers Time Series
Random sampling is used to minimize/eliminate correct answers bias
Study a sample rather than a population when correct answers the act of testing/studying
destroys the item being tested/studied
Selecting every kth item from an ongoing production line is correct answers systematic
sampling
Response error can be caused by correct answers social desirability
By using random sampling methods, the analyst demonstrates a bias toward correct answers
random sampling error
Our preliminary analysis of the data we just collected is intended to provide us with insight
into ________ of the data set. correct answers the center, variability, and shape
A histogram is a _______. correct answers column chart of the bin frequencies
The wider the bins used in the frequency distribution, the ________ the data will appear in
the histogram. correct answers smoother
The cumulative frequencies are _______. correct answers a running total of the bin
frequencies as a percentage of the sample size
If the data are skewed left, _______. correct answers the mean is dragged to the left of the
peak within the distribution
