Foundations: Data, Data, Everywhere Quiz Answers

Get All Weeks Foundations: Data, Data, Everywhere Quiz Answers

Foundations: Data, Data, Everywhere Week 1 Quiz Answers

Practice Quiz-1 Answers

L3 Understanding the data ecosystem:

Q1. Which of the following statements best defines data?

Data is an assortment of questions.
Data is a business process.
Data is a collection of facts.
Data is the use of calculations and statistics.

Q2. Fill in the blank: In data analytics, the data ecosystem refers to the various elements that interact with one another to produce, manage, store, _____, analyze, and share data.

organize
ingest
merge
locate

Q3. Which of the following terms refers to the collection, transformation, and organization of data in order to draw conclusions, make predictions, and drive informed decision-making?

Data life cycle
Data insight
Data elements
Data analysis

Q4. An airline collects, observes, and analyzes its customers’ online behaviors. Then, it uses the insights gained to choose what new products and services to offer. What business process does this describe?

Analytical thinking
Performance measurement
Collaboration with stakeholders
Data-driven decision-making

Foundations: Data, Data, Everywhere Weekly Challenge 1 Answers

Q1. Which of the following options describes data analysis?

Creating new ways of modeling and understanding the unknown by using raw data
The collection, transformation, and organization of data in order to draw conclusions, make predictions, and drive informed decision-making
The various elements that interact with one another in order to provide, manage, store, organize, analyze, and share data
Using facts to guide business strategy

Q2. A business collects and analyzes information about its employees in order to gain insights that unlock potential and create a more productive workplace. What practice does this describe?

Workforce observation
Employee retention
Team collaboration
People analytics

Q3. In data analytics, a model is a group of elements that interact with one another.

True
False

Q4. Fill in the blank: The term _____ is defined as an intuitive understanding of something with little or no explanation.

awareness
personal opinion
rational thought
gut instinct

Q5. A company defines a problem it wants to solve. Then, a data analyst gathers relevant data, analyzes it, and uses it to draw conclusions. The analyst shares their analysis with subject-matter experts, who validate the findings. Finally, a plan is put into action. What does this scenario describe?

Identification of trends
Data-driven decision-making
Customer service
Data science

Q6. Fill in the blank: The people very familiar with a business problem are called _____. They are an important part of data-driven decision-making.

subject-matter experts
stakeholders
competitors
customers

Q7. A data analyst finishes analyzing data for a marketing project. The results are clear, so they present findings to the client and ask for conclusions and recommendations. What should they have done first?

Archived the datasets in order to keep them secure
Created a model based on the results of the analysis
Shared the results with subject-matter experts from the marketing team for their input
Surveyed customers about results, conclusions, and recommendations

Q8. You have recently subscribed to an online data analytics magazine. You really enjoyed an article and want to share it in the discussion forum. Which of the following would be appropriate in a post? Select all that apply.

Including an advertisement for how to subscribe to the data analytics magazine
Checking your post for typos or grammatical errors
Giving credit to the original author
Including your own thoughts about the article

Foundations: Data, Data, Everywhere Week 2 Quiz Answers

Practice Quiz-1 Answers

L2 Embracing data analyst skills:

Q1. Identify the pattern from left to right in the set of blocks below and try to predict which block should replace the block with the question mark.

Answer:

Q2. Here’s a more complex pattern. Identify the pattern from left to right in the images below and try to predict which image should come next. A series of different boxes containing shapes and patterns with the last box containing a question mark

Based on the images above, which option comes next in the pattern?

Answer:

Q3. Now, find a pattern in a different format. Select the next number in the sequence:

Fill in the blank: 9, 13, 17, 21, 25, 29, _____

Q4. The following numbers are in a sequence from left to right. Determine the pattern and decide which number should come next:

Fill in the blank: 4, 9, 16, 25, 36, 49, _____

Q5. The following question is about recognizing and matching patterns in shapes that are the same, but viewed from different angles.

Two shapes are similar when one can become the other after a rotation clockwise ⟳ or counterclockwise ↺, or a reflection horizontally ↔ and/or vertically ↕. Top right, bottom left is to top left, bottom right

Your task is to choose the figure that completes the statement. Pay attention to the pattern by which the first and second shapes are related, and then figure out which choice matches shape 3. Fill in the blank: Top: left & center, middle: right IS TO top: right & center, middle: left AS top: right, middle: center, bottom: left IS TO

Select the image below that completes the statement.

Answer:

Q6. The following question is about recognizing and matching patterns in shapes that are the same, but viewed from different angles. Two shapes are similar when one can become the other after a rotation clockwise ⟳ or counterclockwise ↺, or a reflection horizontally ↔ and/or vertically ↕.

Your task is to choose the figure that completes the statement. Fill in the blank:

Which image completes it?

Answer:

Q7. The following series of codes are in a sequence from left to right. There is a repeating pattern that you will notice. Determine the pattern and decide which code should come next.

Fill in the blank: A1, B3, C5, D7, E9, F11, G13, _____

J15
H16
D17
H15

Q8. The following series of codes are in a sequence from left to right. There is a repeating pattern that you will notice. Determine the pattern and decide which sequence of letters should come next.

Fill in the blank: A, AA, AAA, B, BA, BAA, BAAA, BB, BBA, BBAA, BBAAA, BBB, ________

BBBA
BBBB
BBAA
BBAAA

Q9. Now, identify patterns in a word problem using a data visualization. There are 12 chocolates in a box: eight have caramel filling, six have coconut filling, and two have both caramel and coconut filling. Choose the best image that describes this box of chocolates.

Answer:

Q10. There are 10 children in a class and they have all brought sandwiches for lunch: five children have sandwiches with peanut butter, six children have sandwiches with jelly, and three children have sandwiches with both peanut butter and jelly.

Find out how many children have sandwiches with neither peanut butter nor jelly and choose the image that describes the situation best.

Answer:

Practice Quiz-2 Answers

L3 Thinking about analytical thinking:

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

Context
Data design
Analytical thinking
Visualization

Q2. Data visualization is the graphical representation of information, including which of the following? Select all that apply.

Icons
Maps
Charts
Graphs

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

Practice Quiz-3 Answers

L4 Thinking about outcomes:

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

analytical skills
business strategies
thought processes
data models

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

True
False

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

Data control
Data strategy
Data analytics
Data design

Foundations: Data, Data, Everywhere Weekly Challenge 2 Answers

Q1. Fill in the blank: Analytical skills are defined as _____.

qualities and characteristics associated with solving problems using facts
an analyst’s intuition, inner voice, or gut instinct
the management of people, processes, and tools
the ability to break things down into smaller steps

Q2. A junior data analyst is seeking out new experiences in order to gain knowledge. They watch videos and read articles about data analytics. They ask experts questions. Which analytical skill are they using?

Understanding context
Curiosity
Data strategy
Having a technical mindset

Q3. Identifying the motivation behind data collection and gathering additional information are examples of which analytical skill?

Data design
Understanding context
Data strategy
A technical mindset

Q4. Having a technical mindset is an analytical skill involving what?

Managing people, processes, and tools
Breaking things down into smaller steps or pieces
Understanding the condition in which something exists or happens
Balancing roles and responsibilities

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

Curiosity
Understanding context
Data strategy
Data design

Q6. Correlation is the aspect of analytical thinking that involves figuring out the specifics that help you execute a plan.

True
False

Q7. Fill in the blank: Detail-oriented thinking is about figuring out all of the _____ that will help you execute a plan.

specifics
datasets
instructions
information

Q8. The five whys is a technique that involves asking, “Why?” five times in order to achieve what goal?

Identify the root cause of a problem
Visualize how a process should look in the future
Use facts to guide business strategy
Put a plan into action

Q9. What method involves examining and evaluating how a process works currently in order to get it where you want it to be in the future?

Gap analysis
The five whys
Strategy
Data visualization

Q10. Data-driven decision-making involves the five analytical skills: curiosity, understanding context, having a technical mindset, data design, and data strategy. Each plays a role in data-driven decision-making.

True
False

Foundations: Data, Data, Everywhere Week 3 Quiz Answers

Practice Quiz-1 Answers

L2 Following the data life cycle:

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

archive
planning
manage
capture

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

Manage
Analyze
Archive
Capture

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

True
False

Q4. 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
Plan
Analyze
Archive

Q5. After opening the ice cream shop on her farm, the dairy farmer 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?

Capture
Plan
Analyze
Archive

Practice Quiz-2 Answers

L3 Outlining the data analysis process:

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

Clean the data
Define the problem to be solved
Collect and store data
Create data visualizations.

Q2. The data analysis process phases are ask, prepare, process, analyze, share, and act. A data analyst cleans data to ensure it’s complete and correct during the process phase.

True
False

Q3. The data analysis process steps are ask, prepare, process, analyze, share, and act. During which phase would a data analyst use spreadsheets or query languages to transform data in order to draw conclusions?

Act
Analyze
Process
Prepare

Q4. The data analysis process steps are ask, prepare, process, analyze, share, and act. In which step would a data analyst use visuals such as charts or graphs to simplify complex data for better understanding?

Process
Share
Act
Prepare

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

Act
Prepare
Ask
Process

Practice Quiz-3 Answers

L4 The data analysis toolbox:

Q1. A spreadsheet is a digital worksheet that enables data analysts to do which of the following tasks? Select all that apply.

Store data
Organize data in columns and rows
Sort and filter data
Automatically access the latest data in real-time

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

a program
a function
an operation
a formula

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

True
False

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

structured
syntax
software
statistical

Q5. What is the term for the graphical representation of data?

Data visualization
Data summary
Data language
Data collection

Foundations: Data, Data, Everywhere Weekly Challenge 3 Answers

Q1. The manage stage of the data life cycle is when a business decides what kind of data it needs, how the data will be handled, and who will be responsible for it.

True
False

Q2. A data analyst has finished an analysis project that involved private company data. They erase the digital files in order to keep the information secure. This describes which stage of the data life cycle?

Manage
Destroy
Plan
Archive

Q3. In the analyze phase of the data life cycle, what might a data analyst do? Select all that apply.

Use a formula to perform calculations
Use spreadsheets to aggregate data
Create a report from the data
Choose the format of spreadsheet headings

Q4. Describe how the data life cycle differs from data analysis.

The data life cycle deals with transforming and verifying data; data analysis is using the insights gained from the data.
The data life cycle deals with the stages that data goes through during its useful life; data analysis is the process of analyzing data.
The data life cycle deals with making informed decisions; data analysis is using tools to transform data.
The data life cycle deals with identifying the best data to solve a problem; data analysis is about asking effective questions.

Q5. 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 which step of the data analysis process?

Analyze
Process
Share
Act

Q6. Fill in the blank: Spreadsheets are _____ that can be used to store, organize, and sort data.

digital worksheets
formulas and functions
interactive dashboards
visual representations

Q7. Fill in the blank: A formula is a set of instructions used to perform a specified calculation; whereas a function is _____.

a question written by the user
a predefined operation
a computer programming language
a particular value

Q8. Fill in the blank: A query is used to _____ information from a database. Select all that apply.

update
request
retrieve
analyze

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

True
False

Q10. The graphical representation of information helps stakeholders understand data insights. Formulas and functions make this possible.

True
False

Foundations: Data, Data, Everywhere Week 4 Quiz Answers

Practice Quiz-1 Answers

L2 Mastering spreadsheet basics:

Q1. In a spreadsheet, what is text wrapping used for?

To allow text to overflow into an adjacent cell
To automatically change cell height in order to allow all of the text to fit inside
To remove text that is too long to fit in a cell
To clip text within a cell so it doesn’t overflow into an adjacent cell

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

True
False

Q3. Fill in the blank: In a dataset, a row is called an observation. An observation includes all of the _____ for something contained in the row.

names
commonalities
attributes
diagnostics

Practice Quiz-2 Answers

L3 Learn about Structured Query Language (SQL):

Q1.

SELECT * FROM employee WHERE jobCode = 'FTE' AND LastName = 'James'

What does the asterisk (*) after SELECT tell the database to do in this query?

Select, then delete data.
Select and filter data.
Select and multiply data.
Select all data.

Q2.

SELECT * FROM employee WHERE jobCode = 'FTE' AND LastName = 'James'

In this query, the data analyst wants to retrieve data from which table?

LastName
employee
James
jobCode

Q3.

SELECT * FROM employee WHERE jobCode = 'FTE' AND LastName = 'James'

In this query, the data analyst wants to retrieve all data from the employee table, where the jobCode is FTE and the last name is James.

True
False

Q4. You are writing a query and want to instruct the database to retrieve data from the warehouse_inventory table. What is the SQL statement that follows SELECT *? Type your answer below.

FROM warehouse_inventory

Practice Quiz-3 Answers

L4 Visualizing the data:

Q1. Fill in the blank: A data visualization is the _____ representation of information.

contextual
tabulated
graphical
attributed

Q2. A data analyst uses data visualizations to support their findings.

True
False

Q3. A data analyst is creating a data visualization to share with stakeholders. Which spreadsheet tool do they use to select different chart types?

Chart Editor
Chart Maker
Chart Picker
Chart Chooser

Foundations: Data, Data, Everywhere Weekly Challenge 4 Answers

Q1. In the following spreadsheet, the column labels in row 1 are called what?

	A	B	C	D
1	Rank	Name	Population	County
2	1	Charlotte	885,708	Mecklenburg
3	2	Raleigh	474,069	Wake (seat), Durham
4	3	Greensboro	296,710	Guilford
5	4	Durham	278,993	Durham (seat), Wake, Orange
6	5	Winston-Salem	247,945	Forsyth
7	6	Fayetteville	211,657	Cumberland
8	7	Cary	170,282	Wake, Chatham
9	8	Wilmington	123,784	New Hanover
10	9	High Point	112,791	Guilford, Randolph, Davidson, Forsyth
11	10	Concord	96,341	Cabarrus

Attributes
Characteristics
Descriptors
Criteria

Q2. In the following spreadsheet, the observation of Greensboro describes all of the data in row 4.

	A	B	C	D
1	Rank	Name	Population	County
2	1	Charlotte	885,708	Mecklenburg
3	2	Raleigh	474,069	Wake (seat), Durham
4	3	Greensboro	296,710	Guilford
5	4	Durham	278,993	Durham (seat), Wake, Orange
6	5	Winston-Salem	247,945	Forsyth
7	6	Fayetteville	211,657	Cumberland
8	7	Cary	170,282	Wake, Chatham
9	8	Wilmington	123,784	New Hanover
10	9	High Point	112,791	Guilford, Randolph, Davidson, Forsyth
11	10	Concord	96,341	Cabarrus

True
False

Q3. If a data analyst wants to list the cities in this spreadsheet alphabetically, instead of numerically, what feature can they use in column B?

	A	B	C	D
1	Rank	Name	Population	County
2	1	Charlotte	885,708	Mecklenburg
3	2	Raleigh	474,069	Wake (seat), Durham
4	3	Greensboro	296,710	Guilford
5	4	Durham	278,993	Durham (seat), Wake, Orange
6	5	Winston-Salem	247,945	Forsyth
7	6	Fayetteville	211,657	Cumberland
8	7	Cary	170,282	Wake, Chatham
9	8	Wilmington	123,784	New Hanover
10	9	High Point	112,791	Guilford, Randolph, Davidson, Forsyth
11	10	Concord	96,341	Cabarrus

Organize range
Sort range
Name range
Randomize range

Q4. A data analyst types =POPULATION(C2:C11) to find the average population of the cities in this spreadsheet. However, they realize that have used the wrong formula. What syntax will correct this function? Type your answer below.

	A	B	C	D
1	Rank	Name	Population	County
2	1	Charlotte	885,708	Mecklenburg
3	2	Raleigh	474,069	Wake (seat), Durham
4	3	Greensboro	296,710	Guilford
5	4	Durham	278,993	Durham (seat), Wake, Orange
6	5	Winston-Salem	247,945	Forsyth
7	6	Fayetteville	211,657	Cumberland
8	7	Cary	170,282	Wake, Chatham
9	8	Wilmington	123,784	New Hanover
10	9	High Point	112,791	Guilford, Randolph, Davidson, Forsyth
11	10	Concord	96,341	Cabarrus

=AVERAGE(C2:C11)

Q5. In the following query, what is the asterisk (*) telling the database to do?

SELECT *

Return one specific field.
Select all of the data from the table.
Filter certain information.
Use proper syntax.

Q6. In the following query, what is FROM telling the database to do?

SELECT * FROM Orders

From which field data should be stored
From which table to select the data
From which filter data should be selected
From which field data should be updated

Q7. You are writing a query that asks a database to retrieve data about the customer with identification number 5656. The column name for customer identification numbers is customer_id. What is the correct WHERE clause syntax? Type your answer below.

WHERE customer_id = 5656

Q8. Fill in the blank: A data analyst creates a table, but they realize this isn’t the best visualization for their data. To fix the problem, they decided to use the _____ feature to change it to a column chart.

image
rename
chart editor
filter view

Q10. A data analyst wants to demonstrate how the population in Charlotte has increased over time. They created the chart below. What is this type of chart called?

Column chart
Area chart
Line chart
Bar chart

Foundations: Data, Data, Everywhere Week 5 Quiz Answers

Practice Quiz-1 Answers

L2 Roles of a data analyst:

Industry data example	Industry
Use geographic data to power GPS technology in cars	Technology
Use demographic data to target advertisements for a new consumer product for youths	Marketing
Use stock market data to determine which portfolios to invest in	Finance
Use bed occupancy data to determine the number of nurses and orderlies to schedule on a given shift	Healthcare
Use past booking data to accurately anticipate levels of demand for hotel rooms	Hospitality
Use population data to determine which communities need federal funding	Government

Practice Quiz-2 Answers

L3 Making decisions with data:

Q1. Data-driven decision-making and the application of data strategy are examples of what?

Business metric
Business platform
Business mission
Business task

Q2. Fill in the blank: Data-driven decision-making involves using _____ to guide business strategy.

facts
processes
intuition
tools

Practice Quiz-3 Answers

L4 Defining fairness in data:

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

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

Q2. 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
Decline to accept ads from Avens Engineering because of fairness concerns.
Let Avens Engineering decide which type of applicants to target ads to.
Only show ads for engineering jobs to women.

Q3. A data analyst working on a project related to truck-driver safety discovers that all reported accidents involve male drivers. What is their best course of action?

Disregard accidents that weren’t caused by driver error.
Take a closer look at the social context of their conclusion.
Analyze the safety data for other types of drivers.
Create a report to share the results with project stakeholders.

Q4. 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
Daytime riders
Male passengers
Female passengers

Q5. 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 the gender breakdown of human resources professionals was accurate.

True
False

Foundations: Data, Data, Everywhere Weekly Challenge 5 Answers

Q1. An online gardening magazine wants to understand why its subscriber numbers have been increasing. What kind of reports can a data analyst provide to help answer that question? Select all that apply.

Reports that predict the success of sales leads to secure future subscribers
Reports that compare past weather patterns to the number of people taking up gardening recently
Reports that show how many customers shared positive comments about the gardening magazine on social media in the past year
Reports that examine how a recent 50%-off sale affected the number of subscription purchases

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

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

Data Programming
Data visualization
Data ethics
Data-driven decision-making

Q4. Fill in the blank: A business task is described as a problem or _____ a data analyst answers for a business.

solution
comment
question
complaint

Q5. Data-driven decision-making is using facts to guide business strategy. The benefits include which of the following? Select all that apply.

Getting a complete picture of a problem and its causes
Using data analytics to find the best possible solution to a problem
Making the most of intuition and gut instinct
Combining observation with objective data

Q6. It’s possible for conclusions drawn from data analysis to be both true and unfair.

True
False

Q7. Fill in the blank: Fairness is achieved when data analysis doesn’t create or _____ bias.

resolve
reinforce
constrain
highlight

Q8. A gym wants to start offering exercise classes. A data analyst plans to survey 10 people to determine which classes would be most popular. To ensure the data collected is fair, what steps should they take? Select all that apply.