Microsoft Tech Community is in Read Only mode.  Please enjoy browsing our content while we complete our platform upgrade.

Forum Discussion

alvaro037's avatar
alvaro037
Copper Contributor
Oct 19, 2022

Selecting Data with Minimum Standard Deviation

Hi everyone,  I'm working on a project but the data collected is more than needed, so I need to choose data with the minimum deviation or least error.  Example :  Thickness of material A with 10x ...
  • HansVogelaar's avatar
    HansVogelaar
    Oct 19, 2022

    alvaro037 

    In the attached version, I have implemented my VBA algorithm (with StDev_P instead of StDev_S) as a custom function. It is used in an array formula confirmed with Ctrl+Shift+Enter to return the selected values.

Resources