logo Hurry, Grab up to 30% discount on the entire course
Order Now logo

Ask This Question To Be Solved By Our ExpertsGet A+ Grade Solution Guaranteed

expert
Patrick GrahamEnglish
(5/5)

815 Answers

Hire Me
expert
StatAnalytica ExpertEconomics
(5/5)

709 Answers

Hire Me
expert
Mason RamirezzTechnical writing
(4/5)

913 Answers

Hire Me
expert
Deanna BradfordResume writing
(5/5)

860 Answers

Hire Me
STATA
(5/5)

What is the mean value of Median salary for Science graduates? What is it for non-Science graduates?

INSTRUCTIONS TO CANDIDATES
ANSWER ALL QUESTIONS

Homework 2

Homework 1 is due July 13th at 2:00 PM PDT through Canvas. This problem set is worth 50 points, which we will convert into 20% of your grade.

You will turn in (i) a write-up with answers to all problems, (ii) a well-commented Stata do file with the solutions for Q2 and Q3, and (iii) a log file generated when executing the do file. All the files should be named as LastName FirstName. There are graph questions in Q3. Include all the graphs in your write-up as graphics.

1. What will be the STATA output of the following commands: [7 X 2= 14 points]

(i) dis (21>12)

(ii) dis 21==12

(iii) dis 21 ! =12

(iv) dis (43+5 > 12) | (43 > 12-5)

(v) dis ((43+5 > 12) | (43 > 12-5)) & (12 >21 | 10>12 )

(vi) dis “2+2”

(vii) dis “2+2 =” 2+2

2. To answer the following questions, download the dataset named “recent grads.xls”. This dataset per- tains to information about various majors o↵ered in a university. It contains information on enrollment, employment/ unemployment rates and salaries of the graduates of respective majors. The data reports first quartile, third quartile and median of the salary distribution in each major.

Change the directory to where you can find your work. Answer the following questions based on this dataset. [22points]

(i) Import the dataset into stata and save it as a dta file. [1 points]

(ii) For this question, we only need variables Major code, Major, Total, Men, Women, Major category, ShareWomen, Unemployment rate, Median, P25th and P75th. Drop the data on all other vari- ables. [1 points]

(iii) What is the unit of analysis? [1 points]

(iv) Rename variables- Total, Men, Women and ShareWomen respectively as Enrollment Total, En- rollment Men, Enrollment Women and Share Women Enroll. [4 X 0.5= 2 points]

(v) Label the variable Share Women Enroll as share of women among total students enrolled. [1 points]

(vi) Create a new variable- IQ range that captures the Interquartile range (P75th- P25th). Label it as Interquartile Range. [2 X 1= 2 points]

(vii) What is the major for which Share Women Enroll is missing? [1 points]

(viii) How many Major categories are there in the dataset? [1 points]

(ix) Create a new variable- Science that takes the value 1 if major categories are Agriculture & Natural Resources, Biology & Life Science, Computers & Mathematics, Engineering, Physical Sciences and 0 for all other categories. [2 X 1= 2 points]

(x) What is the mean value of Median salary for Science graduates? What is it for non-Science graduates? [2 X 1= 2 points]

(xi) Calculate the average unemployment rate for Science graduates? What is it for non-Science graduates? [2 X 1= 2 points]

(xii) Which major o↵ers the highest Median salary? [1 points]

(xiii) Which major hosts the highest number of women as a fraction of its student body? [1 points]

(xiv) Is there any major for which share of women enrollees is no less than 70% and the unemployment rate is 2%? [1 points]

(xv) Debug the following codes, i.e, find and correct the mistake in the following codes: [3 X 1= 3 points]

i. tab Major category if Science= 1

ii. count if Major category == Engineering

iii. count if College jobs =! .

3. For this question, we will call up one of the in-built datasets in STATA. Please run the following com- mand in STATA:

sysuse auto.dta, clear

This dataset contains information about various features of cars manufactured in 1978. Answer the following questions based on this dataset. [5 X 2= 10 points]

(i) How many observations are there in this dataset? Identify the string variable in the dataset.

(ii) Draw a histogram of variable- price. Give it the title- “Distribution of price”. Overlay a kdensity function on it. Make sure that the bin size is 500

(iii) Now make a box plot of the variable- price over car type (foreign).

(iv) Draw a scatter plot of price (on y-axis) on mileage (on x-axis). Give it the title- “Price v/s Mileage”. Use red dots for domestic make and blue dots for foreign make.

(v) Draw a scatter plot of price (on y-axis) on mileage (on x-axis). Give it the title- “Price v/s Mileage”. Add the best fit line to the plot. Make sure you use blue-colored dots for scatter plot and red color for line.

4. Making Progress towards the Final Project: [2 X 2= 4 points] At this point in the course, we would like to make sure that you are thinking about your final project. The objective of this question is to have you suggest a source of data for your final project so we can give you feedback on the source and the question you might ask.

If you are having trouble finding a topic, feel free to draw inspiration from the given datasets and choose a dataset from here for your final project.

(a) Which dataset, from either the provided or your own research, are you interested in working on?

(b) What is the question you are interested in studying?

(5/5)
Attachments:

Related Questions

. The fundamental operations of create, read, update, and delete (CRUD) in either Python or Java

CS 340 Milestone One Guidelines and Rubric  Overview: For this assignment, you will implement the fundamental operations of create, read, update,

. Develop a program to emulate a purchase transaction at a retail store. This  program will have two classes, a LineItem class and a Transaction class

Retail Transaction Programming Project  Project Requirements:  Develop a program to emulate a purchase transaction at a retail store. This

. The following program contains five errors. Identify the errors and fix them

7COM1028   Secure Systems Programming   Referral Coursework: Secure

. Accepts the following from a user: Item Name Item Quantity Item Price Allows the user to create a file to store the sales receipt contents

Create a GUI program that:Accepts the following from a user:Item NameItem QuantityItem PriceAllows the user to create a file to store the sales receip

. The final project will encompass developing a web service using a software stack and implementing an industry-standard interface. Regardless of whether you choose to pursue application development goals as a pure developer or as a software engineer

CS 340 Final Project Guidelines and Rubric  Overview The final project will encompass developing a web service using a software stack and impleme