NGO Management and Policy Development · MSD2736

Comprehensive Statistics Using Stata

The course prepares students to utilize STATA, one of the most commonly used statistical analysis software packages, and develop a deeper understanding of econometrics.  This training specifically deals with management, analysis and graphing of quantitative data using STATA. The training combines theoretical foundations with methodological perspectives, aiming at equipping participants with knowledge on use of quantitative data in social research using STATA

Comprehensive Statistics Using Stata
Online fee from
$200 USD
Standard: $300 · Save $100
Course Outcomes

Expected learning outcomes

  • Generate variables that contain summaries of the data
  • Create a summary dataset using collapse
  • Navigate a dataset using _n, _N and subscripted variables
  • Rearrange a dataset using reshape
  • Combine multiple datasets using merge and append
  • Identify duplicate observations
  • Export data to a spreadsheet
  • Create tailor-made publication quality graphs
  • Understand what macros and scalars are
  • Be able to use foreach and forvalues loops
  • Understand and use if statements 
  • Understand how Stata stores estimation results 
  • Be able to access and use stored estimation results 
  • Know how to export results using user-written commands: estout, outreg, tabout 
  • Understand how Stata programs work
  • Be able to write and use a simple Stata program 
  • Be able to write a do-file which exports results using file
Curriculum

Course modules and outline

Module one

  • Introduction to Statistics Concepts
  • Descriptive Statistics
  • Inferential Statistics
  • Research process
  • Concepts and Software for Data Collection and Processing
  • Planning data gathering and processing
  • Introduction to mixed methods for Quantitative Data Collection (Web, and Mobile tools)
  • Use of Mobile Phones for Data Collection (Open Data Kit)
  • STATA Basics
  • Learn how to use Dialog Boxes
  • The command widow
  • User-written extensions
  • Directory Management
  • Obtaining help and perform search
  • STATA syntax
  • Using Basic Statistical Commands
  • Reusing results of STATA commands

Module Two

  • Data Structures and Types of Variables
  • Distinguishing between Categorical data, Continuous data; Numerical, string and date/time variables
  • Managing missing data
  • Creating dummy variables
  • Other special purpose variables
  • Converting datasets into summaries
  • Labeling variables, encoding variables and generating new variables
  • Data Management using STATA
  • Import, Export, load and save datasets
  • Create pseudorandom datasets
  • Review and document the dataset
  • Sorting and ordering
  • Appending, merging and reorganizing datasets
  • Validate data structure
  • Identify duplicate observations
  • Alarming and nonsensical data
  • Benefits of filtering

Module Three

  • Output Management
  • Logs for output
  • Use of translators for exporting STATA files and output
  • Copy and paste from STATA to text editors and spreadsheets
  • Reproduction of past work, stored results and saved results
  • The command display, explicit subscripting and important prefixes
  • Basics of STATA programming
  • Executing commands using do-files
  • Proper structure of do-files
  • Using comments
  • Writing long commands

Module Four

  • Basics of graphing with STATA
  • Basics of Graphing Qualitative Data
  • Basics Graphing Quantitative Data
  • Dialog Boxes vs. Do-file routines
  • Inspecting the data prior graphing
  • Reducing the data dimension to speed up graphing
  • Setting range of variation
  • Subgroups and overlays in STATA Graphics
  • Graphing by categorical groups
  • Subgroup options
  • Formatting graph text
  • Superimposing densities and other graphs
  • Legends for multiple graphs and multiple axes
  • Generalized syntax for overlaying multiple graphs
  • The -two way-Command
  • Scatter graph
  • Linear fits and nonlinear fits
  • Parametric density estimators and Non-parametric density estimators
  • Soft coded vs. hard coded syntax.
  • Using loops for multiple overlays

Module Five

  • Advanced graphing
  • Combining multiple graphs side-by-side
  • Recasting two way plots
  • Reproducing formatting
  • Creating your own graph scheme
  • The graph editor as a scheme maker
  • Quantitative Analysis using STATA
  • Tests for Statistical Inference
  • Tests of Association
  • Tests of Difference
  • Linear regression analysis
  • Ordinary least squares
  • Predicted values and residuals
  • Correlation and Standardized Regression Coefficients
  • Hypothesis testing
  • Problems with regression
  • Introduction to panel data analysis
  • Advantages of panel data analysis
  • Panel data sets
  • Balanced and unbalanced panels
  • Panel data dimensions and frequencies
  • Properties of estimators
  • Graphing panel data
Target Audience

Who should attend?

The course is designed for people who want to be more efficient in their use of Stata. Those who are already experienced in using Stata for data analysis will benefit most from the course

Why Attend

Key course benefits

Practical capacity building approach
Designed for government, NGOs and public institutions
Real-world African case studies
Certificate of completion
Applicable tools and templates
Interactive facilitation and exercises
Course Enquiry

Need more information?

Ask Magna Skills about this course

Use the PHPMaker enquiry form to request a quotation, proposal letter, invoice, group training package, online access, or face-to-face training arrangement.

Debug

sql: SELECT COUNT(*) FROM `userlevels` WHERE `userlevelid` = -2, executionMS: 0.00053906440734863

sql: SELECT `userlevelid`, `userlevelname` FROM `userlevels`, executionMS: 0.00036001205444336

sql: SELECT COUNT(*) FROM `userlevelpermissions` WHERE `userlevelid` = -2, executionMS: 0.0010151863098145

sql: SELECT `tablename`, `userlevelid`, `permission` FROM `userlevelpermissions` WHERE `userlevelid` IN (-2), executionMS: 0.0029778480529785

sql: SELECT c.*, cc.Category_Name, cc.Summary AS CategorySummary, cc.Category_Description FROM courses c LEFT JOIN course_categories cc ON cc.id = c.Category WHERE c.id = 2736 LIMIT 1, executionMS: 0.00074005126953125

sql: UPDATE courses SET Views = IFNULL(Views,0) + 1 WHERE id='2736', executionMS: 0.002612829208374

sql: SELECT * FROM course_modules WHERE CourseID = 2736 AND Status IN ('Active','1') ORDER BY SortOrder, id LIMIT 20, executionMS: 0.0010130405426025

sql: SELECT * FROM course_highlights WHERE CourseID = 2736 AND Status IN ('Active','1') ORDER BY SortOrder, id LIMIT 8, executionMS: 0.00054001808166504

sql: SELECT * FROM course_learning_outcomes WHERE CourseID = 2736 AND Status IN ('Active','1') ORDER BY SortOrder, id LIMIT 10, executionMS: 0.00045323371887207

sql: SELECT * FROM course_target_audience WHERE CourseID = 2736 AND Status IN ('Active','1') ORDER BY SortOrder, id LIMIT 8, executionMS: 0.00048184394836426

sql: SELECT * FROM resources WHERE CourseID = 2736 AND Status IN ('Published','Active','1') ORDER BY id DESC LIMIT 5, executionMS: 0.00056195259094238

sql: SELECT * FROM reviews WHERE CourseID = 2736 AND CanPublish = 1 AND Status IN ('Approved','Published','1') ORDER BY id DESC LIMIT 4, executionMS: 0.00051021575927734

sql: SELECT * FROM gallery_albums WHERE CourseID = 2736 AND Status IN ('Published','Active','1') ORDER BY IsFeatured DESC, AlbumDate DESC, id DESC LIMIT 3, executionMS: 0.00053715705871582

sql: SHOW COLUMNS FROM `venues` LIKE 'id', executionMS: 0.0010008811950684

sql: SELECT v.*, v.`id` AS VenueKey, (SELECT COUNT(*) FROM apply a WHERE a.Venue = v.`id` AND a.Course_Title = 2736) AS CourseApplications, (SELECT COUNT(*) FROM apply a WHERE a.Venue = v.`id`) AS TotalApplications FROM venues v ORDER BY CourseApplications DESC, TotalApplications DESC, v.Venue ASC, executionMS: 1.9200880527496

sql: SHOW COLUMNS FROM `courses` LIKE 'Category', executionMS: 0.00069093704223633

sql: SELECT id, Course_Title, Course_Code, Short_Description FROM courses WHERE Category = 815 AND id <> 2736 ORDER BY id DESC LIMIT 6, executionMS: 0.0009300708770752

sql: SELECT COUNT(*) FROM apply WHERE Course_Title = 2736, executionMS: 0.080832958221436

sql: SELECT COUNT(*) FROM enroll WHERE Course = 2736, executionMS: 0.00079011917114258

sql: SELECT ROUND(AVG(Rating),1) FROM reviews WHERE CourseID = 2736 AND CanPublish = 1, executionMS: 0.00052785873413086

sql: SELECT COUNT(*) FROM course_modules WHERE CourseID = 2736, executionMS: 0.00032401084899902

sql: SELECT COUNT(*) FROM course_lessons cl INNER JOIN course_modules cm ON cm.id = cl.ModuleID WHERE cm.CourseID = 2736, executionMS: 0.00064301490783691

sql: SELECT COUNT(*) FROM course_highlights WHERE CourseID = 2736, executionMS: 0.00043296813964844

sql: SELECT COUNT(*) FROM course_learning_outcomes WHERE CourseID = 2736, executionMS: 0.00041508674621582

sql: SELECT COUNT(*) FROM course_target_audience WHERE CourseID = 2736, executionMS: 0.00029206275939941

sql: SELECT COUNT(*) FROM resources WHERE CourseID = 2736, executionMS: 0.00032520294189453

sql: SELECT COUNT(*) FROM reviews WHERE CourseID = 2736, executionMS: 0.0003359317779541

sql: SELECT COUNT(*) FROM gallery_albums WHERE CourseID = 2736, executionMS: 0.00023603439331055

sql: SELECT COUNT(*) FROM course_enquiries WHERE CourseID = 2736, executionMS: 0.00033712387084961