ASSESS YOUR READINESS FOR THE ADVANCED ANALYTICS DATA CERTIFICATE
What is the key difference between qualitative and quantitative data?
Qualitative data measures qualities and characteristics; quantitative data measures numerical facts.
Which of the following statements accurately describes wide and long data? Select all that apply
Wide data subjects can have data in multiple columns. Long data subjects can have multiple rows that hold the values of subject attributes.
Structured data is likely to be found in which of the following formats? Select all that apply
Structured data is organized in a certain format such as rows and columns. It is likely to be found in a table or spreadsheet. To learn about structured data, enroll in the Google Data Analytics Certificate. Explanation: Structured data is organized in a certain format such as rows and columns. It is likely to be found in a table or spreadsheet. To learn about structured data, review course three of the Google Data Analytics Certificate.
Fill in the blank: A Boolean data type can have_____ possible value(s).
A Boolean data type can have two possible values.
What is the term for the individuals who have invested time and resources in a project and are interested in its outcome?
Stakeholders are individuals who have invested time and resources in a project and are interested in its outcome.
When collecting data for study, what are some reasons to consider sample size? Select all that apply.
Considering sample size ensures the data represents a diverse set of perspectives and helps avoid skewed results or inaccurate judgments. Explanation: Considering sample size ensures the data represents a diverse set of perspectives and helps avoid skewed results or inaccurate judgements.
The SMART methodology can be used to ask a question that promotes change. What type of Smart question leads to change?
A SMART question that promotes change is action-oriented.
Which of the following inquiries are leading questions? Select all that apply
Leading questions include: How satisfied were you with our customer representative? In what ways did our product meet your needs? And what do you enjoy most about our service? Leading questions direct the respondent to a particular answer, often because they suggest the answer within the question.
What are the key characteristics of a metric? Select all that apply
Metrics are quantifiable data types used for measurement and performance evaluation.
Which type of bias is the tendency to construe ambiguous situations in a positive or negative way?
Interpretation bias is the tendency to construe ambiguous situations in a positive or negative way.
Before completing a survey, an individual acknowledges reading information about how and why the data they provide will be used. What concept does this describes?
This concept is called consent. Consent is the aspect of data ethics that presumes an individual’s right to know how and why their personal data will be used before agreeing to provide it.
Which spreadsheet tool changes how cells appear when values meet a specific condition?
Conditional formatting is the spreadsheet tool that changes how cells appear when values meet a specific condition.
Fill in the blank: In a spreadsheet, the SPLIT function divides a text string around a ___, then puts a each fragment into a new, separate cell.
In a spreadsheet, the SPLIT function divides a text string around a delimiter, then puts each fragment into a new, separate cell.
Fill in blank: A Programming language is a system of words and symbols used to___ for computers.
A programming language is a system of words and symbols used to write instructions for computers.
What are the main benefits of using a programming language to work with data? Select all that apply
There are three main benefits of using a programming language to work with data: Easily reproduce and share work, save time, and clarify the steps of analysis.
In order for code to work properly, its necessary to follow the predetermined structure of the coding language. This includes all required words and symbols, as well as their proper placement. What is this structure called?
In order for code to work properly, it’s necessary to follow the syntax of the coding language. This includes all required words and symbols, as well as their proper placement.
What is the term for programming code that is freely available and may be modified and shared by the people who use it?
Open-source code is freely available and may be modified and shared by the people who use it.
Data professionals use programming languages to enable which of the following? Select all that apply.
Data professionals use programming languages to enable data transformation, cleaning, and visualization.
What type of data visualization should be used to demonstrate how often data values fall onto certain ranges?
To demonstrate how often data values fall into certain ranges, use a histogram.
Why is it more effective to label a data visualization instead of using a legend? Select all that apply.
It is more effective to label a data visualization instead of using a legend for several reasons: Labels can be placed near the data, they make the data visualization more accessible, and they allow for text explanations to be placed directly on the visualization.
Which of the following are appropriate uses for filters in data visualization tools? Select all that apply.
Filters can be used to highlight individual data points, limit the number of rows or columns in view, and provide data to different users based on their needs.
What is data science?
Data science is a field of study that uses raw data to create new ways of modeling and understanding the unknown.
A dashboard is designed to share insights about the housing market in a city. What type of data visualization would be most effective at demonstrating how the city’s annual home sales have risen over time?
To demonstrate how the city’s annual home sales have risen over time, a line chart would be most effective.
What type of visualizations enable the data in a presentation to automatically update and change over time?
Dynamic visualizations enable the data in a presentation to automatically update and change over time.
A data visualization reveals two variables in the data that rises and fall at the same time. When variables are related in this way, what is likely happening?
When two variables in a visualization rise and fall at the same time, this is an example of correlation. Correlation is the measure of the degree to which two variables change in relationship to each other.
Ready to test your recall?
What is the key difference between qualitative and quantitative data?
How confident are you in this answer?