Statistical Analysis with Stata and R Training Course

Introduction

Stata and Big Data

  • What is Stata?
  • Stata syntax and commands

R Programming

  • What is R?
  • R syntax and structure

Preparing the Development Environment

  • Installing and configuring Stata
  • Installing and configuring R libraries and frameworks

R and Stata

  • Reading and writing to Stata with R

Databases and Data in Stata

  • Opening and clearing databases
  • Compressing databases
  • Importing and exporting databases
  • Viewing, describing, and summarizing raw data
  • Using tabulations and tables
  • Implementing variables for data manipulation

Descriptive Analysis and Predictive Analysis

  • Working with distributional analysis
  • Working with Monte Carlo simulations
  • Working with count data analysis
  • Working with survival analysis

Hypothesis Testing

  • Testing and comparing means

Graphing in Stata

  • Using plots, charts, and graphs
  • Working with statistical analysis in graphing
  • Styling and combining graphs

Regression Models with R

  • Using bivariate correlation and regression
  • Working with OLS regression, logits, and probits
  • Using interactive effects in regression models

Summary and Conclusion

Excel For Statistical Data Analysis Training Course

Aggregating Data in Excel

  • Statistical Functions
  • Outlines
  • Subtotals
  • Pivot Tables

Data Relation Analysis

  • Normal Distribution
  • Descriptive Statistics
  • Linear Correlation
  • Regression Analysis
  • Covariance

Analysing Data in Time

  • Trends/Regression line
  • Linear, Logarithmic, Polynomial, Power, Exponential, Moving Average Smoothing
  • Seasonal fluctuations analysis

Comparing Populations

  • Confidence Interval for the Mean
  • Test of Hypothesis Concerning the Population Mean
  • Difference Between Mean of Two Populations
  • ANOVA: Analysis of Variances
  • Goodness-of-Fit Test for Discrete Random Variables
  • Test of Independence: Contingency Tables
  • Test Hypothesis Concerning the Variance of Two Populations

Forecasting

  • Extrapolation