<
<

Groupby Geometric Mean

>

Computes the geometric mean of values in a dataset grouped by a specified column.

>

Input

Output

29 Related tools

Table Statistic?

Any Questions?

Computes the geometric mean of values in a dataset grouped by a specified column. Geometric mean is the nth root of the product of n numbers. Read more about geometric mean on Wikipedia https://en.wikipedia.org/wiki/Geometric_mean

3.77 is the geometric mean of the set [2, 4, 6] because √(2 x 4 x 6) = 3.77.

Helpful for calculating average rates of return or growth for each group, useful in finance or biology where growth rates are relevant.

  • Microsoft Excel: GEOMEAN
  • Google Sheets: -
  • Apple Numbers: -
  • Python Pandas: df.groupby('grouping_column')['column_name'].apply(scipy.stats.gmean)
  • Related Words: calculate groupby geometric mean, find geometric mean based on a grouping column

This is normal for a web based application. We recommend uploading data up to 6000 columns and rows. If you encounter lag, you can reduce the sheet size.

There is a fullscreen button on the top right side of the input table. You can also download the table offline to edit with excel which has bigger screen sizes.

You can leave a message here.

Why SickSheet?

🌎
Access Anywhere

Compatible with any browser on any systems. No installation needed.

💸
Free to Use

Use over 300+ tools for free. No registration or credit card asked.

🧸
No Code

Complete all process without writing a single line of code.

💡
Intuitive Edit

Editing tables feels like in Excel. No learning curve needed.

💾
Instant Download

Click to download 10+ Spreadsheet formats and continue edit in Excel.

🕵️‍♂️
Super Private

Nothing is sent to the server. All data are operated on the client-side.

Related Tools?

Discover Above Geometric Mean

Finds values above the geometric mean.

geometric mean
Discover Under Geometric Mean

Finds values below the geometric mean.

geometric mean
Calculate Geometric Mean

Computes the geometric mean in each row and column.

geometric mean
Rolling Geometric Mean

Computes the rolling geometric mean of a specified window size for a dataset.

geometric mean
Cumulative Geometric Mean

Computes the cumulative geometric mean in a dataset up to each row or column.

geometric mean
Groupby Sum

Computes the sum of values in a dataset grouped by a specified column.

Groupby Quotient

Computes the quotient of values in a dataset grouped by a specified column.

Groupby Product

Computes the product of values in a dataset grouped by a specified column.

Groupby Difference

Computes the difference in a dataset grouped by a specified column.

Groupby Duplicate Cell Count

Count duplicate cells in a dataset grouped by a specified column.

Groupby Mode

Computes the mode of values in a dataset grouped by a specified column.

Groupby Unique Cell Count

Count distinct values in a dataset grouped by a specified column.

Groupby First

Performs a SQL grouby and returns the first element of each item.

Groupby Last

Performs a SQL grouby and returns the last element of each item.

Groupby Maximum

Computes the maximum value in a dataset grouped by a specified column.

Groupby Minimum

Computes the minimum value in a dataset grouped by a specified column.

Groupby Range

Computes the range of values in a dataset grouped by a specified column.

Groupby Blank Count

Count empty cells in a dataset grouped by a specified column.

Groupby Non Blank Count

Count non-empty cells in a dataset grouped by a specified column.

Groupby Harmonic Mean

Computes the harmonic mean of values in a dataset grouped by a specified column.

Groupby Mean

Computes the mean (average) of values in a dataset grouped by a specified column.

Groupby Median

Computes the median of values in a dataset grouped by a specified column.

Groupby Concatenation

Concatenate the values in a dataset grouped by a specified column.

Groupby Percent Difference

Computes the percentage difference in a dataset grouped by a specified column.

Groupby Quantile

Computes the quantile of values in a dataset grouped by a specified column.

Groupby Kurtosis

Computes the kurtosis of values in a dataset grouped by a specified column.

Groupby Skewness

Computes the skewness of values in a dataset grouped by a specified column.

Groupby Standard Deviation

Computes the standard deviation of values in a dataset grouped by a specified column.

Groupby Variance

Computes the variance of values in a dataset grouped by a specified column.

<
👉... other 321 tools to save you time
>