2. Ask Questions to Make Data-Driven Decisions

The customer-facing team does which of the following activities? Select all that apply. 1. Compile information about customer expectations 2. Share customer feedback 3. Tell the data story to others 4. Provide operational leadership for the company

1. Compile information about customer expectations 2. Share customer feedback

Questions leading to answers that can be quantified and assessed align with which component of the SMART methodology? 1. Measurable 2. Reasonable 3. Tangible 4. Appropriate

1. Mesurable

A team member has asked you to take on a task, and you don't understand the point of the project. It seems like it will be a waste of your time. The best course of action would be to politely explain your concerns and decline the project. 1. True 2. False

2. False

A data analyst at an online retailer works with historical sales data. The analyst identifies repeating trends in the sales data. This is an example of which problem type? 1. Identifying themes 2. Finding patterns 3. Making predictions 4. Categorizing things

2. Finding patterns

Which of the following statements accurately describe formulas and functions? Select all that apply. 1. Formulas may only be used once per spreadsheet column 2. Formulas are instructions that perform specific calculations 3. Formulas and functions assist data analysts in calculations, both simple and complex 4. Functions are preset commands that perform calculations

2. Formulas are instructions that perform specific calculations 3. Formulas and functions assist data analysts in calculations, both simple and complex 4. Functions are preset commands that perform calculations

A company wants to make more informed decision regarding next year's business strategy. An analyst uses data to help identify how things will likely work out in the future. This is an example of which problem type? 1. Spotting something unusual 2. Making predictions 3. Discovering connections 4. Identifying themes

2. Making predictions

Return on Investment (ROI) uses which of the following metrics in its definition? 1. Sales and margin 2. Profit and investment 3. Supply and demand 4. Inventory and units

2. Profit and investment

A data analyst considers which organization created, collected, or funded a dataset in order to understand its ________. 1. detail 2. context 3. length 4. structure

2. context

In data analytics, reports use data that doesn't change once it's been recorded. Which of the following terms describes this type of data? 1. Monitored 2. Comprehensive 3. Static 4. Real-time

3. Static

Which data-summarization tool do data analysts use to sort, reorganize, group, count, total, or average data? 1. A report 2. A function 3. A dashboard 4. A pivot table

4. A pivot table

Putting data into context helps data analysts eliminate ______. 1. bias 2. intolerance 3. labels 4. fairness

1. bias

A metric is a specific type of data that companies use to identify a problem domain. 1. True 2. False

2. False

In data analytics, reports use live, incoming data from multiple datasets; dashboards use static collections of data. 1. True 2. False

2. False

What are the first steps a data analyst takes when working with data in a spreadsheet? 1. Sort and filter 2. View and summarize 3. Calculate and present 4. Highlight and graph

1. Sort and filter

Data-inspired decision-making can discover _____ when exploring different data sources. 1. which experts can give advice 2. where the largest amount of data is 3. what the data has in common 4. if a decision was properly made

3. what the data has in common

Which of the following are examples of operators used in formulas? Select all that apply. 1. Asterisk (*) 2. Hyphen (-) 3. Hash (#) 4. Forward slash (/)

1. Asterisk (*) 2. Hyphen (-) 4. Forward slash (/)

If a data analysts is measuring qualities and characteristics, they are considering _____ data. 1. unbiased 2. cleaned 3. quantitative 4. qualitative

4. qualitative

Quantitative data is specific and _____. 1. descriptive 2. subjective 3. explanatory 4. objective

4. objective

What are some strategies to ensure your data is accurate and fair? Select all that apply. 1. Make sure you start with an accurate representation of the population in the sample 2. Use data that is very personal to you 3. Think through the "who, what, where, when, how, and why" of your data 4. Collect the data in an objective way

1. Make sure you start with an accurate representation of the population in the sample 3. Think through the "who, what, where, when, how, and why" of your data 4. Collect the data in an objective way

What is the term for a preset command in a spreadsheet? 1. Quotient 2. Range 3. Cell 4. Function

4. Function

Data analysts can use ______ to highlight the area around cells in order to see spreadsheet data more clearly. 1. pivot tables 2. borders 3. filters 4. italics

2. borders

When giving a spreadsheet a title, what are soMe best practices to follow? Select all that apply. 1. Titles should be clear 2. Titles should be in ALL CAPS 3. Titles should state what the data in the spreadsheet is about 4. Titles should be short

1. Titles should be clear 3. Titles should state what the data in the spreadsheet is about 4. Titles should be short

Which of the following tasks might be performed using spreadsheets? 1. Develop communication skills 2. Write a sales pitch 3. Land a new client 4. Maintain information about accounts

4. Maintain information about accounts

If a cooking supply store wants to attract more customers, where can they advertise to better reach their target audience? Select all that apply. 1. In a magazine all about advertising 2. On TV during the season finale of The Best Chef in the Universe 3. On a podcast for foodies 4. At a bus stop near a local culinary school

2. On TV during the season finale of The Best Chef in the Universe 3. On a podcast for foodies 4. At a bus stop near a local culinary school

What is the term for the set of cells that a data analyst selects to include in a formula? 1. Cell domain 2. Cell set 3. Data boundary 4. Data range

4. Data range

Which of the following are functions? Select all that apply. 1. MIN 2. AVERAGE 3. START 4. SUM

1. MIN 2. AVERAGE 4. SUM

Categorizing things involves assigning items to categories. Identifying themes takes those categories a step further, grouping them into broader themes or classifications. 1. True 2. False

1. True

If someone is subjectively describing their feelings or emotions, it is qualitative data. 1. True 2. False

1. True

Data analysts use which of the following functions to quickly perform calculations in a spreadsheet? Select all that apply. 1. MASS 2. AVERAGE 3. SUM 4. MIN

2. AVERAGE 3. SUM 4. MIN

A data analyst considers who, what, when, where, why, and how in order to achieve what goal? 1. To create compelling graphs 2. To ensure calculations are accurate 3. To put information into context 4. To make data-driven decisions

3. To put information into context

Return on investment compares the cost of an investment to the _____ of that investment. 1. purpose 2. timing 3. net profit 4. future success

3. net profit

By negatively influencing data collection, _____ can have a detrimental effect on analysis. 1. filtering 2. bias 3. objectivity 4. partiality

2. bias

A data analyst is trying to understand what data to use to help solve a business problem. They're asking questions such as, "What internal data is available in the database?" and "What outside facts do I need to research?" The data analyst is in which phase of the data analysis process? 1. Prepare 2. Ask 3. Share 4. Act

1. Prepare

In the function =MAX(B5:B15), what does B5:B15 represent? 1. Range 2. Observation 3. Attribute 4. Column

1. Range

The question, "How could we improve our website to simplify the returns process for our online customers?" is action-oriented. 1. True 2. False

1. True

To perform calculations in a spreadsheet, data analysts use formulas and functions. 1. True 2. False

1. True

A data analytics team works to recognize the current problem. Then, they organize available information to reveal gaps and opportunities. Finally, they identify the available options. These steps are part of what process? 1. Using structured thinking 2. Categorizing things 3. Applying the SMART methodology 4. Making connections

1. Using structured thinking

Which of the following examples are leading questions? Select all that apply. 1. What do you enjoy most about our service? 2. How satisfied were you with our customer representative? 3. In what ways did our product meet your needs? 4. How did you learn about our company?

1. What do you enjoy most about our service? 2. How satisfied were you with our customer representative? 3. In what ways did our product meet your needs?

In data analytics, a process or set of rules to be followed for a specific task is ______. 1. an algorithm 2. a value 3. a pattern 4. a domain

1. an algorithm

Which of the following options describes a metric goal? Select all that apply. 1. Indefinite 2. Evaluated using metrics 3. Measurable 4. Based on theory

2. Evaluated using metrics 3. Measurable

A data analyst at a social media company is creating questions for a focus group. They use common abbreviations such as PLS for "please" and LMK for "let me know". This is fair because the participants use social media a lot and are likely to be technically savvy. 1. True 2. False

2. False

A data analyst is researching the buying behavior of people who shop at a company's retail store and those who might shop there in the future. During the analysis, it will be important to stay in communication with the people who most often interact with these shoppers. They are members of the executive team. 1. True 2. False

2. False

If a data analyst compares the cost of an investment to the net profit of that investment over a period of time, they're analyzing the investment scope. 1. True 2. False

2. False

The amount of exercise time it takes for a single person to burn a minimum of 400 calories is a problem that requires big data 1. True 2. False

2. False

There are four key questions data analysts ask themselves: who is my audience? What do they already know? What do they need to know? And how can I communicate effectively with them? These questions enable data analysts to identify the person in charge of managing the data. 1. True 2. False

2. False

To determine an organization's annual budget, a data analyst might use a slideshow. 1. True 2. False

2. False

While creating data visualizations for a slideshow, a data analyst considers, "What would help a stakeholder understand this data better?" The analyst is in the analyze step of the data analysis process. 1. True 2. False

2. False

What is the difference between qualitative and quantitative data? 1. Qualitative data describes the kind of data being analyzed. Quantitative data describes how much data is being analyzed 2. Qualitative data can be used to measure qualities and characteristics. Quantitative data can be used to measure numerical facts 3. Qualitative data is specific. Quantitative data is subjective 4. Qualitative data is about the quality of a product or service. Quantitative data is about how much of that product or service is available

2. Qualitative data can be used to measure qualities and characteristics. Quantitative data can be used to measure numerical facts

What are the key elements of structured thinking? Select all that apply. 1. Implementing a solution 2. Recognizing the current problem or situation 3. Organizing available information 4. Revealing gaps and opportunities in order to identify the options

2. Recognizing the current problem or situation 3. Organizing available information 4. Revealing gaps and opportunities in order to identify the options

Pivot tables in data processing tools are used to _____ data. 1. populate 2. summarize 3. clean 4. validate

2. summarize

As a data analyst, it's important to communicate often. Sharing detailed notes and creating reports are ways to communicate with the people who have invested time and resources in a project. Who are these people? 1. Executives 2. Subject-matter experts 3. Customer-facing team 4. Stakeholders

4. Stakeholders

People who hold a stake in the outcome of a data analysis project are called stakeholders. In what ways do they hold a stake in the outcome? 1. They present to the team about what the data reveals 2. They implement the solution to the analysis problem 3. They collect and clean the data being used for analysis 4. They invest time and resources into the project

4. They invest time and resources into the project

Data-inspired decision-making explores different data sources to find _____. 1. problems 2. outliers 3. predictions 4. commonalities

4. commonalities

A data analytics team is working on a project to measure the success of a company's new financial strategy. The vice president of finance is most likely to be the ________. 1. secondary stakeholder 2. project manager 3. analyst 4. primary stakeholder

4. primary stakeholder

A scope of work is an agreed-upon _____ of the work you're going to perform on a project. 1. report 2. outline 3. diagram 4. to-do list

2. outline

Which of the following examples are vague questions? Select all that apply. 1. Do you generally prefer hot or cold? 2. Who was the greatest of all time? 3. How much time did you spend waiting in line? 4. What's the best place to purchase the things we need?

1. Do you generally prefer hot or cold? 2. Who was the greatest of all time? 4. What's the best place to purchase the things we need?

Making predictions is one of the six data analytics problem types. It deals with using data to inform decisions about how things may be in the future. Select the scenario that's an example of making predictions. 1. A data analyst at a shoe retailer uses data to inform the marketing plan for an upcoming summer sale 2. A data analyst at a school system uses data to make a connection between home sales and new student enrollment 3. A data analyst at a technology company uses data to identify a unique drop in social media engagement 4. A data analyst at a gas company uses historical data to analyze which time of year customers use the most gas

1. A data analyst at a shoe retailer uses data to inform the marketing plan for an upcoming summer sale

Which of the following examples describes using data to achieve business results? Select all that apply. 1. A large retailer performs data analysis on product purchases to create better promotions 2. A grocery chain collects data on sale items and pricing from each store 3. A video streaming service analyzes user preferences to customize movie recommendations 4. A movie theater tracker the number of weekend movie goers for three months

1. A large retailer performs data analysis on product purchases to create better promotions 3. A video streaming service analyzes user preferences to customize movie recommendations

A data analyst might use descriptive column headers in order yo achieve what goal? 1. Add context to their data 2. Filter the data 3. Protect the spreadsheet 4. Alphabetize the spreadsheet data

1. Add context to their data

A data analyst reframes a question. Then, they outline the problem, challenges, potential solutions, and timeframe. This is done to achieve what goals? Select all that apply. 1. Balance speed with accuracy 2. Put the data in context, and find the story it's telling 3. Provide reports immediately to keep stakeholders happy 4. Communicate expectations so stakeholders understand how long it will take to provide accurate information

1. Balance speed with accuracy 2. Put the data in context, and find the story it's telling 4. Communicate expectations so stakeholders understand how long it will take to provide accurate information

Describe the key difference between the problem types of categorizing things and identifying themes. 1. Categorizing things involves assigning item to categories. Identifying themes takes those categories a step further, grouping them into broader themes 2. Categorizing things involves taking inventory of items. Identifying themes deals with creating labels for items 3. Categorizing things involves assigning grades to items. Identifying themes involves creating new classifications for items 4. Categorizing thing involves determining how items are different from each other. Identifying themes brings different items back together in a single group

1. Categorizing things involves assigning item to categories. Identifying themes takes those categories a step further, grouping them into broader themes

Asking questions including, "Does my analysis answer the original question?" and "Are there other angles I haven't considered?" enable data analysts to accomplish what tasks? Select all that apply. 1. Consider the best way to share data with others 2. Help their team make informed, data-driven decisions 3. Use data to get to a solid conclusion 4. Identify primary and secondary stakeholders

1. Consider the best way to share data with others 2. Help their team make informed, data-driven decisions 3. Use data to get to a solid conclusion

When starting a new data analysis project, setting expectations for a realistic timeline might involve which of the following? Select all that apply. 1. Creating a schedule with project phases and their approximate start dates 2. Sharing a high-level schedule with stakeholders so they can plan accordingly 3. Communicating clearly with the project manager and other team members 4. Assuring stakeholders that you'll have the project done right away

1. Creating a schedule with project phases and their approximate start dates 2. Sharing a high-level schedule with stakeholders so they can plan accordingly 3. Communicating clearly with the project manager and other team members

Describe the difference between data and metrics. 1. Data is a collection of facts. Metrics are quantifiable data types used for measurement 2. Data is quantifiable. Metrics are unquantifiable 3. Data is quantifiable and used for measurement. Metrics are unorganized collections of facts 4. Data can be used for measurement. Metrics cannot be used for measurement

1. Data is a collection of facts. Metrics are quantifiable data types used for measurement

Within a spreadsheet, data analysts use which tools to save time and effort by automating commands? Select all that apply. 1. Formulas 2. Filters 3. Tables 4. Functions

1. Formulas 4. Functions

To communicate clearly with stakeholders and team members, there are four key questions data analysts ask themselves. The first is: Who is my audience? Identify the remaining three questions. Select all that apply. 1. How can I communicate effectively to my audience? 2. Why are stakeholders and team members important? 3. What does my audience already know? 4. What does my audience need to know?

1. How can I communicate effectively to my audience? 3. What does my audience already know? 4. What does my audience need to know?

The question, "Why don't our employees complete their timesheets each Friday by noon?" is not action-oriented. Which of the following questions are action-oriented and more likely to lead to change? Select all that apply. 1. How could we simplify the time-keeping process for our employees? 2. What features could we add to our calendar app as a weekly timesheet reminder to employees? 3. What functionalities would make our timesheet web page more user-friendly? 4. Why don't employees prioritize filling out their timesheets by noon on Friday?

1. How could we simplify the time-keeping process for our employees? 2. What features could we add to our calendar app as a weekly timesheet reminder to employees? 3. What functionalities would make our timesheet web page more user-friendly?

The question, "Why was the Monday afternoon yoga class successful?" is not measurable. Which of the following questions presents a measurable way to learn about the yoga class? 1. How many customers responded to our half-price yoga promotion? 2. Do yoga instructors seem more energetic at the beginning of the week? 3. Why do people like taking yoga classes on Mondays? 4. Is yoga a great way to stretch and strengthen your body?

1. How many customers responded to our half-price yoga promotion?

Which of the following examples are leading questions? Select all that apply. 1. How satisfied were you with our customer representative? 2. What do you enjoy most about our service? 3. In what ways did our product meet your needs? 4. How did you learn about our company?

1. How satisfied were you with our customer representative? 2. What do you enjoy most about our service? 3. In what ways did our product meet your needs?

Focusing on stakeholder expectations enables data analysts to achieve what goals? Select all that apply. 1. Improve communication among teams 2. Understand project goals 3. Multitask more effectively 4. Build trust

1. Improve communication among teams 2. Understand project goals 4. Build trust

Which of the following questions make assumptions? Select all that apply? 1. Keeping employees engaged is important, isn't it? 2. Wouldn't you agree that product A is better than product B? 3. Did you get through to customer service? 4. It must be frustrating waiting on hold for so long, right?

1. Keeping employees engaged is important, isn't it? 2. Wouldn't you agree that product A is better than product B? 4. It must be frustrating waiting on hold for so long, right?

A data analyst is working for a local power company. Recently, many new apartments have been built in the community, so the company wants to determine how much electricity it needs to produce for the new residents in the future. A data analyst uses data to help the company make a more informed forecast. This is an example of which problem type? 1. Making predictions 2. Spotting something unusual 3. Discovering connections 4. Identifying themes

1. Making predictions

In which step of the data analysis process would an analyst ask questions such as, "What data errors might get in the way of my analysis?" or "How can i clean my data so the information I have is consistent?" 1. Process 2. Analyze 3. Ask 4. Prepare

1. Process

A stakeholder has asked a data analyst to produce a report very quickly. What are some strategies the analyst can apply to ensure their work isn't rushed, answers the right question, and delivers useful results? Select all that apply. 1. Reframe the question 2. Work overtime to get the report done by the following day 3. Outline the problem 4. Set clear expectations about timeframe

1. Reframe the question 3. Outline the problem 4. Set clear expectations about timeframe

A pivot table is a data-summarization tool used in data processing. Which of the following tasks can pivot tables perform? Select all that apply. 1. Reorganize data 2. Calculate totals from data 3. Group data 4. Clean data

1. Reorganize data 2. Calculate totals from data 3. Group data

You receive an angry email from a colleague on the marketing team. The marketing colleague believes you have taken credit for their work. You do not believe this is true. Select the best course of action. 1. Reply to the email, asking if they can schedule a time to talk about this in person in order to allow both of you to share your perspectives 2. Walk over to the marketing colleague's cubicle, and tell them you strongly disagree 3. Forward the email to the marketing director with an equally angry note 4. Delete the email. It's best not to create any additional conflict

1. Reply to the email, asking if they can schedule a time to talk about this in person in order to allow both of you to share your perspectives

A metric is a single, quantifiable type of data that can be used for what task? 1. Setting and evaluating goals 2. Sorting and filtering data 3. Defining a problem type 4. Cleaning data

1. Setting and evaluating goals

The share phase of the data analysis process typically involves which of the following activities? Select all that apply. 1. Summarizing results using data visualizations 2. Creating a slideshow to present to stakeholders 3. Putting analysis into action to solve a problem 4. Communicating findings

1. Summarizing results using data visualizations 2. Creating a slideshow to present to stakeholders 4. Communicating findings

A time-bound SMART question specifies which of the following parameters? 1. The era, phase, or period of analysis 2. The metrics or measures related to the analysis 3. The desired change the analysis should produce 4. The topic or subject of the analysis

1. The era, phase, or period of analysis

A data analyst working for a mid-sized retailer is writing questions for a customer experience survey. One of the questions is: "Do you prefer online or in-store?" Then, they rewrite it to say: "Do you prefer shopping at our online marketplace or shopping at your local store?" Describe why this is a more effective question. 1. The first question is vague, whereas the second question includes important context 2. The first question contains slang that might not make sense to everyone, whereas the second question is easily understandable 3. The first question is closed-ended, whereas the second question encourages the respondent to elaborate 4. The first question is leading, whereas the second question could have many different answers

1. The first question is vague, whereas the second question includes important context

A data analyst at a delivery company is working on a logistics project. The goal is to use data to create more efficient routes so trucks travel fewer miles on the road when delivering parcels to customers. Who is the primary stakeholder most likely to be? 1. The vice president of logistics 2. The lead delivery truck driver 3. The customer 4. The data analyst

1. The vice president of logistics

A data analyst is using data from a short time period to solve a problem related to someone's day-to-day decisions. They are most likely working with small data. 1. True 2. False

1. True

In a formula, the plus sign (+) is the operator for addition, and the hyphen (-) is the operator for subtraction. 1. True 2. False

1. True

Structured thinking involves recognizing the current problem or situation you're facing and identifying your options. 1. True 2. False

1. True

A colleague sent you a question via email nearly two days ago. You know it's going to take a while for you to find the answer because you need to do some research first. You're too busy to get it done today. What's the best course of action? 1. Delete the email. By the time you're able to answer the question, it won't be helpful information anyway 2. Reply with a quick update thanking the sender for their patience and letting them know when they can expect you to respond with the answer to their question 3. Respond right away with you best guess to the answer of their question. The sender has been waiting nearly 48 hours, and any response is better than nothing 4. Forward the email to the entire data analytics team, and ask if someone else can answer the question for you

2. Reply with a quick update thanking the sender for their patience and letting them know when they can expect you to respond with the answer to their question

Describe the key differences between small data and big data. Select all that apply. 1. Small data is typically stored in a database. Big data is typically stored in a spreadsheet 2. Small data involves datasets concerned with a small number of specific metrics. Big data involves datasets that are larger and less specific 3. Small data is effective for analyzing day-to-day decisions. Big data is effective for analyzing more substantial decisions 4. Small data focuses on short, well-defined time periods. Big data focuses on change over a long period of time

2. Small data involves datasets concerned with a small number of specific metrics. Big data involves datasets that are larger and less specific 3. Small data is effective for analyzing day-to-day decisions. Big data is effective for analyzing more substantial decisions 4. Small data focuses on short, well-defined time periods. Big data focuses on change over a long period of time

Which of the following examples would be determined using qualitative data? 1. The frequency of hurricanes per year in Louisiana 2. The most well-liked make and model of car in Puerto Rico 3. The annual rainfall in Costa Rica 4. The number of commuters who takes the train to work

2. The most well-liked make and model of car in Puerto Rico

Which of the following is an example of small data? 1. The bed occupancy rate for a hospital for the past decade 2. The number of steps someone walks in a day 3. The total absences of all high school students 4. The trade deficit between two countries over a hundred years

2. The number of steps someone walks in a day

Marketing analytics is the process of measuring, analyzing, and managing a company's marketing strategy and budget. Often, this involves identifying the company's target audience. The target audience includes which people? 1. The people who hold a stake in the marketing analytics project 2. The people the company is trying to reach 3. The people most likely to listen to podcasts 4. The people on your marketing analytics team

2. The people the company is trying to reach

What is an example of using metric? Select all that apply. 1. Using a pie chart to visualize data 2. Using key performance indicators, such as click-through rates, to measure revenue 3. Using annual profit targets to set and evaluate goals 4. Using column headers to sort and filter data

2. Using key performance indicators, such as click-through rates, to measure revenue 3. Using annual profit targets to set and evaluate goals

Organizing available information and revealing gaps and opportunities are part of what process? 1. Applying the SMART methodology 2. Using structured thinking 3. Categorizing things 4. Identifying connections between two or more things

2. Using structured thinking

A data analyst has entered the analyze step of the data analysis process. Identify the questions they might ask during this phase. Select all that apply. 1. How can I create an engaging presentation to stakeholders? 2. What story is my data telling me? 3. What is the question I'm trying to answer? 4. How will my data help me solve this problem?

2. What story is my data telling me? 4. How will my data help me solve this problem?

A metric goal is a _____ goal set by a company that is evaluated using metrics. 1. conceptual 2. measurable 3. theoretical 4. finite

2. measurable

The spotting something unusual problem type could involve which of the following scenarios? 1. A data analyst at an arts nonprofit classifies similar data points into groups for further analysis 2. A data insight helps a landscaping company envision what will happen in the future 3. A data analyst working for an agricultural company examines why a dataset has a surprising and rare data point 4. A data analyst at a clothing retailer creates a list of common topics, categorizes them, and groups each category into a broader subject area for further analysis

3. A data analyst working for an agricultural company examines why a dataset has a surprising and rare data point

Which of the following statements describes an algorithm? 1. A technique for focusing on a single topic or a few closely related ideas 2. A tool that enables data analysts to spot something unusual 3. A process or set of rules to be followed for a specific task 4. A method for recognizing the current problem or situation and identifying the options

3. A process or set of rules to be followed for a specific task

A dashboard would be most beneficial for which of the following scenarios? 1. An analyst needs a summary of data upon request 2. A consultant needs all historical data for an audit 3. A project manager needs to monitor data as it becomes available 4. A cross functional team needs an ad-hoc update

3. A project manager needs to monitor data as it becomes available

A data analyst uses the SMART methodology to create a question that encourages change. This type of question can be described how? 1. Motivational 2. Stimulating 3. Action-oriented 4. Results-focused

3. Action-oriented

A data analyst identifies and classifies keywords from customer reviews to improve customer satisfaction. This is an example of which problem type? 1. Spotting something unusual 2. Making predictions 3. Categorizing things 4. Finding patterns

3. Categorizing things

In data analytics, how are dashboards different from reports? 1. Dashboards provide a high-level presentation of historical data. Reports provide a more detailed presentation of live, interactive data 2. Dashboards contain static data. Reports contain data that is constantly changing 3. Dashboards monitor live, incoming data from multiple datasets and organize the information into one central location. Reports are static collections of data 4. Dashboards are used to share updates with stakeholders only periodically. Reports give stakeholders continuous access to data

3. Dashboards monitor live, incoming data from multiple datasets and organize the information into one central location. Reports are static collections of data

In spreadsheets, what is the term for the symbols used in formulas to perform a specific calculation? 1. Attributes 2. Tables 3. Operators 4. References

3. Operators

A garden center wants to attract more customers. A data analyst in the marketing department suggests advertising in popular landscaping magazines. This is an example of what practice? 1. Collecting customer information 2. Monitoring social media feedback 3. Reaching your target audience 4. Developing a data analytics case study

3. Reaching your target audience

The human resources director approaches a data analyst to propose a new data analysis project. The analyst has a lot of experience in human resources and believes the director is taking the wrong approach, and it will lead to some problems. Select the data analyst's best course of action. 1. Tell the director that they're very sorry, but they can't work on the project 2. Politely explain that they're too busy to take on another project at this time 3. Respectfully explain their viewpoints and offer the director some additional information to help improve the project 4. Complete the project as requested, but set aside some time in the future to fix the problems that are sure to come up

3. Respectfully explain their viewpoints and offer the director some additional information to help improve the project

To make sure that a few unusual responses don't skew results or lead to inaccurate judgements, a data analyst focuses on what element of the data collection? 1. Statistical significance 2. Data cleaning 3. Sample size 4. Visualization

3. Sample size

Describe the main differences between big and small data. 1. Small data is typically stored and organized in databases. Big data is typically stored and organized in spreadsheets 2. Small data has been cleaned and sorted. Big data has not yet been cleaned or sorted 3. Small data is specific and concerns a short time period. Big data is less specific and concerns a longer time period 4. Small data is less useful to data analysts. Big data is more useful to data analysts

3. Small data is specific and concerns a short time period. Big data is less specific and concerns a longer time period

While considering a research question, a data analyst follows the SMART methodology. They limit their analysis to include data from July 2012 to August 2012. What component of the SMART framework describes this decision? 1. Topical 2. Targeted 3. Time-bound 4. Thoughtful

3. Time-bound

The finding patterns problem type could involve which of the following actions? 1. Reviewing sales data and noticing that a random Tuesday in August had the highest sales last year 2. Collaborating with a supplier to discover that bad weather is the most common reason for late deliveries 3. Using historical data to create a report that shows when batteries have been replaced on critical equipment 4. Reviewing social media reviews to identify common phrases, categorize them, and group each category into a broader theme

3. Using historical data to create a report that shows when batteries have been replaced on critical equipment

You are working with spreadsheet data about a cross-country relay race. Each runner's times are located in cells H2 through H28. To find the runner with the slowest time, what is the correct function? 1. =LOW(H2:H28) 2. =HIGH(H2-H28) 3. =MIN(H2-H28) 4. =MAX(H2:H28)

4. =MAX(H2:H28)

What do data analysts use to label the type of data contained in each column in a spreadsheet? 1. Menus 2. Tables 3. Headings 4. Attributes

4. Attributes

In a spreadsheet, a formula should always start with which of the following operators? 1. Plus-minus (±) 2. Colon (:) 3. Dash (—) 4. Equal sign (=)

4. Equal sign (=)

On a customer service questionnaire, a data analyst asks, "If you could contact our customer service department via chat, how much valuable time would that save you?" Why is this question unfair? 1. It is vague 2. It is closed-ended 3. It uses slang words that not everyone can understand 4. It makes assumptions

4. It makes assumptions