Wiley chapter 2

Question 1

Which of the following is best defined as a measure of dispersion

Answer 1

variance

Question 2

Most of the data you will work with will come from

Answer 2

relational databases

Question 3

Questions with single dimensions should be answered with pivot tables, questions with multiple dimensions should be answered with excel functions.

Answer 3

False

Question 4

Database elements can be represented in the REA model, the model’s elements are..

Answer 4

resources, events, agents

Question 5

Which of the following is NOT one of the basic excel functions used in foundational analysis

Answer 5

DISPLAYIF

Question 6

In a relational database table, a primary key is

Answer 6

is a unique value

Question 7

A __________ is a bar chart of frequency distributions where the height of the bar represents the count of items in the interval

Answer 7

histogram

Question 8

There are 4 types of joins used to link tables together, which type of join DOES NOT result in any null values being produced?

Answer 8

Inner

Question 9

Simultaneously filtering for multiple dimensions is called

Answer 9

data slicing

Question 10

An action request made to a database is called a(n)

Answer 10

query