Course 1: Foundations: Data, Data, Everywhere, all quiz answers of this course are provided in this article from week 1 to week 5 to help students solving this exam.


coursera google data analytics quiz answers of all 8 course pdf google data analytics professional certificate coursera quiz answers google data analytics professional certificate week 1 answers familiar with data analytics? take our diagnostic quiz data analysis with r programming coursera answers in data analytics, a model is a group of elements that interact with one another. its possible for conclusions drawn from data analysis to be both true and unfair *weekly challenge 1* google data analytics


Coursera Google Data Analytics Week 1 Quiz Answers!

> Introducing data analytics.

Question 1

Data analysis is the various elements that interact with one another in order to provide, manage, store, organize, analyze, and share data.

True

False

Explanation:

Data analysis is the collection, transformation, and organization of data in order to draw conclusions, make predictions, and drive informed decision-making.

Question 2

In data analytics, what term describes a collection of elements that interact with one another?

A data ecosystem

A database

The cloud environment

A modelling system

Explanation:

Data ecosystems are made up of elements that interact to produce, manage, store, organize, analyze, and share data.

Question 3

Fill in the blank: The primary goal of a data _____ is to find answers to existing questions by creating insights from data sources.

engineer

analyst

scientist

designer

The primary goal of a data analyst is to find answers to existing questions by creating insights from data sources.

Question 4

Select the best description of gut instinct.

An intuitive understanding of something with little or no explanation 

Choosing facts that complement your personal experiences

Manipulating data to match your intuition

Using your innate ability to analyze results

Explanation:

Gut instinct is an intuitive understanding of something with little or no explanation.

Question 5

Billings Upholstery has defined a problem it needs to solve: Find a more environmentally friendly way to produce its furniture. A data analyst gathers relevant data, analyzes it, and uses it to draw conclusions. The analyst then shares their analysis with subject-matter experts from the manufacturing team, who validate the findings. Finally, a plan is put into action. This scenario describes what process?

Data-driven decision-making

Identification of trends

Data science

Customer service

Explanation:

This company has put data at the heart of its business strategy in order to achieve data-driven decision-making.

Question 6

What do subject-matter experts do to support data-driven decision-making? Select all that apply.

Validate the choices made as a result of the data insights

Collect, transform, and organize data

Offer insights into the business problem

Review the results of data analysis and identify any inconsistencies

Explanation:

Subject-matter experts can offer insights into the business problem, identify inconsistencies in the analysis, and validate the choices being made.

Question 7

Sharing the results of your analysis with colleagues who are very familiar with the business problem supports what practice? 

Data analytics

Data-driven decision-making

Data management

Data science

Explanation:

Sharing the results of your analysis with people who are familiar with the business problem is an example of data-driven decision-making. Data-driven decision-making is using facts to guide business strategy. 

Question 8

You read an interesting article in a magazine and want to share it in the discussion forum. What should you do when posting? Select all that apply.

Make sure the article is relevant to data analytics.

Check your post for typos or grammatical errors.

Take credit for creating the article.

Include your email address for people to send questions or comments.

Explanation:

Posts should be relevant to data analytics and checked for typos and grammatical errors. 

Coursera Google Data Analytics Week 2 Quiz Answers!

> All About Analytical Thinking

Question 1

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

Understanding context 
Having a technical mindset
Data strategy
Curiosity

Explanation:

Curious people seek out new challenges, which leads to knowledge. 

Question 2

Understanding context is an analytical skill best described by which of the following? Select all that apply. 

Working with facts in an orderly manner
Identifying the motivation behind the collection of a dataset
Adding descriptive headers to columns of data in a spreadsheet 
Gathering additional information about data to understand the broader picture 

Explanation:

Context is the condition in which something exists, such as a structure. Gathering extra information about data to understand the broader picture provides context.

Question 3

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?

Understanding context
Data strategy
A technical mindset 
Curiosity

Explanation:

They are using a technical mindset, which involves the ability to break things down into smaller steps or pieces and work with them in an orderly and logical way.

Question 4

Data design is how you organize information; data strategy is the management of the people, processes, and tools used in data analysis. 

True
False

Question 5

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

correlation
detail-oriented thinking
problem-orientation
visualization 

Explanation:

Being able to identify a relationship between two or more pieces of data describes correlation.

Question 6

What method involves asking numerous questions in order to get to the root cause of a problem?

Inquiry
Strategizing
Curiosity
The five whys

Explanation:

The five whys involves asking numerous questions in order to get to the root cause of a problem. 

Question 7

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?

The five whys
Data visualization
Gap analysis 
Strategy

Explanation:

Gap analysis is a method for examining and evaluating how a process works currently in order to get where you want to be in the future.

Question 8

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

Explanation:

Data-driven decision-making involves curiosity, understanding context, having a technical mindset, data design, and data strategy.

Coursera Google Data Analytics Week 3 Quiz Answers!

The wonderful world of data.
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
Coursera Google Data Analytics Week 4 Quiz Answers!

Set up your toolbox.
Question 1
Question 1

The column attributes for rank, name, population, and county are located in which row

of the following spreadsheet?

ABCD
1RankNamePopulationCounty
21Charlotte885,708Mecklenburg
32Raleigh474,069Wake (seat), Durham
43Greensboro296,710Guilford
54Durham278,993Durham (seat), Wake, Orange
65Winston-Salem247,945Forsyth
76Fayetteville211,657Cumberland
87Cary170,282Wake, Chatham
98Wilmington123,784New Hanover
109High Point112,791Guilford, Randolph, Davidson, Forsyth
1110Concord96,341Cabarrus
  • 11
  • 1
  • 2
  • 10
Question 2

Fill in the blank: In row 8 of the following spreadsheet, you can find the _____ of Cary.

ABCD
1RankNamePopulationCounty
21Charlotte885,708Mecklenburg
32Raleigh474,069Wake (seat), Durham
43Greensboro296,710Guilford
54Durham278,993Durham (seat), Wake, Orange
65Winston-Salem247,945Forsyth
76Fayetteville211,657Cumberland
87Cary170,282Wake, Chatham
98Wilmington123,784New Hanover
109High Point112,791Guilford, Randolph, Davidson, Forsyth
1110Concord96,341Cabarrus

  • criteria
  • attribute 
  • format
  • observation

Question 3

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

ABCD
1RankNamePopulationCounty
21Charlotte885,708Mecklenburg
32Raleigh474,069Wake (seat), Durham
43Greensboro296,710Guilford
54Durham278,993Durham (seat), Wake, Orange
65Winston-Salem247,945Forsyth
76Fayetteville211,657Cumberland
87Cary170,282Wake, Chatham
98Wilmington123,784New Hanover
109High Point112,791Guilford, Randolph, Davidson, Forsyth
1110Concord96,341Cabarrus
  • Organize range
  • Sort range
  • Name range
  • Randomize range
Question 4

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.

ABCD
1RankNamePopulationCounty
21Charlotte885,708Mecklenburg
32Raleigh474,069Wake (seat), Durham
43Greensboro296,710Guilford
54Durham278,993Durham (seat), Wake, Orange
65Winston-Salem247,945Forsyth
76Fayetteville211,657Cumberland
87Cary170,282Wake, Chatham
98Wilmington123,784New Hanover
109High Point112,791Guilford, Randolph, Davidson, Forsyth
1110Concord96,341Cabarrus
=AVERAGE(C2:C11)
Question 5

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 data
  • From which filter data should be selected
  • From which field data should be updated
Question 6

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

A data analyst creates the following visualization to clearly demonstrate how much more populous Charlotte is than the next-largest North Carolina city, Raleigh. What type of chart is it?


  • A scatter chart
  • A pie chart
  • A line chart
  • A column, or bar, chart 
Question 8

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

Google Data Analytics Course 1 All Quiz Answers - Coursera!

  • Column chart
  • Area chart
  • Line chart
  • Bar chart
Coursera Google Data Analytics Week 5 Quiz Answers!

Endless career possibilities.

Question 1

Scenario 1, Question 1-5

You’ve just started a new job as a data analyst. You’re working for a midsized pharmacy chain with 38 stores in the American Southwest. Your supervisor shares a new data analysis project with you.
She explains that the pharmacy is considering discontinuing a bubble bath product called Splashtastic. Your supervisor wants you to analyze sales data and determine what percentage of each store’s total daily sales come from that product. Then, you’ll present your findings to leadership.
You know that it's important to follow each step of the data analysis process: ask, prepare, process, analyze, share, and act. So, you begin by defining the problem and making sure you fully understand stakeholder expectations.
One of the questions you ask is where to find the dataset you’ll be working with. Your supervisor explains that the company database has all the information you need. 
Next, you continue to the prepare step. You access the database and write a query to retrieve data about Splashtastic. You notice that there are only 38 rows of data, representing the company’s 38 stores. In addition, your dataset contains five columns: Store Number, Average Daily Customers, Average Daily Splashtastic Sales (Units), Average Daily Splashtastic Sales (Dollars), and Average Total Daily Sales (All Products). 

Considering the size of your dataset, what’s the best way to proceed with the process and analyze steps?

  • Download the data, then use a spreadsheet to process and analyze it.
  • Continue using the company database to process and analyze the data.
  • Upload the data, then process and analyze it using Tableau.
  • Use SQL to process and analyze the data.
Spreadsheets work well for processing and analyzing a small dataset, such as the one you’re using.
Question 2

Scenario 1 continued

You’ve downloaded the data from your company database and imported it into a spreadsheet. To use the dataset for this scenario, click the link below and select “Use Template.” 
Link to template: Course Challenge - Scenario 1 

OR 

If you don’t have a Google account, you can download the template directly from the attachment below.
Course Challenge Dataset - Scenario 1 - Scenario 1_ Pharmacy Data - Part 1.csv
Now, it’s time to process the data. As you know, this step involves finding and eliminating errors and inaccuracies that can get in the way of your results. While cleaning the data, you notice that information about Splashtastic is missing in row 16. The best course of action is to delete row 16 from your dataset so the missing data doesn’t get in the way of your results.
  • True
  • False

Question 3

Scenario 1 continued

Once you’ve found the missing information, you analyze your dataset. 
During analysis, you create a new column F. At the top of the column, you add: Average Percentage of Total Sales - Splashtastic. In data analytics, this column label is called an attribute.
  • True
  • False
This column label is an attribute, which is a characteristic or quality of data used to label a column.
Question 4

Scenario 1 continued

Next, you determine the average total daily sales over the past 12 months at all stores, The range that contains these sales is E2:E39. To do this, you use a function. Fill in the blank to complete the function correctly: =_____ (E2:E39). 
  • AVERAGE
  • SUM
  • SALES
  • TOTAL
The function begins with an equal sign (=), then the word AVERAGE. The range is all of column E, represented by E:E.
Question 5

Scenario 1 continued

You’ve reached the share phase of the data analysis process. It involves which of the following? Select all that apply.
  • Create a data visualization to highlight the Splashtastic sales insights you've discovered.
  • Prepare a slideshow about Splashtastic’s sales and practice your presentation.
  • Stop selling Splashtastic because it doesn't represent a large percentage of total sales.
  • Present your findings about Splashtastic to stakeholders.
The share phase involves creating data visualizations, preparing your presentation, and communicating your findings to stakeholders.
Question 6

Scenario 2, Question 6-10

You’ve been working for the nonprofit National Dental Society (NDS) as a junior data analyst for about two months. The mission of the NDS is to help its members advance the oral health of their patients. NDS members include dentists, hygienists, and dental office support staff. 
The NDS is passionate about patient health. Part of this involves automatically scheduling follow-up appointments after crown replacement, emergency dental surgery, and extraction procedures. NDS believes the follow-up is an important step to ensure patient recovery and minimize infection. 
Unfortunately, many patients don’t show up for these appointments, so the NDS wants to create a campaign to help its members learn how to encourage their patients to take follow-up appointments seriously. If successful, this will help the NDS achieve its mission of advancing the oral health of all patients. 
Your supervisor has just sent you an email saying that you’re doing very well on the team, and he wants to give you some additional responsibility. He describes the issue of many missed follow-up appointments. You are tasked with analyzing data about this problem and presenting your findings using data visualizations. 
An NDS member with three dental offices in Colorado offers to share its data on missed appointments. So, your supervisor uses a database query to access the dataset from the dental group. The query instructs the database to retrieve all patient information from the member’s three dental offices, located in zip code 81137. 
The table is dental_data_table, and the column name is zip_code. How do you complete the following query? 
  • WHERE_zip_code = 81137
  • WHERE = 81137
  • WHERE zip_code = 81137
  • zip_code = 81137
The correct syntax is WHERE zip_code = 81137. WHERE indicates where to look for information. The column name is zip_code. And the database is being asked to return only records matching zip code 81137.
Question 7

Scenario 2 continued....

The dataset your supervisor retrieved and imported into a spreadsheet includes a list of patients, their demographic information, dental procedure types, and whether they attended their follow-up appointment. To use the dataset for this scenario, click the link below and select “Use Template.”
Link to template: Course Challenge - Scenario 2
                                                                      OR 
If you don’t have a Google account, you can download the template directly from the attachment below.
Course Challenge Dataset - Scenario 2.csv
The patient demographic information includes data such as age and gender. As you’re learning, it’s your responsibility as a data analyst to make sure your analysis is fair. The fact that the dataset includes people who all live in the same zip code might get in the way of fairness.
  • True
  • False
It’s your responsibility as a data analyst to make sure your analysis is fair. Although many zip codes do reflect diverse populations, a better choice would be to include data about people who live in multiple zip codes.
Question 8

Scenario 2 continued......

As you’re reviewing the dataset, you notice that there are a disproportionate number of senior citizens. So, you investigate further and find out that this zip code represents a rural community in Colorado with about 800 residents. In addition, there’s a large assisted-living facility in the area. Nearly 300 of the residents in the 81137 zip code live in the facility. 
You recognize that’s a sizable number, so you want to find out if age has an effect on a patient’s likelihood to attend a follow-up dental appointment. You analyze the data, and your analysis reveals that older people tend to miss follow-ups more than younger people. 
So, you do some research online and discover that people over the age 60 are 50% more likely to miss dentist appointments. Sometimes this is because they’re on a fixed income. Also, many senior citizens lack transportation to get to and from appointments. 
With this new knowledge, you write an email to your supervisor expressing your concerns about the dataset. He agrees with your concerns, but he’s also impressed with what you’ve learned and thinks your findings could be very important to the project. He asks you to change the business task. Now, the NDS campaign will be about educating dental offices on the challenges faced by senior citizens and finding ways to help them access quality dental care. 
Changing the business task involves defining the new question or problem to be solved.
  • True
  • False
A business task is the question or problem data analysis answers for a business.
Question 9

Scenario 2 continued.....

You continue with your analysis. In the end, your findings support what you discovered during your online research: As people get older, they’re less likely to attend follow-up dental visits. 
But you’re not done yet. You know that data should be combined with human insights in order to lead to true data-driven decision-making. So, your next step is to share this information with people who are familiar with the problem. They’ll help verify the results of your data analysis.
The people who are familiar with a problem and help verify the results of data analysis include customers and competitors.
  • True
  • False
Question 10

Scenario 2 continued.......

The subject-matter experts are impressed by your analysis. The team agrees to move to the next step: data visualization. You know it’s important that stakeholders at NDS can quickly and easily understand that older people are less likely to attend important follow-up dental appointments. This will help them create an effective campaign for members.
It’s time to create your presentation to stakeholders. It will include a data visualization that demonstrates the trend of people being less likely to attend follow-up appointments as they get older. Which type of chart will be most effective?
  • A pie chart
  • A table
  • A doughnut chart
  • A line chart
A line chart is effective for tracking trends over time, such as people attending fewer follow-up appointments as they get older.

Post a Comment

Previous Post Next Post