Excel for Statistics
How to Do One Way ANOVA in Excel
This article explores what one way ANOVA is, how to do one way ANOVA in Excel, and significance of the results of the one way ANOVA test.
Read article
Excel for Statistics
66 articles
Excel for Statistics
How to Calculate Weighted Median in Excel (with Special Cases)
This article explores how to calculate weighted median in Excel using a formula. We will also look at two special cases for weighted median.
Read article
Excel for Statistics
How to Calculate Median Excluding Zeros in Excel (4 Easy Ways)
This article explore Excel median if not zero and its calculation by using MEDIAN, IF, and FILTER functions, in addition to excluding errors.
Read article
Excel for Statistics
MEDIAN-IF Formula to Find Conditional Median in Excel
This article explores Excel MEDIAN IF also know as conditional median using MEDIAN, IF, and FILTER functions, for single & multiple criteria.
Read article
Excel for Statistics
How to Find Median for Grouped Data in Excel (2 Easy Ways)
This article explores grouped median and how to find median in Excel for grouped data using manual approach & dynamic approach with functions.
Read article
Excel for Statistics
How to Make a Population Pyramid in Excel (with Detailed Steps)
In this tutorial you will learn about population pyramid and how to make a population pyramid in Excel using 2D stacked bar chart.
Read article
Excel for Statistics
How to Calculate Population Growth Rate in Excel (3 Quick Ways)
This article explores how to calculate population growth rate in Excel using AAGR and CAGR, in addition to population projection formulas.
Read article
Excel for Statistics
How to Create a Questionnaire in Excel (Online & Offline Methods)
This article explores what questionnaire is and how to create a questionnaire in Excel with Microsoft Forms and the built in Form feature.
Read article
Excel for Statistics
How to Tabulate Data in Excel (2 Suitable Methods)
This article explores what tabulation is and how to tabulate data in Excel using built in functions and the Pivot Table feature.
Read article
Excel for Statistics
How to Analyze Survey Data in Excel (Complete Guide)
This article explores how to analyze survey data in Excel by calculating frequency, central tendency, variability, cross tables, charts, etc.
Read article
Excel for Statistics
How to Extrapolate a Graph in Excel (Linear & Non-Linear)
This article explores how to extrapolate a graph in Excel using Trendline and forecast features for linear and nonlinear data.
Read article
Excel for Statistics
How to Perform Linear Extrapolation in Excel (5 Easy Ways)
This article explores how to perform linear extrapolation in Excel using arithmetic formula, LINEST, TREND, FORECAST.LINEAR, and Trendline.
Read article