-
What is Analysis of Variance (ANOVA)?
Learn ANOVA basics: concepts, Excel usage, key terms, group variability, One-Way & Two-Way ANOVA, F-Statistic, and MANOVA explained with steps & examples
Gurchetan 01 May, 2025
-
Cheatsheet – Excel Functions & Keyboard Shortcuts
This article provides 2 cheatsheets - Excel functions and keyboard shortcuts. It should serve as ready reference for doing data analysis in Excel
Sunil Ray 24 May, 2018
-
A Beginner’s guide to Shelf Space Optimization using Linear Programming
A beginners guide to shelf space optimization in retail using linear programming, explained with examples using simplex method, python & greedy algorithms.
Guest Blog 22 Oct, 2024
-
What did you miss ? Complete Solution of Mini Hack Excel
This is a solution of mini hack excel which involves solving a business problem using advanced excel, logical and structured thinking to solve
Analytics Vidhya 14 Mar, 2016
-
A Comprehensive Guide to Data Exploration
This tutorial on data exploration comprises missing value imputation, outliers, feature engineering, and variable creation.
Sunil Ray 01 May, 2025
-
Getting started with Machine Learning in MS Excel using XLMiner
Here is the tutorial on machine learning using xlminer in excel on multiple linear regression, logistic regression and clustering algorithm
Analytics Vidhya 26 Jun, 2020
-
How to automate your Excel models and reporting using dynamic Range?
Creating dynamic ranges can help us automate our Excel models and reports including Pivot tables and charts
Sunil Ray 17 Apr, 2015 -
Framework to build logistic regression model in a rare event population
This article explains a step by step process for building logistic regression model in a rare event population.
Tavish Srivastava 25 Jun, 2020
