Detailed concepts, 30 company data from different industries and their solutions using Excel, 3 powerful animations to aid learning and understanding, and many more
pt1 - Introduction & data summarization: terms, Excel toolpak, frequency table, histogram, charts.
pt2 - Descriptive statistics and probability distribution: Central Tendency, Dispersion, Percentiles, Z-score.
pt3 - Sampling and Central Limit theorem:
pt4- Inference: confidence Interval, population, proportion, mean
pt5 - Hypothesis testing: Formulating the hypothesis, analyzing the result, one tail, and two-tail test.
pt6 - inference based on two samples: testing for no difference in mean, one tail, two tail test, proportions etc.
pt7 - simple linear regression: Least square method, assessing regression model, testing the significance, model assumptions, and limitations, residual analysis.
pt8 - Multiple linear regression: Developing multiple regression models, output analysis, two categories, and many category data.