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?

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

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?

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

Exam 2: Data Management and Wrangling

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?

Free

(Multiple Choice)

4.7/5

(38)

Question 1

Correct Answer:

Verified

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

Free

(True/False)

5.0/5

(38)

Question 2

Correct Answer:

Verified

True

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?

Free

(Multiple Choice)

4.8/5

(40)

Question 3

Correct Answer:

Verified

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

(Multiple Choice)

4.7/5

(24)

Question 4

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?

(Multiple Choice)

4.8/5

(34)

Question 5

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?

(Multiple Choice)

4.8/5

(39)

Question 6

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

(Multiple Choice)

4.9/5

(34)

Question 7

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

(Multiple Choice)

4.8/5

(41)

Question 8

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

(Multiple Choice)

4.9/5

(42)

Question 9

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?

(Multiple Choice)

4.7/5

(37)

Question 10

The function that provides a natural logarithm in Excel is?

(Multiple Choice)

4.8/5

(34)

Question 11

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

(True/False)

4.8/5

(44)

Question 12

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

(Multiple Choice)

4.9/5

(38)

Question 13

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?

(Multiple Choice)

4.8/5

(29)

Question 14

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?

(Multiple Choice)

4.8/5

(36)

Question 15

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

(Multiple Choice)

4.9/5

(42)

Question 16

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

(Multiple Choice)

4.7/5

(32)

Question 17

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?

(Multiple Choice)

4.8/5

(37)

Question 18

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

(Multiple Choice)

4.8/5

(28)

Question 19

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

(Multiple Choice)

5.0/5

(35)

Question 20

Showing 1 - 20 of 46

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

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?

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

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?

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?

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

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

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

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?

The function that provides a natural logarithm in Excel is?

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

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

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?

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?

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

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?

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

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

Introduction to Business Analytics

Data Visualization and Summary Measures

Probability and Probability Distributions

Statistical Inference

Regression Analysis

Advanced Regression Analysis

Introduction to Data Mining

Supervised Data Mining: K-Nearest Neighbors and Naãve Bayes

Supervised Data Mining: Decision Trees

Unsupervised Data Mining

Forecasting With Time Series Data

Introduction to Prescriptive Analytics

Filters

Exam 2: Data Management and Wrangling

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

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?

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?

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?

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?

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

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

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?

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?

The function that provides a natural logarithm in Excel is?

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

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

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?

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?

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

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?

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

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

Introduction to Business Analytics

Data Visualization and Summary Measures

Probability and Probability Distributions

Statistical Inference

Regression Analysis

Advanced Regression Analysis

Introduction to Data Mining

Supervised Data Mining: K-Nearest Neighbors and Naãve Bayes

Supervised Data Mining: Decision Trees

Unsupervised Data Mining

Forecasting With Time Series Data

Introduction to Prescriptive Analytics

Filters

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

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

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

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

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