Ask Questions to Make Data-Driven Decisions Module 1-4 Challenge Answers

Google Data Analytics: Course 2: Module 1 Challenge Answers

Fill in the blank: When solving the _____ problem type, a junior data analyst at a home goods retailer provider analyzes sales data from the past three years. They then use this information to understand what led to slumps in customer demand and what is likely to cause them again.

• finding patterns
• discovering connections
• identifying themes
• categorizing things

Which of the following statements correctly describe the SMART methodology? Select all that apply.

• Time-bound questions limit the amount of time analysts should work on a particular project.
• Relevant questions matter, are important, and have significance to the problem.
• SMART stands for specific, measurable, action-oriented, relevant, and time-bound.
• Specific questions are simple, significant, and focused on a single topic or a few closely related ideas.

A restaurant group is choosing the locations of new restaurant openings. They use an algorithm to monitor current trends and develop business intelligence about where people most frequently dine out. Which data problem type does this scenario describe?

• Spotting something unusual
• Making predictions
• Discovering connections
• Categorizing things

For what reasons would it be unfair for a car dealer to ask customers, “Why are our cars better than other cars on the market?” Select all that apply.

• It is vague
• It makes assumptions
• It is a closed-ended question
• It is a leading question

Fill in the blank: When solving the _____ problem type, a data analytics team notices a surprising shift in global economic conditions.

• discovering connections
• making predictions
• identifying themes
• spotting something unusual

A data professional sorts manufacturing production data by facility. Then, they group that information into broader concepts, such as the type of machine involved and materials used. Which data problem type does this scenario describe?

• Finding patterns
• Making predictions
• Discovering connections
• Identifying themes

Which of the following questions are open-ended? Select all that apply.

• What are you most looking forward to in the coming year?
• On a scale of 1-10 (with 10 being most important), how important is eating healthy?
• How would you describe this movie?
• Have you ever traveled outside your home country?

A trade school in Alberta discovers that student performance has been dropping over the past three years. A data professional researches current trends across Canada and identifies the same issue at many other trade schools. School leaders all come together to discuss the challenges they face and share information that will help them improve teaching practices and better support students. What data problem type are they solving?

• Discovering connections
• Making predictions
• Identifying themes
• Categorizing things

Fill in the blank: The question, “How can we create a more innovative culture by empowering our employees to take risks?” is _____ because it encourages change.

• specific
• relevant
• action-oriented
• measurable

A junior data professional working for an online retailer is asked to determine which ads are most successful with shoppers. They review click-throughs compared to the type of ads presented, then group the ads accordingly. Which data problem type does this scenario describe?

• Discovering connections
• Finding patterns
• Categorizing things
• Spotting something unusual

Ask Questions to Make Data-Driven Decisions Module 2 Challenge Answers

A data team at a community center automates a process to segment clients. First, a list of all clients is compiled. Then, they are sorted by the classes they have taken and events attended. Finally, clients are segmented by their activity histories. What does this scenario describe?

• Making a pivot table
• Using a formula
• Creating an algorithm
• Data-inspired decision-making

Which of the following statements accurately describe qualitative and quantitative data? Select all that apply.

• Quantitative data involves numerical facts.
• Qualitative data describes subjective characteristics.
• The temperature of an office building is an example of qualitative data.
• The color of the ocean is an example of quantitative data.

When working with big data, analysts consider the variety of data within large, complex datasets. What does this entail?

• Understanding how quickly the data can be processed
• Identifying the different kinds of data included
• Assessing the amount of data available
• Evaluating the quality and reliability of the data

A data professional uses a spreadsheet tool to create a visualization that totals productivity data by organization, department, and employee. What tool are they using?

• Pivot table
• Sort
• Data validation
• Format

Company decision-makers at a gas utility want to improve business performance. How could they use metrics and a metric goal to help them do so?

• Set a metric as the business objective. Then, quantify it using numerous data points.
• Develop a metric. Then, evaluate it to determine whether it advances performance.
• Establish a metric goal as a single data point. Then, quantify it with metrics.
• Create a metric goal as the business objective. Then, evaluate it using metrics.

Which of the following statements correctly describe dashboards and reports? Select all that apply.

• Reports provide continual access to information.
• Dashboards are useful for data visualization.
• A report is a static collection of data given to stakeholders periodically.
• A sales dashboard could be used to track daily e-commerce sales.

Fill in the blank: ROI is calculated by comparing the two metrics of ______, enabling a company to determine the success of the investment.

• gross margin and net margin
• investment cost and profit
• value and expenses
• sales and revenue

What are some typical challenges that may be faced by businesses that are beginning to collect and use big data? Select all that apply.

• Large datasets cannot cover a long time period
• Slower decision-making time frames
• Having too much irrelevant information
• Technology may not provide measurable data

Ask Questions to Make Data-Driven Decisions Module 3 Challenge Answers

In this spreadsheet, what will be returned from the formula =A4*D3?

• 3
• 4
• 12
• 8

Fill in the blank: A _____ is a collection of two or more cells.

• domain
• field
• scope
• range

What are some common focus areas when creating a scope of work as a data analyst? Select all that apply.

• Develop a software solution for the analysis
• Establish an agreed-upon outline of the work to be performed
• Include information about analysis of quantitative and qualitative datasets
• Note when the client can expect reports

A data professional troubleshoots a spreadsheet error. After researching the error, they discover that their formula is referencing a column that has been deleted. They update the formula with the correct column name. What type of error did they resolve?

• VALUE
• REF
• ERROR or parsing error
• NUM

In this spreadsheet, which SUM function will add all of the values between cells E1 and F6?

• =SUM(E1-F6)
• =SUM(E1,F6)
• =SUM(E1:F6)
• =SUM,E1+F6

Which of the following statements accurately describes structured thinking and the problem domain? Select all that apply.

• The problem domain involves organizing available information, revealing gaps and opportunities, and identifying options.
• Determining a problem domain helps make it possible to establish requirements.
• The starting place for structured thinking is the problem domain.
• Structured thinking enables data professionals to understand problems at a high level.

In this spreadsheet, what should be done to correct the DIV error in cell D3?

• Ensure the formula is not trying to divide by zero or an empty cell.
• Copy the formula to the rest of the cells in column D.
• Insert a comma between the cell ranges in the formula.
• Search for the correct value in column A.

What is the formula for dividing the value in spreadsheet cell G10 by the value in cell G9?

• G10:G9
• =G10/9
• =G10/G9
• G10,G9=

Ask Questions to Make Data-Driven Decisions Module 4 Challenge Answers

Fill in the blank: Stakeholders _ when contributing to a project.

• implement solutions
• connect with customers
• present data insights
• invest time and resources

You are invited to a meeting. You review the agenda and notice that your data analysis project is one of the topics that will be discussed. What strategies should you use to prepare? Select all that apply.

• Distribute a revised agenda that includes more details about your project.
• Plan to arrive on time
• Think about what project updates you should share
• Bring materials for taking notes

A data analyst prepares for a stakeholder presentation. To ensure they communicate clearly, they follow best practices and ask four questions, including: What does my audience need to know? Identify the remaining three questions the data analyst should ask. Select all that apply.

• What does my audience already know?
• What does my audience want to avoid?
• How can I communicate effectively to my audience?
• Who is my audience?

You accept a new project from a high level stakeholder. After beginning the project, you find that you aren’t sure what you are supposed to do. How do you handle this?

• Determine the objectives that make the most sense and work toward those.
• Perform standard analysis and present insights you believe are helpful.
• Set up a meeting with the stakeholder to discuss the specific objectives.
• Ask a member of your team what was done on the last project and do the same.

You join an online meeting on time. After reviewing the agenda, you note that your project will be discussed at the very end. You are extremely busy and can use this time to stay on top of other projects. How should you proceed?

• Mute yourself and turn off the camera, then continue working on other tasks until your project is mentioned.
• Tell the participants that you are having technical trouble, then leave the meeting to continue working on other tasks.
• Stay focused and attentive during the entire meeting. Even though some items on the agenda don’t affect your projects, you could still learn something or have something to contribute.
• Politely let the presenter know you’re going to leave the meeting and rejoin toward the end.

A data analyst at a real estate firm investigates a surge in new home buyers. During the analysis, which team is most likely to offer helpful insight about the desires of these home buyers?

• Project management
• Customer-facing
• Executive
• Data science

Your manager assigns you a project task, and you don’t understand the point of the project. What questions can you ask them to determine the objective? Select all that apply.

• What is the big picture?
• What is the story they want to tell?
• What do you have to do for this task?
• What is their end goal?

A data analytics team works on a project to measure the success of their company’s new financial strategy. Who is most likely to be the primary stakeholder?

• Data analyst
• Vice president of finance
• Project manager
• Analytics director