Advance Analytics with Excel - data analysis toolpak/ Solver
course's star rating by considering a number of different factors
such as the number of ratings, the age of ratings, and the
likelihood of fraudulent ratings.
Find online courses made by experts from around the world.
Take your courses with you and learn anywhere, anytime.
Learn and practice real-world skills and achieve your goals.
What is this course all about?
What Kind of Material is included
How long it should take to complete the course
It should take roughly 10 hours to practice and master all the procedure.
How is the course structured
The course first explains a business context and the data. Then it demonstrates how to use statistical procedure using data analysis tool pack. It Also explains how to solve linear programming problem using solver. It demonstrates how th use goal seek. The content of the course will be
Why Take this course
Not for you? No problem.
30 day money back guarantee.
Learn on the go.
Desktop, iOS and Android.
Certificate of completion.
|Section 1: Statistical Analysis|
Descriptive Statistics for Numerical Data Analysis
Excel files - where they are?
Interpret Descriptive statistics output
Pivot Table Analysis - count and percentage for each distinct category
Category wise Numeric data analysis using Pivot table
Cross tab Analysis
Chi Square Test of independence
Simple Linear RegressionPreview
Multiple Linear Regression
Comparing Two Sample Variances
Comparing Two Sample Means
Pair T Test
One Factor (One Way) ANOVAPreview
Two Factor ANOVA without replication
Two Factor ANOVA with replication
Generating Random Numbers, which has Normal / Poison / Uniform etc. Distribution
Rank and Percentile calculation
Histogram Procedure and Getting Pareto Chart
Exponential Smoothing and Moving Average
Random Sampling, Co-variance and Correlation procedure
|Section 2: Using Goal Seek|
Goal Seek Example
|Section 3: Solving Linear Optimization Problems using Excel Solver|
Example 1 - using solver for linear programming case
Example 2 - using solver for linear programming case
How to download Excel files
I am a seasoned Analytics professional with 15+ years of professional experience. I have industry experience of impactful and actionable analytics. I am a keen trainer, who believes that training is all about making users understand the concepts. If students remain confused after the training, the training is useless. I ensure that after my training, students (or partcipants) are crystal clear on how to use the learning in their business scenarios. My expertise is in Credit Card Business, Scoring (econometrics based model development), score management, loss forecasting and MS access based database application development.