Excel for Statistics
Budget vs Actual Variance: Analysis with Excel Formula
This article explains and explores the budget vs actual variance formula in Excel, budget vs actual % variance, and plotting variance chart.
Read article
Author & Spreadsheet Consultant
Eshrak Kader
59 Articles PublishedPublishing since
Eshrak Kader holds a BSc in Naval Architecture and Marine Engineering from Bangladesh University of Engineering & Technology and an MBA from North South University, building strong analytical and data-driven skills relevant to spreadsheet work. With 4+ years of Excel and Google Sheets experience, he specializes in functions, formulas, charts, statistics, and advanced Excel. He has authored 120+ blogs on Excel, VBA, and data analysis. He enjoys simplifying data and teaching practical spreadsheet skills.
Editorial Review
Articles Published by Eshrak Kader
Articles by Eshrak Kader are developed under the guidance of ExcelInsider’s core training program and are technically reviewed by Nehad Ulfat, lead spreadsheet consultant, to ensure accuracy and user-centric value.
Excel for Statistics
How to Make a Correlation Graph in Excel (with Easy Steps)
This article explores correlation graph and how to make correlation graph in Excel including adding regression line and calculating R square.
Read article
Excel for Statistics
How to Make a Correlation Matrix in Excel (2 Simple Ways)
This article explores the correlation matrix and how to make a correlation matrix in Excel using Data Analysis ToolPak and functions.
Read article
Excel for Statistics
How to Find Correlation Coefficient in Excel (with 2 Functions)
This article explores how to find correlation coefficient in Excel using CORREL and PEARSON functions along interpretation of the results.
Read article
Excel for Statistics
How to Calculate Outliers in Excel (3 Easy Ways)
This article explores outliers, how to calculate outliers in Excel using IQR, standard deviation, and charts, and learn to handle outliers.
Read article
Excel for Statistics
How to Calculate Standard Error in Excel (with Error Bars)
This article explores how to calculate standard error in Excel using functions and Data Analysis ToolPak and includes plotting error bars.
Read article
Excel for Statistics
How to Find Uncertainty of Slope in Excel (with Detailed Steps)
This article explores what uncertainty of slope is and how to find uncertainty of slope in Excel using functions and Data Analysis ToolPak.
Read article
Excel for Statistics
How to Calculate Uncertainty in Excel (With Easy Steps)
This article explores what uncertainty is, how to calculate uncertainty in Excel using functions, and an explanation of the results.
Read article
Excel for Statistics
How to Calculate Mean and Standard Deviation in Excel
This article explores how to calculate mean and standard deviation in Excel using AVERAGE & STDEV.S functions and a discussion of the result.
Read article
Excel for Statistics
How to Calculate Standard Deviation with IF Condition in Excel
This article explores standard deviation with if condition in Excel for single and multiple criteria using STDEV.S and IF functions.
Read article
Excel for Statistics
How to Calculate Variance in Excel (with 2 Examples)
This article explores how to calculate variance in Excel including examples of VAR.S, VAR.P, VARA, and VARPA function.
Read article
Excel for Statistics
How to Calculate Standard Deviation in Excel (with Examples)
This article explores how to calculate standard deviation in Excel including examples of STDEV.S, STDEV.P, STDEVA, and STDEVPA function.
Read article