The accompanying data set contains seven variables, x 1 , x 2 , x 3 , x

Question:

The accompanying data set contains seven variables, x1, x2, x3, x4, x5, x6, and x7. There are missing values in the data set.

a. Remove variables x2, x6, and x7 from the data set. Which of the remaining variables have missing values?

b. Which observations have missing values?

c. How many missing values are in the data set?

d. If there are missing values in x1, replace the missing values with “Unknown.” How many missing values were replaced?

e. Handle the missing values for numerical variables using the imputation strategy. If there are missing values in x3, impute the missing values using the mean value of x3. If there are missing values in x4, impute the missing values using the median value of x4. If there are missing values in x5, impute the missing values using the mean value of x5. What are the average values of x3, x4, and x5 after imputation?

f. Remove observations that have the value “F” for x1 and values lower than 1,020 for x4. How many observations remain in the data set?

Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Related Book For  book-img-for-question

Business Analytics Communicating With Numbers

ISBN: 9781260785005

1st Edition

Authors: Sanjiv Jaggia, Alison Kelly, Kevin Lertwachara, Leida Chen

Question Posted: