Question 1

Mary has been tasked with reviewing a large data file. She wants to begin by first inspecting the number of values in each cell, both numeric and non-numeric, for any blank entries. The plan is to first find the blank or missing values for first review. Using Excel, what function(s) should she use to complete this task?

Accepted Answer

A)   COUNT
B)   COUNTA
C)   COUNTIF
D)   Both COUNT and COUNTA D

Question 2

To view only a portion of the data that is of interest, subsetting is used.

Accepted Answer

A) True 
 B)False  True

Question 3

Henry wants to analyze income, but the sheer number of categories in the data's current form will make a clear analysis less meaningful. In Excel with Analytic Solver, how will Henry determine the frequency of each category to transform his data?

Accepted Answer

A)   Income variable is selected and Analytic solver produces frequency levels for each income category from most to least frequent.
B)   Inspect the frequency of Income category: >table(myData$Income) .
C)   Income variable is selected and Analytic Solver produces a new category for non-use variables.
D)   Apply a limit to the number of categories from the drop-down to a reasonable number. A

Question 4

The following table contains 2 variables with 2 observations. A new variable was created named Sum. This is the sum of the values x1 and x2 for each observation. What is the average value of Sum if the chart was completed?

Accepted Answer

A)   106
B)   53
C)   98
D)   114

Question 5

In a data set with 18 variables, if 11% of the values, randomly spread across observations, are missing (blank), what is the probable percent of complete and usable observations?

Accepted Answer

A)   89%
B)   11%
C)   12.27%
D)   7.70%

Question 6

Molly wants to view observations with missing values in Inventory. However, her data set is quite large. What functions should she use to complete her task in R?

Accepted Answer

A)   > is.na (myData.Inventory) 
B)   > is.na (myData$Inventory) 
C)   > which (is.na(myData$Inventory) ) 
D)   > which (is.na(myData.Inventory) )

Question 7

Mary in the accounting department has been assigned a specific vehicle as her company car to perform audits. This represents which type of relationship?

Accepted Answer

A)   1 : 1
B)   1 : M
C)   M : N
D)   M : M

Question 8

Using the omission strategy, what value would be placed in the missing observation in x1?

Accepted Answer

A)   No value because excluded
B)   87
C)   85
D)   69

Question 9

The following table contains 2 variables with 2 observations. A new variable was created named Sum. This is the sum of the values x1 and x2 for each observation. What is the average value of Sum if the chart was completed?

Accepted Answer

A)   120
B)   67
C)   112
D)   128

Question 10

Michael is examining a data set and trying to determine which category he can transform into a dummy variable. Of the four variables, Employee Number, Pay Rate, Hire Date, and Sex, which is the best fit to use a dummy variable?

Accepted Answer

A)   employee number
B)   pay rate
C)   hire date
D)   sex

Question 11

The function that provides a natural logarithm in Excel is?

Accepted Answer

A)   The INT function
B)   The LN function
C)   The YEARFRAC function
D)   The VLOOKUP function

Question 12

Converting data from one structure to another is called data transformation.

Accepted Answer

A) True 
 B)False

Question 13

Using the simple mean imputation strategy, what value would be placed in the missing observation in x1?

Accepted Answer

A)   17
B)   84
C)   83
D)   90

Question 14

Using the following table view, Mark wants to create a relationship between the two tables. What will he need to add to establish a relationship?

Accepted Answer

A)   primary key
B)   foreign key
C)   instances
D)   entities

Question 15

In Analytic Solver, Aimee is trying to create a new column called RFM. This column is merging multiple values into one cell. The function to accomplish this is called?

Accepted Answer

A)   TRANSFORM
B)   CONCATENATE
C)   VARIABLE
D)   VLOOKUP

Question 16

Mark wants to have a better understanding of his client base at the credit union. To do so, he is running a report to show loan amount approval with corresponding credit scores. He realized the data set is quite large and wants to create categories by grouping. To do this, he needs to do all the following except

Accepted Answer

A)   identify the value he wants to transform into smaller groups or bins.
B)   remove 20% of the data to create a training set.
C)   ensure the data sets are not overlapping.
D)   identify how he wants the observations to be labeled in the bin.

Question 17

Using R, what is the formula that will allow for the weekday function to display the day of the week for November 15, 2020?

Accepted Answer

A)   >weekdays< (as.Date("2020-11-15") 
B)   > format(as.Date("2020-11-15") , "%d") 
C)   > weekdays(as.Date("2020-11-15") ) 
D)   > Sys.Date("2020-11-15")

Question 18

In R, Mary wants to understand the number of days between rain events in Chicago, IL. What function is used to find the number of rain events between today and January 1, 2019?

Accepted Answer

A)   difftime
B)   as.numeric
C)   diffdate
D)   floor

Question 19

Transform the marital status into category scores where Single = 1 and Married = 0. How many would have the category score of 0?

Accepted Answer

A)   1
B)   6
C)   3
D)   0

Question 20