How to get the average bin from a set of data

**excellennt_excel** · 08-24-2022, 10:42 AM

Hi,

I have the following dataset. I want to find the average bin of the two datasets to compare.

The bins are 0-9 as shown in the photo with values in each bin. The two datasets are "O" and "N".

data.jpg

So between the "O" and "N", more values are in the 0-2 range compared to the "O" dataset.

How can I best project this as an improvement in the N dataset?

Say something like average bin value for O dataset is 5-6 and average value for N dataset is 2-3?

Is there any tool in Excel that will help with this?

Thanks.

**MrShorty** · 08-24-2022, 10:56 AM

There are probably multiple possible tools to help, but you need to understand enough of the details of the analysis in order to choose which tools/functions will be useful. For example, you talk about wanting to find the "average bin" with no indication of what "average bin" means in your analysis. The analysis seems to center on what average bin means, how you intend to calculate it, then using that to show that there is some kind of significant difference between N and O. Without knowing the conceptual and computational details of this analysis, it is difficult to know which of Excel's tools/functions to recommend.

**Jameswalter** · 08-26-2022, 03:36 AM

Take the median number between each bin, multiply it by the current representation (%) of each bin, and take the sum of the results. example: If the true data set is for example (5,7,6,4,8,6,2,3,7,6) with a true average of 5

**AliGW** · 08-26-2022, 03:44 AM

@Jameswalter

Everything you post has been copied and pasted from the Internet and is only vaguely relevant to the thread in question.

Please desist if you wish to remain a member of this forum. Thank you.

How to get the average bin from a set of data

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

How to get the average bin from a set of data

Re: How to get the average bin from a set of data

Re: How to get the average bin from a set of data

Re: How to get the average bin from a set of data

Thread Information

Users Browsing this Thread

Similar Threads

how to have rolling average data, but keep data blank for future data

[SOLVED] Average formula needed to get average data

Average data between two dates, and only average data between specific hours

Grouping data to find average value of related data on big data set

Overall Average using the result of the average without referencing back to the raw data

Select rows of data to average base upon data being populated in adjacent cell

Bookmarks

Bookmarks

Posting Permissions