file link https://docs.google.com/spreadsheets/d/1j9xh4jWQ_lO51HLDze2gfcn3XD2Vg76g/edit?usp=sharing&ouid=117894095983827427618&rtpof=true&sd=true

Q01. Use "preprocessing.xlsx" file for this assessment. The order of variables in this file is: ID, X, Y, Z, Group. Open this sample data file in Excel and perform the following operations in the sequence in which they are listed below. How many cases have missing values on variables X, Y and Z but do not have a missing value for Group?

Group of answer choices

4

1223

7

19

Flag question: Question 2Question 22 pts

Q02. What is the sum of relative frequencies of Groups A and B in the full sample of 2,000 observations (ignoring cells with missing values)?

Group of answer choices

0.14

113

0.13

256

Q03. Replace missing values on a variable by the average of all available values on that variable. For average use the arithmetic mean for quantitative variables, and median for Group (order of values: A, B, C). After replacement of all missing values what Group does observation#49 (ID = 49) belong to?

Group of answer choices

A

B

C

None of the above