Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Consider the following data. Score1: 90 80 70 65 95 . 77 Score2: 80 90 60 70 60 88 . Income: 95 79 74 88

Consider the following data. Score1: 90 80 70 65 95 . 77 Score2: 80 90 60 70 60 88 . Income: 95 79 74 88 85 50 . Gender: f m m f f m f Write a program to do the following. 1. Using data above, create a data set. 2. Create MS1: = score1 if not missing; =.5 of score2 if score1 is missing. 3. Create MS2: = score2 if not missing; =.5 of score1 if score2 is missing. 4. Create a new variable representing the mean of MS1 and MS2. Provide a summary for the newly created variable. 5. Create a variable representing the letter grade as follows: A if mean score greater or equal to 90; B if it is between 75 and 90; C if between 60 and 75; F if less than 60. Provide a summary of the newly created variable. 6. Create IM: = income if income not missing; =0 if income is missing. Provide a summary for the new variable. 7. Create a new variable representing the level of income (=IM) as follows: H if income is above 90; M if it is between 40 and 90; L if it is lower than 40. Provide a summary for the new variable.

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

Formal SQL Tuning For Oracle Databases Practical Efficiency Efficient Practice

Authors: Leonid Nossov ,Hanno Ernst ,Victor Chupis

1st Edition

3662570564, 978-3662570562

More Books

Students also viewed these Databases questions

Question

Question Can any type of stock or securities be used in an ESOP?

Answered: 1 week ago

Question

Question Can a self-employed person adopt a money purchase plan?

Answered: 1 week ago