# How to Calculate Sample Size in Excel

Techwalla may earn compensation through affiliate links in this story.
Excel eases complex statistical calculations.

Microsoft Excel has ten major statistical formulas, such as sample size, mean, median, standard deviation, maximum and minimum. The sample size is the number of observations in a data set, for example if a polling company polls 500 people, then the sample size of the data is 500. After entering the data set in Excel, the =COUNT formula will calculate the sample size. Sample size is useful for calculations such as standard error and confidence levels. Using Microsoft Excel will allow a user to quickly calculate statistical formulas since statistical formulas tend to be longer and complex than other mathematical formulas.

## Step 1

Enter the observation data in Excel, one observation in each cell. For example, enter data in cells A1 through A24. This will provide a vertical column of data in column A.

Video of the Day

## Step 2

Type "=COUNT(" in cell B1.