ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Binodal distribution (https://www.excelbanter.com/excel-discussion-misc-queries/36498-binodal-distribution.html)

Ian

Binodal distribution
 
I need to find the position of the second node in a binodal distribution
using pivot tables. Normally I create the pivot and set the summary by: to
average. I wish I could set it to trimmean and this would be close enough.
Any idea how to customarize the summarize by function or another equation to
find the location of a peak in a binodal distribution?


All times are GMT +1. The time now is 01:32 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com