Excel for Statistics
How to Find Z Critical Value in Excel (Left, Right, & 2 Tailed Tests)
This article teaches you to find Z critical value in Excel for left-tailed, right-tailed, and two-tailed tests using the NORM.S.INV function.
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 Perform the Friedman Test in Excel (with Detailed Steps)
This article explores the Friedman test in Excel, the formula for the test, and how to perform and interpret the test results.
Read article
Excel for Statistics
How to Do a T-Test in Excel (Paired, Two & One Sample Tests)
This article teaches you how to do a T test in Excel using functions and Data Analysis ToolPak, and to interpret the T test results.
Read article
Excel for Statistics
How to Use the F.DIST Function in Excel (with Syntax and Usage)
This article explores the syntax and usage of the F.DIST and F.DIST.RT functions in Excel with step-by-step examples.
Read article
Excel for Statistics
How to Do F-Test in Excel (One & Two-Tailed Tests)
This article teaches you how to do f test in Excel using Data Analysis ToolPak and the F.TEST function, along with interpretation of results.
Read article
Excel for Statistics
Descriptive Statistics: Input Range Contains Non-Numeric Data
This article teaches you several ways to fix input range contains non numeric data when obtaining Descriptive Statistics in Excel.
Read article
Excel for Statistics
How to Find T Critical Value in Excel (Left, Right & 2-Tailed Tests)
This article teaches you to find T critical value in Excel for left, right, and two tailed tests using the T.INV and T.INV.2T functions.
Read article
Excel for Statistics
How to Get Summary Statistics in Excel (Using Analysis ToolPak)
This article teaches you to get summary statistics in Excel using Data Analysis software, along with a detailed explanation of the results.
Read article
Excel for Statistics
How to Export Tally Data in Excel (2 Suitable Ways)
This article teaches you how to export tally data in Excel using the Export option and the ODBC (Open Database Connectivity) feature.
Read article
Excel for Statistics
How to Tally a Column in Excel (5 Simple Ways)
This article teaches you how to tally a column in Excel using AutoSum, Table, functions, in addition to conditional tallying.
Read article
Excel for Statistics
How to Tally Words in Excel (with Formulas & VBA)
This article teaches you how to tally words in a cell and range of cells using Excel functions and a VBA user defined function.
Read article