the varname workbook, which you will use to find your variables of interest and understand their structure.

INSTRUCTIONS TO CANDIDATES

ANSWER ALL QUESTIONS

 

Assignment #1 – Statistical software cheat sheet

 Download the dataset

Depending on your disease of interest and preferred software, you should download:

Software	Pneumonia	Diarrhea
MS Excel	Workshop_BDA_COI_pneumonia.xlsx	Workshop_BDA_COI_diarrhea.xlsx
Stata 12+	Workshop_BDA_COI_pneumonia.dta	Workshop_BDA_COI_diarrhea.dta
R	Workshop_BDA_COI_pneumonia.csv	Workshop_BDA_COI_diarrhea.csv
Any other	Workshop_BDA_COI_pneumonia.csv	Workshop_BDA_COI_diarrhea.csv

 As well as the varname workbook, which you will use to find your variables of interest and understand their structure.

 

Pneumonia	Diarrhea
Workshop_BDA_COI_pneumonia_varnames.xlsx	Workshop_BDA_COI_diarrhea_varnames.xlsx

 MS Excel

 

Use pivot tables and apply filters for sector, type of visit, etc.

 

Stata 12+

Parts 1 & 2: Household and government costs

To generate a table of average costs by type of visit and sector:

by visit_type facility_sector, sort: ci …COST VARIABLES…    (Stata 12-13) or
by visit_type facility_sector, sort: ci means …COST VARIABLES… (Stata 14+)

 Example:

by visit_type facility_sector, sort: ci consult_1 diagnos_1 medic_1 bed_1 food_1 others_1 consult_2 diagnos_2 medic_2 bed_2 travel_2 food_2 others_2 consult_3 diagnos_3 medic_3 bed_3 travel_3 food_3 others_3 total_dmc total_nmc total_indirectcost total_overallcost timelossdays_main timelosshours_main

 

Part 3: Societal cost

To calculate/generate a new variable (calculation provided as example):

gen NEW_VARNAME = VARNAME_1 + (VARNAME_2 – VARNAME_3) / 12

To replace missing observations (*) with a value (here, zero):

replace NEW_VARNAME = 0 if NEW_VARNAME == * (NEW_VARNAME must exist already)

 

Attachments:

Expert's Answer

1545 Times Downloaded

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