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
Blog
1285 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 Charts
How to Change Legend Colors in Excel (With Easy Steps)
Change Excel legend colors by editing data series colors. Simple steps to customize chart appearance for clearer data visualization.
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 Charts
Reorder Legend Without Changing Chart in Excel (3 Quick Steps)
Reorder Excel legend without changing chart data. Simple steps to customize legend sequence while preserving your chart.
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