Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

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

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Differential Geometry And Continuum Mechanics

Authors: Gui Qiang G Chen, Michael Grinfeld, R J Knops

1st Edition

331918573X, 9783319185736

More Books

Students also viewed these Mathematics questions

Question

What is an audit and why is it important?

Answered: 1 week ago

Question

Behaviour: What am I doing?

Answered: 1 week ago