Linear Regression – Creating linear regression models for linear data using statistical tests, data preprocessing, standardization, normalization, etc.How to optimize the efficiency of the clustering model.How to evaluate the model for a clustering problem.How to train the model in a clustering problem.Introduction to clustering problems, Identification of a clustering problem, dependent and independent variables.How to optimize the efficiency of the classification model.How to evaluate the model for a classification problem.How to train the model in a classification problem.Introduction to classification problems, Identification of a classification problem, dependent and independent variables.How to optimize the efficiency of the regression model.How to evaluate the model for a regression problem.How to train the model in a regression problem.Introduction classification problems, Identification of a regression problem, dependent and independent variables.Introduction to scikit-learn, Keras, etc.Linear Regression, Logistic Regression, Error in regression, Information Gain using RegressionĬlassification problem using excel on sales data, and statistical tests on various samples from the population.Inferential Statistics, Hypothesis Testing, ANOVA, Covariance, Correlation.Standardization, Normalization, Probability Distributions.Binary Classification Problems, Confusion Matrix, AUC and ROC curve.Power Pivot, Power Query and Power View.Multiples: A set of charts with the same axes, Matrices, Cards, Tiles.
Bar charts, Column charts, Line charts, Maps.Charts, Pie charts, Scatter and bubble charts.Handling Text Data, Splitting, combining, data imputation on text data, Working with Dates in Excel, Data Conversion, Handling Missing Values, Data Cleaning, Working with Tables in Excel, etc.VBA Macros, Ranges and Worksheet in VBA.Working with Charts in Excel, Pivot Table, Dashboards, Data And File Security.Reading the Data, Referencing in formulas, Name Range, Logical Functions, Conditional Formatting, Advanced Validation, Dynamic Tables in Excel, Sorting and Filtering.