Analyze Data to Answer Questions

Fill in the blank: A data analyst uses _____ to decide which data is relevant to their analysis and which data types and variables are appropriate.

database organization

You ask volunteers at a theater production which tasks they have already completed and add that data to a spreadsheet containing all required tasks. You will use the information provided by the volunteers to figure out which tasks still need to be done. This is an example of which phase of analysis?

Get input from others

An analyst uses =SORT to sort spreadsheet data in descending order. What do they type at the end of their sort function?

False

In spreadsheets, data analysts can sort a range from the Data tab in the menu or by typing a function directly into an empty cell.

True

You are working with a dataset from a local community college. You sort the students alphabetically by last name. This is an example of which phase of analysis?

Format and adjust data

Which spreadsheet menu function is used to sort all data in a spreadsheet by the ranking of a specific sorted column?

Sort Sheet

A data analyst wants to organize a database to show only the 100 most recent real estate sales in Stamford, Connecticut. How can they do that?

The data analyst should add a filter to return only sales in Stamford, Connecticut, then sort the most recent sales at the top of their list.

You are working with three datasets about voter turnout in your county. First, you identify relationships and patterns between the datasets. Then, you use formulas and functions to make calculations based on your data. This is an example of which phase of analysis?

Transform data