Quiz Questions

What is the term for the set of cells that a data analyst selects to include in a formula?

Data Range

In a spreadsheet, a formula should always start with which of the following operators?

Equal sign =

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?

How many customers responded to our half-priced yoga promotion.

Fill in the blank: A _____ goal is measurable and evaluated using single, quantifiable data.

Metric

Fill in the blank: Data-inspired decision-making can discover _____ when exploring different data sources.

What the data has in common

What is the correct spreadsheet formula for multiplying cell D5 times cell D7?

=D5*D7

TRUE or 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.

False

A recycling center that sponsors a podcast about saving the environment is an example of what strategy

Trying to reach a target audience

Fill in the blank: If a data analyst is measuring qualities and characteristics, they are considering _____ data.

Qualitative

What is the difference between qualitative and quantitative data?

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

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.

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

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?

Structured Thinking

TRUE or FALSE: In a formula, the plus sign (+) is the operator for addition, and the hyphen (-) is the operator for subtraction.

True

Organizing available information and revealing gaps and opportunities are part of what process?

Using Structured thinking

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

-Asterisk (*) -Forward slash (/) -Hyphen (-)

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

-Organizing available information -Recognizing the current problem or situation -Revealing gaps and opportunities in order to identify the options

Fill in the blank: In spreadsheets, data analysts begin _____ with an equal sign (=)

Formulas

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?

Prepare

A time-bound SMART question specifies which of the following parameters?

The era, phase, or period of analysis

What do data analysts use to label the type of data contained in each column in a spreadsheet?

Attributes

TRUE or FALSE: Questions that make assumptions often involve concepts that are formed without evidence. An example of this is an idea that is accepted as true without proof.

True

A data analyst uses the SMART methodology to create a question that encourages change. This type of question can be described how?

Action oriented

TRUE or FALSE: To determine an organization's annual budget, a data analyst might use a slideshow

False: Spreadsheet

Your supervisor gives you a new data analysis project with unclear instructions, and you become frustrated trying to figure out how to proceed. Which actions you can take next demonstrate a responsibility to move the project forward? Select all that apply. -Find your supervisor in person so they can clearly observe how frustrated you are. -Do some additional research to better understand the context of the request. -Send your supervisor an email letting them know they did not explain the project well. -Schedule a time to ask your supervisor more questions about the big picture goals.

-Do some additional research to better understand the context of the request. -Schedule a time to ask your supervisor more questions about the big picture goals.

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. -How will my data help me solve this problem? -What story is my data telling me? -How can I create an engaging presentation to stakeholders? -What is the question I'm trying to answer?

-How will my data help me solve this problem? -What story is my data telling me?

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

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

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

-Share customer feedback -Compile information about customer expectations

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

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

Data analysts pay attention to sample size in order to achieve what goals? Select all that apply. -To make sure the data represents a diverse set of perspectives -To make sure a few unusual responses don't skew results -To fully understand the scope of the analytics project -To avoid a small sample size leading to inaccurate judgements

-To make sure the data represents a diverse set of perspectives -To make sure a few unusual responses don't skew results -To avoid a small sample size leading to inaccurate judgements

Which of the following are ways that data analysts can add context to their data? Select all that apply. -Use descriptive column headers -Ask questions about the data -Consider where the data came from -Create reports for stakeholders

-Use descriptive column headers -Ask questions about the data -Consider where the data came from

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

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

Fill in the blank: By negatively influencing data collection, ____ can have a detrimental effect on analysis.

Bias

A data analyst identifies and classifies keywords from customer reviews to improve customer satisfaction. This is an example of which problem type?

Categorizing things

Describe the key difference between the problem types of categorizing things and identifying themes.

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

Fill in the blank: Return on investment compares the _____ of an investment to the net profit gained from that investment.

Cost

At an online marketplace, the _____ includes anyone in an organization who interacts with current or potential shoppers

Customer facing team

A director emails you asking for a report by the end of the week. This type of report takes at least 10 days to complete correctly. What is the best course of action?

Email the director and say that you would be happy to do that, but you believe it will take 10 days to get the information you need. Then, ask if you can discuss the possibility of a different timeline.

TRUE or FALSE: 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.

False

TRUE or FALSE: 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.

False

TRUE or FALSE: In data analytics, reports use live, incoming data from multiple datasets; dashboards use static collections of data.

False

TRUE or FALSE: You're working on a data analysis project with a coworker, and the two of you disagree on what the data is telling you. Things get tense. The best course of action is to go to your supervisor and politely explain that your coworker is looking at the data incorrectly. Then, ask to work with a different coworker on future projects.

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?

Finding Patterns

Which of the following statements describes a key difference between formulas and functions? -Formulas contain words and numbers, and functions contain numbers only. -Formulas are used in graphs, and functions are not. -Formulas are written by the user, and functions are already defined. -Formulas span two or more cells, and functions exist in only one cell.

Formulas are written by the user, and functions are already defined

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?

Making Predictions

Fill in the blank: A scope of work is an agreed-upon _____ of the work you're going to perform on a project.

Outline

Question 4 Fill in the blank: A _____ is a data-summarization tool used to sort, reorganize, group, count, total, or average data

Pivot Table

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?"

Process

In the function =MAX(B5:B15), what does B5:B15 represent?

Range

A data analyst creates data visualizations and a slideshow. Which phase of the data analysis process does this describe?

Share

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.

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

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

The number of steps someone walks in a day

A data analyst considers who, what, when, where, why, and how in order to achieve what goal?

To put information into context.

TRUE or FALSE: 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.

True

TRUE or FALSE: If someone is subjectively describing their feelings or emotions, it is qualitative data.

True

TRUE or FALSE: In data analytics, a pattern is defined as a process or set of rules to be followed for a specific task.

False: Algorithm

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?

Stakeholders

A data analytics team is working on a project to measure the success of a company's new financial strategy. Select the person most likely to be the primary stakeholder for this project.

The VP of finance