Excel for Statistics
How to Test for Normal Distribution in Excel (2 Easy Ways)
This article explores various tests for normal distribution in Excel including a quick & dirty check, Jarque-Bera test, and the Q-Q plot test.
Read article
Excel for Statistics
66 articles
Excel for Statistics
How to Create Percent Frequency Distribution in Excel (2 Ways)
This article explores percent frequency distribution in Excel using the PivotTable and Excel features & functions.
Read article
Excel for Statistics
How to Make a Contingency Table (Crosstabs) in Excel
This article explores how to make a contingency table (crosstabs) in Excel using the PivotTable and COUNTIFS function.
Read article
Excel for Statistics
How to Calculate Z Score for 95% Confidence Interval in Excel
This article explores how to calculate Z score 95 confidence interval in Excel using NORM.S.INV function and Z table.
Read article
Excel for Statistics
How to Perform Fisher Test in Excel (One & Two Tailed Tests)
This article explores the Fisher test in Excel and how to calculate the one and two tailed P values using the HYPGEOM.DIST function.
Read article
Excel for Statistics
How to Make Frequency Distribution Table in Excel (3 Easy Ways)
This article explores how to make frequency distribution table in Excel using Data Analysis ToolPak, FREQUENCY function, and PivotTable.
Read article
Excel for Statistics
How to Calculate Z Score in Excel (2 Suitable Ways)
This article explores how to calculate Z score in Excel using STANDARDIZE function and arithmetic formula, and interpretation of the results.
Read article
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
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