A/B testing - ANS The process of testing two variations of the same web page to determine
which page is more successful at attracting user traffic and generating revenue
Access control - ANS Features such as password protection, user permissions, and encryption
that are used to protect a spreadsheet
Accuracy - ANS The degree to which data conforms to the actual entity being measured or
described
Action-oriented question - ANS A question whose answers lead to change
Administrative metadata - ANS Metadata that indicates the technical source of a digital asset
Agenda - ANS A list of scheduled appointments
Algorithm - ANS A process or set of rules followed for a specific task
Analytical skills - ANS Qualities and characteristics associated with using facts to solve
problems
Analytical thinking - ANS The process of identifying and defining a problem, then solving it by
using data in an organized, step-by-step manner
Attribute - ANS A characteristic or quality of data used to label a column in a table
Audio file - ANS Digitized audio storage usually in an MP3, AAC, or other compressed format
AVERAGE - ANS A spreadsheet function that returns an average of the values from a selected
range
Bad data source - ANS A data source that is not reliable, original, comprehensive, current, and
cited (ROCCC)
Bias - ANS A conscious or subconscious preference in favor of or against a person, group of
people, or thing
Big data - ANS Large, complex datasets typically involving long periods of time, which enable
data analysts to address far-reaching business problems
, Boolean data - ANS A data type with only two possible values, usually true or false
Borders - ANS Lines that can be added around two or more cells on a spreadsheet
Business task - ANS The question or problem data analysis answers for a business
CASE - ANS A SQL statement that returns records that meet conditions by including an if/then
statement in a query
CAST - ANS A SQL function that converts data from one datatype to another
Cell reference - ANS A cell or a range of cells in a worksheet typically used in formulas and
functions
Changelog - ANS A file containing a chronologically ordered list of modifications made to a
project
Clean data - ANS Data that is complete, correct, and relevant to the problem being solved
Cloud - ANS A place to keep data online, rather than a computer hard drive
COALESCE - ANS A SQL function that returns non-null values in a list
Compatibility - ANS How well two or more datasets are able to work together
Completeness - ANS The degree to which data contains all desired components or measures
CONCAT - ANS A SQL function that adds strings together to create new text strings that can be
used as unique keys
CONCATENATE - ANS A spreadsheet function that joins together two or more text strings
Conditional formatting - ANS A spreadsheet tool that changes how cells appear when values
meet specific conditions
Confidence interval - ANS A range of values that conveys how likely a statistical estimate
reflects the population
Confidence level - ANS The probability that a sample size accurately reflects the greater
population
Confirmation bias - ANS The tendency to search for or interpret information in a way that
confirms pre-existing beliefs
The benefits of buying summaries with Stuvia:
Guaranteed quality through customer reviews
Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.
Quick and easy check-out
You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.
Focus on what matters
Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!
Frequently asked questions
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.
Satisfaction guarantee: how does it work?
Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.
Who am I buying these notes from?
Stuvia is a marketplace, so you are not buying this document from us, but from seller phylliswambui. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $10.49. You're not tied to anything after your purchase.
