<
<

Cumulative Harmonic Mean

>

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

>

Input

Output

26 Related tools

Table Statistic?

Any Questions?

Computes the cumulative harmonic mean in a dataset up to each row or column. Harmonic mean is the reciprocal of the arithmetic mean of the reciprocals. Read more about harmonic mean on Wikipedia https://en.wikipedia.org/wiki/Harmonic_mean

3.43 is the harmonic mean of the set [2, 4, 6] because 3 / (1/2 + 1/4 + 1/6) = 3.43.

Helps in scenarios where the average rate is required, for instance, in averaging speed, resistances in parallel circuits, or other rate problems.

  • Microsoft Excel: HARMEAN
  • Google Sheets: -
  • Apple Numbers: -
  • Python Pandas: (Not directly available in pandas)
  • Related Words: calculate cumulative harmonic mean, harmonic mean of all preceding values

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 Harmonic Mean

Finds values above the harmonic mean.

harmonic mean
Discover Under Harmonic Mean

Finds values below the harmonic mean.

harmonic mean
Calculate Harmonic Mean

Computes the harmonic mean in each row and column.

harmonic mean
Rolling Harmonic Mean

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

harmonic mean
Groupby Harmonic Mean

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

harmonic mean
Cumulative Sum

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

Cumulative Quotient

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

Cumulative Product

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

Cumulative Difference

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

Cumulative Duplicate Cell Count

Count duplicate cells in a dataset up to each row or column.

Cumulative Mode

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

Cumulative Unique Cell Count

Count distinct cells in a dataset up to each row or column.

Cumulative Maximum

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

Cumulative Minimum

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

Cumulative Range

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

Cumulative Blank Count

Count empty cells in a dataset up to each row or column.

Cumulative Non Blank Count

Count non-empty cells in a dataset up to each row or column.

Cumulative Geometric Mean

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

Cumulative Mean

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

Cumulative Median

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

Cumulative Concatenation

Concatenate the values in a dataset up to each row or column to form a single string.

Cumulative Quantile

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

Cumulative Kurtosis

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

Cumulative Skewness

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

Cumulative Standard Deviation

Computes the cumulative standard deviation in a dataset up to each row or column.

Cumulative Variance

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

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