ExcelR Jumbo PassExcelR Jumbo Pass Video   You May Have Heard About Offers, But Have You Heard Of ExcelR's JUMBO PASS? Well, Here's Your Chance To Avail The JUMBO PASS!! Watch The video

Course Description

Do you have these questions playing on your mind?

Should I open a new store for my business? Should I launch new product? Should I renew contract of my vendor? Whom should I give more bonuses among my team members? Who will win cricket world cup? Who will win elections?

AND how many times have you gone wrong with such decision making?

  • Answer will be an obvious – “I was wrong Many Times” if the decision making is based on intuition.
  • Answer will be an obvious – “I was right Many Times” if the decision making is based on statistical analysis.
  • Statistical analysis is used to take decisions across industries and across job levels. Intuition based decision making should be coupled with a factor called LUCK, for success. Most companies have not even seen the light because of lack of statistical analysis. We at ExcelR expose you to various statistical techniques for data analysis using a tool called “R/RStudio”. Revolution Analytics was recently acquired by Microsoft but will still continue to be an open source statistical software. With the tremendous increase in data generation which is set to increase by 4 thousand times by 2020 brings with it a new challenge on how to analyze the data faster to give business leaders insights for decision making. This is where statistical analysis comes in handy which forms the spine strength for any data scientist. Rather than trusting the gut feel, a data scientist uses statistical data analysis to bring in business value.

Things You Will Learn

  • Motivate the use of statistical methods for managerial decision making
  • Discuss the concepts of probability distributions and random variables
  • Review methods of representing data, pictorially and through summary statistics
  • Introduce standard normal distribution
  • Discuss applications of normal distribution
  • Introduce the concept of statistical inference
  • Recognize the existence of sample-to-sample variations
  • Understand central limit theorem and its implications for statistical inference
  • Introduce the concept of confidence intervals as a way to make statistical inferences
  • Calculate confidence intervals for population mean with known and unknown population 
  • Calculate confidence intervals for population proportions
  • Calculate confidence intervals for population variance
  • Quantify minimum sample sizes to achieve certain margin of error in predictions
  • Learn how to state null and alternative hypotheses
  • Understand type-I and type-II errors
  • Conduct one-sided hypothesis test for population proportion / mean
  • Conduct two-sided hypothesis tests for population proportion / mean
  • Compare the means using paired observations
  • Test for the difference of two population means using independent samples
  • Test for the difference of two population proportions 
  • Introduce Design of Experiments
  • Conduct one way Analysis of Variance (ANOVA)
  • Introduce the notion of statistical tests on ordinal data
  • Test for the difference between mean ranks using paired observations
  • Compare mean ranks in two independent samples
  • Bivariate data
  • Scatter plot
  • Compare mean ranks in two independent samples
  • Covariance
  • Correlation coefficient
  • Uses and issues
  • Linear regression
  • Covariance
  • Assumptions
  • Scatter plot matrix
  • Multiple linear regression
  • Ordinary Least Squares method (OLS)
  • Basic regression summary
  • Interpretation of coefficient estimates
  • standard errors
  • t-values and p-values
  • Basic tests
  • ANOVA table
  • Generalized Linear Models
  • Binary and multinomial logistic regressions
  • Poisson regression
  • Zero-inflated Poisson regression
  • Negative Binomial regression
  • Missing value patterns: Missing completely at random (MCAR). Missing at random (MAR). Missing not at random (MNAR)
  • List wise deletion. Pairwise deletion
  • Various imputation methods: Hot deck imputation. Mean substitution. Regression imputation. EM imputation
  • Censoring and truncation. Characteristics of survival analysis data
  • Time-to-event data. Hazard and survival functions
  • Kaplan-Meier estimate of survival function–
  • Cox proportional hazards model (ph), estimation and its analysis. Extensions
  • Stratified ph; ph with time-varying covariates–
  • Parametric survival analysis with standard distributions
  • Accelerated failure time models
  • Basic concepts: randomization, replication and control
  • Experimental design for testing differences in several means: Completely randomized and randomized–complete block designs. Cross-over designs
  • Two-level factorial experiments full and fractional. Plackett-Burman designs
  • Designs for three or more levels. Taguchi designs. Response surface designs
  • Case-Control designs for campaign evaluation
  • Designs for conjoint analysis

Contact Our Team of Experts

Why ExcelR?

Participants Placed Through ExcelR



  • The all new and exclusive JUMBO PASS is the latest initiative taken by ExcelR to offer you access to attend unlimited batches over the duration of 365 days. You will be able to attend unlimited number of classes for the course of your choice.
  • We don’t wash off our hands after the completion of the training. A dedicated trainer will be provided as mentor to guide you subsequent to the training. He will do the necessary handholding to clarify all your doubts. In addition you can approach our support team to answer your queries. We will be more than happy to assist you.
  • Faculty is our strength. All our instructors are professionals with 10-15 years of working experience in various domains. We handpick the trainers, who are experienced, have passion for training and who possess excellent training skills. All our trainers are considered to be the best faculty of the industry.
  • Yes. ExcelR is one of the leaders in Training. We have tied up with many Indian and Multinational companies. They contact us for student profiles as and when the vacancies exist. We connect the eligible students to the prospective employers. We help in preparing resume, provide assistance for interview preparation, real time projects etc. We provide support till the student is placed.
  • Yes, the participants will be provided access to our state-of-the-art Learning Management System (LMS) the moment they are registered for the course. They access the session online and gain some insight towards the subject, before attending a live class
  • ExcelR conducts periodical demo sessions on all the courses. Request a demo by Registering in the website. We shall share the demo details.
  • Send us an email [email protected] with your query. Our Subject Matter Experts/Sales team will approach you to clarify your queries or call us on 1800-212-2120 (Toll Free number – India), 608-218-3798 (USA), 800 800 9706 (India), 203-514-6638 (United Kingdom), 128-520-3240 (Australia).
  • There is no prerequisite for this program. Course takes participants right from basics to advanced concepts. For e.g. what is an average/mean until advanced regression topics including Linear, Logistic, Poisson regression etc.
  • There are 2 options in case you miss a class

           1) E-learning modules are available on our state-of-the-art LMS. You can access the videos at your                      convenience
          2) All online sessions will be recorded and uploaded in a centralized repository where you can access                   the classes you missed and join the next session without hassles.

Global Presence

ExcelR is a training and consulting firm with its global headquarters in Houston, Texas, USA. Alongside to catering to the tailored needs of students, professionals, corporates and educational institutions across multiple locations, ExcelR opened its offices in multiple strategic locations such as Australia, Malaysia for the ASEAN market, Canada, UK, Romania taking into account the Eastern Europe and South Africa. In addition to these offices, ExcelR believes in building and nurturing future entrepreneurs through its Franchise verticals and hence has awarded in excess of 30 franchises across the globe. This ensures that our quality education and related services reach out to all corners of the world. Furthermore, this resonates with our global strategy of catering to the needs of bridging the gap between the industry and academia globally.

ExcelR's Global Presence


Call Us whatsapp