Data Analysis Using Excel

Live Online Workshop on Data Analysis using Excel

On 20th, 21st & 22nd May 2020 at 10:30 AM to 1:00 PM 

(3 sessions 2.5 hours each)

What you will learn

Attendees will learn the essentials of data cleaning and matching functions, including how, when, and why to use them.

They will also learn foundational analytic techniques such as aggregation-based analysis with Pivot Tables.

Visualizing complex data sets using Excel.

They will also learn how to frame and solve optimization problems via linear programming and how to create interactive reports for executives.

Participants will learn how to implement a supervised learning algorithm, perform linear regression, and run simulations with tens of thousands of iterations to model events and outcomes.

Course Content:

The Workshop 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

Numeric data Analysis

Descriptive analysis

Predictive analysis

Categorical data Analysis

Chi square test of independence

Simple Linear regression / Multiple linear regression

F test for equality of variances

T- Test for Comparing two sample means

Pair t test

ANOVA – single factor

ANOVA – two factor with / without replication

Generating random numbers with uniform / normal / poison distr.

Rank and Percentile

Histogram and pareto charts

Goal seek

Linear programming problem – Solver example

How to Register

Fees: Rs. 4500/- + 18% GST Per Person

Please write to register@princetonacademy co in

Call or WhatsApp on 9769963790 / 9769579090

Mention the name of participant, company, contact details.