๐ŸŒ
Statistics LibreTexts
stats.libretexts.org โ€บ campus bookshelves โ€บ oxnard college โ€บ statistics calculators for math 105
3: Mean and Standard Deviation from a Frequency Table - Statistics LibreTexts
September 25, 2022 - This calculator computes mean, standard deviation, and 5-number summary from a frequency or probability distribution table. Please report any error to Dr.
๐ŸŒ
NCalculators
ncalculators.com โ€บ statistics โ€บ grouped-data-standard-deviation-calculator.htm
Grouped Data Standard Deviation Calculator
frquency distribution or grouped standard deviation calculator - step by step calculation to measure the grouped data dispersion from the mean based on the group or range & frequency of data, provided with formula & solved example problems for statistical data analysis
๐ŸŒ
GeeksforGeeks
geeksforgeeks.org โ€บ data science โ€บ standard-deviation-in-frequency-distribution-series
Standard Deviation in Frequency Distribution Series - GeeksforGeeks
July 23, 2025 - Step 2: Now, the frequencies of the data set are multiplied by their respective deviations and are denoted by fd. Step 3: In the next step, the fd determined in the previous step is multiplied by the deviations (d). Step 4: The last step is to calculate the standard deviation of the frequency distribution series using the formula.
๐ŸŒ
Mathway
mathway.com โ€บ examples โ€บ statistics โ€บ frequency-distribution โ€บ finding-the-standard-deviation-of-the-frequency-table
Statistics Examples | Frequency Distribution | Finding the Standard Deviation of the Frequency Table
Tap for more steps... ... Find the midpoint for each class. ... Multiply the frequency of each class by the class midpoint. ... Simplify the column. ... Add the values in the column. ... Add the values in the frequency column. ... The mean is the sum of the product of the midpoints and frequencies divided by the total of frequencies. ... Simplify the right side of . ... The equation for the standard deviation is . ... Substitute the calculated values into .
๐ŸŒ
HackMath
hackmath.net โ€บ en โ€บ calculator โ€บ standard-deviation
Standard deviation calculator (statistics)
For standard deviation calculation, ... For example: 10 20 30 40 50 60 70 80 90 100 ยท Simple. Write data elements (separated by spaces or commas, etc.), then write f: and further write the frequency of each data item....
๐ŸŒ
Statistics LibreTexts
stats.libretexts.org โ€บ learning objects โ€บ interactive statistics
8: Mean and Standard Deviation for Grouped Frequency Tables Calculator - Statistics LibreTexts
April 11, 2022 - The student enters the midpoints and the frequencies of a frequency table and the mean and standard deviation are computed.
๐ŸŒ
AtoZmath
atozmath.com โ€บ StatsG.aspx
Sample Variance, Standard deviation and coefficient of variation for grouped data calculator
Find Sample Variance, Standard deviation and coefficient of variation for grouped data calculator - Find Sample Variance, Standard deviation and coefficient of variation for grouped data, step-by-step online
Find elsewhere
๐ŸŒ
Doingsocialresearch
doingsocialresearch.com โ€บ home โ€บ calculating a mean or standard deviation from a frequency table
Calculating a mean or standard deviation from a frequency table
January 19, 2022 - Step 3. Multiply them times the ... total n (61), to get: Step 6. To calculate the standard deviation, we just take the square root of the variance:...
๐ŸŒ
Statology
statology.org โ€บ home โ€บ excel: calculate standard deviation of frequency distribution
Excel: Calculate Standard Deviation of Frequency Distribution
June 26, 2023 - Lastly, we can type the following formula into cell B8 to calculate the standard deviation of this frequency distribution: ... The standard deviation of this frequency distribution turns out to be 9.6377. The following tutorials explain how to perform other common tasks in Excel: How to Create Grouped Frequency Distribution in Excel How to Create a Percent Frequency Distribution in Excel How to Calculate Cumulative Frequency in Excel
๐ŸŒ
Weebly
hsdmaths.weebly.com โ€บ uploads โ€บ 2 โ€บ 2 โ€บ 0 โ€บ 3 โ€บ 22037362 โ€บ how_to_calculate_the_standard_deviation_on_a_calculator.pdf pdf
How to Calculate the Standard Deviation on a Calculator (Casio fx-83GT Plus)
Step 4: Using the up and right arrows, go to the top of the next column in the table, and input the frequencies from ยท the โ€œNo of Criticsโ€, pressing [ = ] in between ... Step 7: This brings up a list of options. Press [ 4 ] for โ€œVARโ€ and [ 3 ] for โ€œ โ€. This is the standard deviation.
Top answer
1 of 1
3

Because of the huge range of categories, you can probably get away with simply assuming each category label is a bin center and then treating the data as if it actually were 10, 10, 20, 20, 20, 20, 30, 30, ... and finding mean and standard deviation. I don't think Sheppard's corrections will be necessary on such a scale.

You don't actually need to produce the vector of individual data, since you can work out the contribution as if you did have each case. Imagine this was our whole table:

| Pause | Count |
|-------|-------|
| 10    | 2     |
| 20    | 4     |
| 30    | 6     |
| 40    | 5     |
`~~~~~~~~~~~~~~~'

If we produced the entire set of individual values

 10 10 20 20 20 20 30 30 30 30 30 30 40 40 40 40 40

we could just directly compute mean and standard deviation on them (28.24 and 10.15)

However, what we'd do instead is calculate something to give the same effect.

So if $P_i$ is the value of the i-th Pause-label and $c_i$ is the corresponding count, the mean will be $\bar{P}=\frac{\sum_i P_i c_i}{\sum_i c_i}$ = (10 x 2 + 20 x 4 + 30 x 6 + 40 x 5)/(2+4+6+5) = 28.24. This is the same as adding all the individual values and dividing by the total number of values.

We can do the same thing with the variance.

$\frac{\sum_i (P_i-\bar{P})^2 c_i}{\sum_i c_i}$

This would yield the n-divisor form of the variance, so if we want Bessel's correction we need instead:

$\frac{\sum_i (P_i-\bar{P})^2 c_i}{(\sum_i c_i) -1}$

We can simplify this by expanding the numerator out and doing some algebra, but that can be numerically unstable; better to stick to this form.

In this case, that formula gives 96.8858, and the standard deviation is the square root of that, about 10.15

If you do want Sheppard's correction, see this question or Wikipedia

๐ŸŒ
Scribbr
scribbr.com โ€บ home โ€บ how to calculate standard deviation (guide) | calculator & examples
How to Calculate Standard Deviation (Guide) | Calculator & Examples
March 28, 2024 - To find the mean, add up all the scores, then divide them by the number of scores. Subtract the mean from each score to get the deviations from the mean. Since xฬ… = 50, here we take away 50 from each score.
๐ŸŒ
VrcAcademy
vrcacademy.com โ€บ tutorials โ€บ statistics โ€บ descriptive statistics โ€บ variance and standard deviation for grouped data calculator
Variance and Standard Deviation for Grouped Data Calculator - VrcAcademy
April 25, 2024 - Use Variance and Standard Deviation for Grouped Data calculator to calculate sample mean,sample variance and sample standard deviation for grouped data based on data provided in class groups and type of frequency distribution. Below article on standard deviation for grouped data calculator provides step by step procedure about how to use variance for grouped data calculator with detailed standard deviation for grouped data examples.
๐ŸŒ
Omni Calculator
omnicalculator.com โ€บ statistics โ€บ grouped-data-standard-deviation
Grouped Data Standard Deviation Calculator
March 11, 2025 - That's not an issue; you can always turn your steps into burned calories - but how much should you walk? Well, after a month of noting your orders, you have 30 observations. This should be enough to give you a reasonable estimate but too much to handle separately. You could make a small frequency distribution table: Inputting these into the grouped data variance calculator, you find that, on average, your coffee has 172.5 kcal (mean), but the actual value is likely to vary by 36 kcal (standard deviation).
๐ŸŒ
CalculatorSoup
calculatorsoup.com โ€บ calculators โ€บ statistics โ€บ descriptivestatistics.php
Descriptive Statistics Calculator
Calculator online for descriptive or summary statistics including minimum, maximum, range, sum, size, mean, median, mode, standard deviation, variance, midrange, quartiles, interquartile range, outliers, sum of squares, mean deviation, absolute deviation, root mean square, standard error of the mean, skewness, kurtosis, kurtosis excess in Excel, coefficient of variation and frequency.
Top answer
1 of 3
12

First, I'd change that messy list into two numpy arrays like @user8153 did:

val, freq = np.array(list_tuples).T

Then you can reconstruct the array (using np.repeat prevent looping):

data = np.repeat(val, freq)

And use numpy statistical functions on your data array.


If that causes memory errors (or you just want to squeeze out as much performance as possible), you can also use some purpose-built functions:

def mean_(val, freq):
    return np.average(val, weights = freq)

def median_(val, freq):
    ord = np.argsort(val)
    cdf = np.cumsum(freq[ord])
    return val[ord][np.searchsorted(cdf, cdf[-1] // 2)]

def mode_(val, freq): #in the strictest sense, assuming unique mode
    return val[np.argmax(freq)]

def var_(val, freq):
    avg = mean_(val, freq)
    dev = freq * (val - avg) ** 2
    return dev.sum() / (freq.sum() - 1)

def std_(val, freq):
    return np.sqrt(var_(val, freq))
2 of 3
4
import pandas as pd
import math
import numpy as np

Frequency Distributed Data

    class   freq
0   60-65   3
1   65-70   150
2   70-75   335
3   75-80   135
4   80-85   4

Create Middle point column for classes

df[['Upper','Lower']]=df['class'].str.split('-',expand=True)
df['Xi']=(df['Upper'].astype(float)+df['Lower'].astype(float))/2
df.drop(['Upper','Lower'],axis=1,inplace=True)

Therefore

    class   freq  Xi
0   60-65   3     62.5
1   65-70   150   67.5
2   70-75   335   72.5
3   75-80   135   77.5
4   80-85   4     82.5

Mean

mean = np.average(df['Xi'], weights=df['freq'])
mean
72.396331738437

Standard Deviation

std = np.sqrt(np.average((df['Xi']-mean)**2,weights=df['freq']))
std
3.5311919641103877