Week 1: Data types and structures
1. A data analyst at a book publisher is working on an urgent report for executives. They are using only historical data. What is the most likely reason for choosing to analyze only historical data?
- The project has a very short time frame
- The data is unknown
- There is plenty of time to research historical data
- The data is constantly changing
2. Which of the following are examples of discrete data? Select all that apply.
- Box office returns
- Movie running time
- Movie budget
- Number of actors in movie
3. Which of the following questions collects nominal qualitative data?
- Is this your first time dining at this restaurant?
- How many people do you usually dine with?
- How many times have you dined at this restaurant?
- On a scale of 1-10, how would you rate your service today?
4. Why is internal data considered more reliable and easier to collect than external data?
- Internal data circumvents privacy restrictions.
- Internal data comes from people you know.
- Internal data has much larger sample sizes.
- Internal data lives within a company’s own systems.
5. A social media post is an example of structured data.
- True
- False
6. Fill in the blank: A Boolean data type can have _____ possible values.
- three
- 10
- two
- infinite
7. The following is a selection from a spreadsheet:
What kind of data format does it contain?
- Short
- Wide
- Narrow
- Long
8. A data analyst is working in a spreadsheet application. They use Save As to change the file type from .XLS to .CSV. This is an example of a data transformation.
- True
- False
9. A data analyst is working on an urgent traffic study. As a result of the short time frame, which type of data are they most likely to use?
- Theoretical
- Historical
- Personal
- Unclean
10. Nominal qualitative data has a set order or scale.
- True
- False
11. Internal data is more reliable because it’s clean.
- True
- False
12. Structured data is likely to be found in which of the following formats? Select all that apply.
- Audio file
- Digital photo
- Spreadsheet
- Table
13. A Boolean data type must have a numeric value.
- True
- False
14. In long data, separate columns contain the values and the context for the values, respectively. What does each column contain in wide data?
- A specific constraint
- A specific data type
- A unique data variable
- A unique format
15. Fill in the blank: Data transformation enables data analysts to change the _____ of the data.
- value
- structure
- accuracy
- meaning
16. Continuous data is measured and has a limited number of values.
- True
- False
17. Which of the following values are examples of a Boolean data type? Select all that apply.
- True or false
- Yes, no, or unsure
- Yes or no
- One, two, or three
18. If you have a short time frame for data collection and need an answer immediately, you likely will have to use historical data.
- True
- False
19. Which of the following is an example of continuous data?
- Leading actors in movie
- Box office returns
- Movie run time
- Movie budget
20. Which of the following questions collect nominal qualitative data? Select all that apply.
- How likely are you to recommend this restaurant to a friend?
- Is this your first time dining at this restaurant?
- Have you heard of our frequent diner program?
- Did anyone recommend our restaurant to you today?
21. Data transformation can change the structure of the data. An example of this is taking data stored in one format and converting it to another.
- True
- False
22. Which of the following is a benefit of internal data?
- Internal data is less vulnerable to biased collection.
- Internal data is the only data relevant to the problem.
- Internal data is less likely to need cleaning.
- Internal data is more reliable and easier to collect.
23. Which of the following is an example of structured data?
- Audio file
- Relational database
- Video file
- Digital photo
24. The following is a selection from a spreadsheet:
What kind of data format does it contain?
- Wide
- Short
- Long
- Narrow