analyze data to answer questions weekly challenge 1
1. What is the goal of the analysis phase of the data analysis process?
- To describe data structures
- To generate new data
- To identify trends and relationships in data
- To make generalizations about data
2. During which of the four phases of analysis do you compare your data to external sources?
- Format and adjust data
- Transform data
- Get input from others
- Organize data
3. Which of the following actions might occur when transforming data? Select all that apply.
- Identify a pattern in your data
- Make calculations based on your data
- Recognize relationships in your data
- Eliminate irrelevant info from your data
4. Typically, a data analyst uses filters when they want to expand the amount of data they are working with.
- True
- False
5. A data analyst is sorting data in a spreadsheet. They select a specific collection of cells in order to limit the sorting to just specified cells. Which spreadsheet tool are they using?
- Sort Sheet
- Sort Range
- Limit Sort
- Limit Range
6. A data analyst sorts a spreadsheet range between cells D5 and M5. They sort in descending order by the third column, Column F. What is the syntax they are using?
- =SORT(D5:M5, C, TRUE)
- =SORT(D5:M5, 3, FALSE)
- =SORT(D5:M5, C, FALSE)
- =SORT(D5:M5, 3, TRUE)
7. You are querying a database that contains data about music. Each musical genre is given an ID number. You are only interested in data related to the genre with ID number 7. The genre IDs are listed in the genre_id column.
You write the SQL query below. Add a WHERE clause that will return only data about the genre with Id number 7.
Who is the composer listed in row 4 of your query result?
- Caetano Veloso
- Marisa Monte
- Lulu Santos
- Gilberto Gil
8. You are working with a database that contains invoice data about online music purchases. You are only interested in invoices sent to customers located in the city of Delhi. You want to sort the invoices by order total in ascending order. The order totals are listed in the total column.
You write the SQL query below. Add an ORDER BY clause that will sort the invoices by order total in ascending order.
What total appears in row 4 of your query result?
- 1.98
- 5.94
- 8.91
- 3.96
Shuffle Q/A 1
9. Fill in the blank: The _____ phase of the data analysis process includes organizing data, formatting and adjusting data, getting input from others, and transforming data by observing relationships between data points and making calculations.
- process
- prepare
- analyze
- act
10. During which of the four phases of analysis do you gather the relevant datasets into an usable structure for a project?
- Format and adjust data
- Get input from others
- Transform data
- Organize data
