google questions

What is the main difference between a formula and a function?

A formula is a set of instructions used to perform a specified calculation; a function is a preset command that automatically performs a specified process.

Function:

A preset command that automatically performs a specified process or task using the data in a spreadsheet

Formula:

A set of instructions used to perform a calculation using the data in a spreadsheet

6 phases include Ask, Prepare, Process, Analyze, Share, and

Act

A data analyst shares insights from their analysis during a formal presentation to stakeholders. In a slideshow, they make a data-driven recommendation for how to solve a business problem. What phase of the data analysis process would come next?

Act

A data analyst uses a spreadsheet function to aggregate data. Then, they add a pivot table to show totals from least to greatest. This would happen during which stage of the data life cycle?

Analyze

In the data life cycle, which phase involves using data to solve problems, make good decisions, and support business goals?

Analyze

During which phase of data analysis would a data analyst use spreadsheets or query languages to transform data in order to draw conclusions?

Analyze Phase

A data analyst is analyzing fruit and vegetable sales at a grocery store. They're able to find data on everything except red onions. What's the best course of action?

Ask a teammate for help finding data on red onions.

In a data table, a row is called an observation. An observation includes all of the _____ for what is contained in the row.

Attributes

Manage:

Care for and maintain the data. This includes determining how and where it is stored and the tools used to do so.

Capture:

Collect or bring in data from a variety of different sources.

The analytical skill that involves how you organize information

Data design

What is the term for the graphical representation of data?

Data visualization

What is the process of using facts to guide business strategy?

Data-driven decision-making

Plan

Decide what kind of data is needed, how it will be managed, and who will be responsible for it.

Plan Capture Manage Analyze Archive and _____ are all phases of Data Life Cycles

Destroy

A large hotel chain sees about 500 customers per week. A data analyst working there is gathering data through customer satisfaction surveys. They are anxious to begin analysis, so they start analyzing the data as soon as they receive 50 survey responses. This is an example of what? Select all that apply.

Failing to include diverse perspectives in data collection and Failing to have a large enough sample size

Data analysts ensure their analysis is fair for what reason?

Fairness helps them avoid biased conclusions

Data analysts ensure their analysis is fair for what reason?

Fairness helps them avoid biased conclusions.

A company takes insights provided by its data analytics team, validates them, and finalizes a strategy. They then implement a plan to solve the original business problem. This describes the share step of the data analysis process.

False

What steps do data analysts take to ensure fairness when collecting data? Select all that apply.

Include data self-reported by individuals, Understand the social context, and Use an inclusive sample population

Archive:

Keep relevant data stored for long-term and future reference.

Avens Engineering needs more engineers, so they purchase ads on a job search website. The website's data reveals that 86% of engineers are men. Based on that number, an analyst decides that men are more likely to be successful applicants, so they target the ads to male job seekers. What should the analyst have done instead?

Make sure their recommendation doesn't create or reinforce bias

On a railway line, peak ridership occurs between 7:00 AM and 5:00 PM. The fairness of a passenger survey could be improved by over-sampling data from which group?

Nighttime riders

A ______ chart shows how a whole is broken down into parts and is an effective visualization for a class broken down by age.

Pie

In which stage of the data life cycle does a business decide what kind of data it needs, how the data will be managed, and who will be responsible for it?

Plan

Destroy

Remove data from storage and delete any shared copies of the data.

In which data analysis phase would a data analyst use visuals such as charts or graphs to simplify complex data for better understanding?

Share

Understanding context

The analytical skill that has to do with how you group things into categories

Data strategy

The analytical skill that involves managing the processes and tools used in data analysis

In a spreadsheet, what is text wrapping used for?

To allow all of the text to fit inside a cell

In a table, an attribute is a characteristic or quality of data used for what purpose?

To label a column

A database is a collection of data stored in a computer system.

True

Structured query language (SQL) enables data analysts to communicate with a database.

True

The data life cycle deals with the stages that data goes through; data analysis involves following a process to analyze data

True

Analyze:

Use the data to solve problems, make decisions, and support business goals.

The destroy stage of the data life cycle might involve which of the following actions? Select all that apply.

Using data-erasure software and Shredding paper files

When would a pie chart be an effective visualization?

When showing a class broken down by age

Curiosity, understanding context, and having a technical mindset are all examples of _____ used in data-driven decision-making.

analytical skills

The qualities and characteristics associated with solving problems using facts

analytical skills

What practice involves identifying, defining, and solving a problem by using data in an organized, step-by-step manner?

analytical thinking

After opening the ice cream shop on her farm, the same dairy farmer then surveys the local community about people's favorite flavors. She uses the data she collected to determine that the top five flavors are strawberry, vanilla, chocolate, mint chip, and peanut butter. She feels confident in her decision to sell these flavors. This is part of which phase of the data life cycle?

analyze

What is a technical mindset

breaking processes down into smaller steps and working with them in an orderly, logical way

A problem and a question, both, are the foundation of _____ tasks.

business

In the data life cycle, which phase involves gathering data from various sources and bringing it into the organization?

capture

A _____ chart shows categories and is an effective visualization for the ages of males versus females.

column

Fill in the blank: Being able to identify a relationship between two or more pieces of data describes _____.

correlation

What practice involves identifying, defining, and solving a problem by using data in an organized, step-by-step manner?

correlation

Seeking out new challenges and experiences in order to learn is an example of which analytical skill?

curiousity

A company is receiving negative comments on social media about their products. To solve this problem, a data analyst uses each of their five analytical skills: curiosity, understanding context, having a technical mindset, data design, and data strategy. This makes it possible for the analyst to use facts to guide business strategy and figure out how to improve customer satisfaction. What is this an example of?

data driven decision making

What is the process of using facts to guide business strategy?

data driven decision making

The ____ provides a generic or common framework for how data is managed

data life cycle

In data analysis, which analytical skill involves the management of people, processes, and tools?

data strategy

Which analytical skill involves managing the people, processes, and tools used in data analysis?

data strategy

A query language is a computer programming language that enables data analysts to retrieve and manipulate data from a ______.

database

The data analysis process phases are ask, prepare, process, analyze, share, and act. What do data analysts do during the ask phase?

define the problem to be solved

A data analyst finishes using a dataset, so they erase or shred the files in order to protect private information. This is called archiving.

false

A magazine wants to understand why its subscribers have been increasing. A data analyst could help answer that question with a report that predicts the result of a half-price sale on future subscription rates.

false

A real estate company needs to hire a human resources assistant. The owner asks a data analyst to help them decide where to advertise the job opening. The analyst learns that the majority of human resources professionals are women, validates this finding with research, and targets ads to a women's community college. This is fair because the analyst conducted research to make sure the information about gender breakdown of human resources professionals was accurate

false

Data analysts answer questions and solve problems. These are called business tasks

false

A data analyst uses a SQL query to retrieve information from a database. They add a WHERE statement to _____ the data based on certain conditions.

filter

Fill in the blank: A set of instructions that performs a specific calculation using spreadsheet data is called _____.

formula

An airport wants to make its luggage-handling process faster and simpler for travelers. A data analyst examines and evaluates how the process works currently in order to achieve the goal of a more efficient process. What methodology do they use?

gap analysis

Which of the following are examples of data visualizations?

graph, chart, maps

A data visualization is the _____ representation of information.

graphical

In data analytics, fairness means ensuring that your analysis does not create or reinforce bias. This requires using processes and systems that are fair and _____.

inclusive

What does IDE stand for?

integrated developer environment

A dairy farmer decides to open an ice cream shop on her farm. After surveying the local community about people's favorite flavors, she takes the data they provided and stores it in a secure hard drive so it can be maintained safely on her computer. This is part of which phase of the data life cycle?

manage

What are the key benefits of data visualizations? Select all that apply.

patterns, relationships, and understand complex data quicker

Cognitive biases are systematic errors in thinking, usually inherited by cultural and _____ experiences, that lead to distortions of perceptions when making decisions

personal

Fill in the blank: During the _____ phase of the data life cycle, a business decides what kind of data it needs, how it will be managed, who will be responsible for it, and the optimal outcomes.

planning

A _____ is an obstacle or complication to be solved, whereas a question is designed to discover information.

problem

A problem is an obstacle to be solved, an issue is a topic to investigate, and a _____ is designed to discover information

question

A query is used to _____ information from a database. Select all that apply.

request, retrieve, and

Based on what you have learned in this course, spreadsheets are digital worksheets that enable data analysts to do which of the following tasks? Select all that apply.

sort and filter, organize data in rows and columns, store

what are great for creating simple visualizations like bar graphs and pie charts

spreadsheets

In data analytics, SQL is an acronym meaning _____ query language.

structured

A data analyst works for an appliance manufacturer. Last year, the company's profits were down. Lower profits can be a result of fewer people buying appliances, higher costs to make appliances, or a combination of both. The analyst recognizes that those are big issues to solve, so they break down the problems into smaller pieces to analyze them in an orderly way. Which analytical skill are they using?

technical mindset

A data analyst is analyzing fruit and vegetable sales at a grocery store. They're able to find data on everything except red onions. If they exclude red onions from the analysis, this would be an example of creating or reinforcing bias

true

A doctor's office has discovered that patients are waiting 20 minutes longer for their appointments than in past years. A data analyst could help solve this problem by analyzing how many doctors and nurses are on staff at a given time compared to the number of patients with appointments.

true

Collaborating with a social scientist to provide insights into human bias and social contexts is an effective way to avoid bias in your data

true

Data analysts answer questions and solve problems. These are called business tasks

true

Data analysts ask, "Why?" five times in order to get to the root cause of a problem.

true

During the process phase of data analysis, a data analyst cleans data to ensure it's complete and correct.

true

Gap analysis is used to examine and evaluate how a process currently works with the goal of getting to where you want to be in the future

true

Surveying customers about their preferences and using that information to inform business strategy is an example of data-driven decision-making.

true

The columns in a spreadsheet are ordered by letter, and the rows are ordered by number.

true

Adding descriptive headers to columns of data in a spreadsheet is an example of which analytical skill?

understanding context