Data Unit Flashcard

Front

A team of researchers wants to create a program to analyze the amount of pollution reported in roughly 3,000 counties across the United States. The program is intended to combine county data sets and then process the data. Which of the following is most likely to be a challenge in creating the program?

Back

Different counties may organize data in different ways.

Front

Which additional piece of information would be most useful in determining the artist with the greatest attendance during a particular month? Options: Average ticket price, Length of the show in minutes, Start time of the show, Total dollar amount of food and drinks sold during the show

Back

Average ticket price

Front

Which of the following can best be determined using only the data and none of the metadata?
- The average number of hours per day that the car is in use
- The car’s average speed on a particular day
- The distance the car traveled on a particular day
- The number of bicycles the car passed on a particular day

Back

The number of bicycles the car passed on a particular day

Front

Which of the following explains how the data files can be used to find the project due dates for the sales department? Options: First filter the Employees table to create a list of employees in the sales department, then use these employeeIDs to search the Projects table., First sort the Projects table by dueDate, then use these dates to search the Employees table., First search the Employees table for the sales department, then use these names to filter the Projects table., Filter the Projects table for the sales department.

Back

First filter the Employees table to create a list of employees in the sales department, then use these employeeIDs to search the Projects table.

Front

Which of the following can be used to find the Sci Fi book with the highest customer rating? Options: Sort the table by genre, then find the sum of the customer ratings. Filter the table by genre for "Sci Fi", then sort the table by customer rating. Search the Customer Ratings column for "Sci Fi" then sort the results. Filter the customer ratings for greater than 3 then sort the results by Title.

Back

Filter the table by genre for "Sci Fi", then sort the table by customer rating.

Front

Which of the following can be determined using only the information in the database?
· The item that was purchased most often on a particular date
· The customer who spent the most money on a particular date
· The average age of a customer who bought a particular item
· The city where the most customers live

Back

The customer who spent the most money on a particular date

Front

Scientist conducting a geological survey of an area collected the following data: Location, Elevation, Temperature, Soil Type. Which of the following could NOT be determined using only the information in these data? The average temperature for a certain soil type, Whether a certain soil type is more common at a certain elevation, What the most common soil type is for a certain location, Which temperature range has the highest moisture level.

Back

Which temperature range has the highest moisture level

Front

Given the data in the graph above, which person would you expect to have the highest score on level 6?

Back

Bob

Front

Which of the following graph most likely shows a correlation between the two variables?

Back