Forum Discussion

alvaro037's avatar
alvaro037
Copper Contributor
Oct 19, 2022
Solved

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 ...
admin
BI & Data Analysis
Charting
excel
Formulas and Functions
office 365
Office Scripts
  • 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.

alvaro037's avatar
alvaro037
Copper Contributor
Oct 19, 2022

Thanks everyone JKPieterse  HansVogelaar  JoeUser2004 mtarler  Nothing_Left_to_Lose 

I've attached the data I have below. I like the approaches of mtarler and I think it would suits best with my data. I'm not familiar in anyway in VBA so I don't know how to replicate this for multiple dataset. The attached file have what I imagine easily useable.

 

https://itsacid-my.sharepoint.com/:x:/g/personal/muhammadalvaro_19025_student_its_ac_id/EXx9LrD-SMNItCrij9z-Oo0BoDstilAJ5cO9upnbuuRSgw?e=NtI6Wi

HansVogelaar's avatar
HansVogelaar
MVP
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