ASSESS YOUR READINESS FOR THE ADVANCED ANALYTICS DATA CERTIFICATE

Qualitative data measures qualities and characteristics; quantitative data measures numerical facts.

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 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.

A Boolean data type can have two possible values.

Stakeholders are individuals who have invested time and resources in a project and are interested in its outcome.

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.

A SMART question that promotes change is action-oriented.

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.

Metrics are quantifiable data types used for measurement and performance evaluation.

Interpretation bias is the tendency to construe ambiguous situations in a positive or negative way.

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.

Conditional formatting is the spreadsheet tool that changes how cells appear when values meet a specific condition.

In a spreadsheet, the SPLIT function divides a text string around a delimiter, then puts each fragment into a new, separate cell.

A programming language is a system of words and symbols used to write instructions for computers.

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, it’s necessary to follow the syntax of the coding language. This includes all required words and symbols, as well as their proper placement.

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 data transformation, cleaning, and visualization.

To demonstrate how often data values fall into certain ranges, use a histogram.

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.

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.

Data science is a field of study that uses raw data to create new ways of modeling and understanding the unknown.

To demonstrate how the city’s annual home sales have risen over time, a line chart would be most effective.

Dynamic visualizations enable the data in a presentation to automatically update and change over time.

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.