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...
when formatting a cell as an absolute reference or
Escuela, estudio y materia
Bus 215
Bus 215
Vendedor
Seguir
ProPerfomer
Comentarios recibidos
Vista previa del contenido
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
Los beneficios de comprar resúmenes en Stuvia estan en línea:
Garantiza la calidad de los comentarios
Compradores de Stuvia evaluaron más de 700.000 resúmenes. Así estas seguro que compras los mejores documentos!
Compra fácil y rápido
Puedes pagar rápidamente y en una vez con iDeal, tarjeta de crédito o con tu crédito de Stuvia. Sin tener que hacerte miembro.
Enfócate en lo más importante
Tus compañeros escriben los resúmenes. Por eso tienes la seguridad que tienes un resumen actual y confiable.
Así llegas a la conclusión rapidamente!
Preguntas frecuentes
What do I get when I buy this document?
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
100% de satisfacción garantizada: ¿Cómo funciona?
Nuestra garantía de satisfacción le asegura que siempre encontrará un documento de estudio a tu medida. Tu rellenas un formulario y nuestro equipo de atención al cliente se encarga del resto.
Who am I buying this summary from?
Stuvia is a marketplace, so you are not buying this document from us, but from seller ProPerfomer. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy this summary for $11.99. You're not tied to anything after your purchase.