Course 2

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

Metric

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?

Reaching your target audience

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

Question 8 Describe the main differences between big and small data.

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

Fill in the blank: The labels that describe the type of data contained in each column of a spreadsheet are called

Attributes

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

Bias

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

Cost

Both formulas and functions in spreadsheets begin with what symbol?

Equals sign

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

False

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-price yoga promotion?

Which of the following examples are leading questions? Select all that apply.

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

Which of the following tasks might be performed using spreadsheets?

Maintain information about accounts

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

Qualitative

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

Range

Structured thinking involves which of the following processes?

Recognizing the Current Problem or situation Organizing available information Revealing gaps and opportunities

A metric is a single, quantifiable type of data that can be used for what task?

Setting and evaluating goal

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

Share

Formulas are created by the user, whereas functions are preset commands in spreadsheets.

True

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

What is the correct spreadsheet formula for multiplying cell H2 times cell H5?

=H2*H5

Which data-summarization tool do data analysts use to sort, reorganize, group, count, total, or average data?

A Pivot table

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

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

Which of the following statements describes an algorithm?

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

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.